[daisy] Postgresql 8.x support in Daisy 2.0

[Andreas Deininger]

2007/7/31, Andreas Deininger <adeininger at googlemail.com>:
> 2006/12/8, Robert Cecil <rob.cecil at gmail.com>:
> > I noticed the community scratchpad entry for Postgresql installation:
> > http://cocoondev.org/daisyscratchpad/g3/212.html, and I seem to
> > remember a Jira issue in which Bruno was the last to comment on
> > someone working towards either Postgresql 8.0 or 8.1. Can anyone tell
> > me if they have gotten Daisy 2.0 (or Daisy 1.5) to work with Pgsql
> > 8.0 or 8.1 (or 8.2) ??
> >
> > Anyone fulfilling Steven's comment:  (posted Jan 06) ?
> > >
> > > True, Andreas, but we don't have the resources at the moment to
> > > fully support databases pther than MySQL. PostgreSQL support is
> > > available thanks to users like you, but it's hardly a first-class
> > > citizen like MySQL. Now, if someone would step up with the serious
> > > offer to continuously maintain Postgres, that would be great.
>
> I just uploaded a patch for PostgreSQL compatibility. WIth that patch
> applied, the installation routine of daisy now works with PostgreSQL
> also. On a first glance, everything runs smoothly. However, I ran the
> repository test cases and still got some errors.

Several errors turned to be out errors in the testcases itself ( see DSY-518)

The following issues remain:

* the function Right() of daisy query language does not work (DSY-517)

* LocalDerefTest:
Query: select name where documentType='Doctype4' and $Link=>$MultiHier
has none (Path('a1/a2/a3'), Path('b1/b2'), Path('c1'))
expected:<0> but was:<1> (rows in search result)

select name where documentType='Doctype4' and $Link=>$MultiHier has
none (Path('x1/x2/x3'), Path('y1/b2'))
expected:<1> but was:<2> (rows in search result)

* LocalQuery2Test:
select versionState where versionState = 'publish' and id = xxx
expected:<[Publizieren]> but was:<[publish]>

* LocalWorkflowTest:

Testcase: testWorkflow(org.outerj.daisy.repository.test.LocalWorkflowTest):	Caused
an ERROR
Error querying tasks.
org.outerj.daisy.workflow.WorkflowException: Error querying tasks.
	at org.outerj.daisy.workflow.serverimpl.CommonWorkflowManager.executeJbpmRunnable(CommonWorkflowManager.java:1419)
	at ...
Caused by: org.hibernate.QueryException: ClassNotFoundException:
org.hibernate.hql.ast.HqlToken [select distinct rti from
org.jbpm.taskmgmt.exe.TaskInstance rti where rti.actorId is null  and
rti.isOpen = :x0  and  swimlaneInstance.pooledActors.actorId in ( :x1
) ]
	at org.hibernate.hql.ast.HqlLexer.panic(HqlLexer.java:57)
	at antlr.CharScanner.setTokenObjectClass(CharScanner.java:338)
...

* RemoteNavigationTest

Error building navigation tree  {document ID 12-DSYTEST, branch ID 1,
language ID 1}
org.outerj.daisy.navigation.NavigationException: Error building navigation tree.
        ... 25 more
Error extracting text from part data (document: 12-DSYTEST, branch ID:
1, language ID: 1, part ID: 1)
org.xml.sax.SAXParseException: Premature end of file.
        at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
Source)
        at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)
...

> If I can be sure that
> my patch will be reviewed (and eventually applied) I will look into
> these issues.

Can we make any progress on that? IMHO, postgresql support can only be
improved since it is still in the codebase, but not in a working
state.

Thanks
Andreas