[jira] Updated: (GRFT-16) Graffito schema is not create correctly for HSQL

["Shinsuke SUGAYA (JIRA)" <ji...@apache.org>]

     [ http://issues.apache.org/jira/browse/GRFT-16?page=all ]

Shinsuke SUGAYA updated GRFT-16:
--------------------------------

    Attachment: graffito_for_hsql.tar.gz

Attached patch&files for HSQL support. 
Please apply this patch and files, and change HSQL version from 1.7.1 to 1.7.3.3 on J2.

Currently, J2 uses HSQL 1.7.1. But I think HSQL 1.7.1 has a issue related to "OUTER JOIN" 
handling.  So, using HSQL 1.7.1, I could not get the correct folders(ContentStore#getFolders(String))
from Graffito. According to HSQL changelog, JOIN issues seems to be fixed on 1.7.2. I tried 
version 1.7.3.3, and it works. So, in my opinion, Graffito has to use 1.7.3.3 for HSQL 
support(I think 1.7.2 is also okay, but I do not try it), and, in J2, I think J2 team needs 
to update the version from 1.7.1. 
If Graffito team consider other solutions, I think code change(ex. "OUTER JOIN" is not used) may be needed.

> Graffito schema is not create correctly for HSQL
> ------------------------------------------------
>
>          Key: GRFT-16
>          URL: http://issues.apache.org/jira/browse/GRFT-16
>      Project: Graffito
>         Type: Bug
>   Components: OJB Store
>     Reporter: Christophe Lombart
>     Assignee: Christophe Lombart
>      Fix For: 1.0-a1-dev
>  Attachments: graffito_for_hsql.tar.gz
>
> The maven goal "db.scripts.gen" doesn't create correctly the sql scripts for HSQL. The type "OBJECT" is not used for binary columns. The problem seems to come from Torque. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira