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?
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?
2 Answers:
Posted on August 29, 2006 at 2:07pm
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
I renamed the tables and columns so that Oracle was happy.
Sherman
JasperSoft
