[daisy] Postgresql 8.x support in Daisy 2.0

[Bruno Dumon]

Andreas,

I suggest you create jira issues for each of the problems mentioned in
this mail. Seems like some of them are not posgresql related.

I'm not able to immediately spend time on this. Postgresql-specific
issues are low priority for me, my top database-related issue is DSY-362
[1]. However, as time permits I'll try to look at your patches.

[1] http://issues.cocoondev.org/browse/DSY-362

On Wed, 2007-08-01 at 11:09 +0200, Andreas Deininger wrote:
> 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
-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org