Deploying to Oracle

[william_ferguson_au]

Hi,

 

I'm attempting to get jasperIntel running against an Oracle (9) database. I have converted the jasperserverCreate.ddl from MySql to Oracle, and copnfigured the context xml and hibernate properties to use the appropriate driver and dialect, but the problem I am having is that a "Resource" table is defined which is a reserved word in Oracle.

 

I have managed to create a "Resource" table by quoting all instances of it in the DDL, but JasperIntel falls over at runtime because the SQL generated by hibernate doesn't quote "RESOURCE" then.

 

Any ideas of how I can get it to do it?

[swood]

There is a patch for this at http://jasperforge.org/sf/go/artf1204?nav=1

 

I renamed the tables and columns so that Oracle was happy.

 

 

Sherman

JasperSoft

[william_ferguson_au]

Thanks Sherman, that worked nicely.