Oracle support

[FlorianBruckner]

Currently it is not possible to use Oracle as database because of some issue with the mapping. Hibernate will create columns of type LONG for text columns with a length > 4000. This currently applies to GS_RESOURCE and GS_STORED_DATA.

For GS_RESOURCE, table creation will fail because only one LONG column can exist in a Table. GS_STORED_DATA is created, but queries fail because LONG cannot just be read in a SELECT.

A simple fix is to annotate the entity attributes with @lob, allowing Hibernate to create correct tables and generate correct SQL to read. Not sure if @lob will cause issues for other databases, but it shouldn't.

[Gnafu]

Hi, did you use the schema creation script as in the building instructions or did you let Hibernate generate it?

[FlorianBruckner]

Thanks for the feedback - didn't notice the script, I had Hibernate create the schema.