Connecting -JasperServer & Oracle

[2006 IR Open Discussion]

By: spoorthi - spoo_anu

Connecting -JasperServer & Oracle

2006-06-22 21:28

Hi,

 

Am shivaraj currently working for infosys,

 

presently am working on jasperserver....

 

my problem is simple

 

am trying to connect the jasper server to oracle databse ...

 

presently the jasper server system is using default MYSQL database for user-role management and for updation.

 

Now am trying for making the jasper server to completely interact with the Oracle database ...

For this i have made modification in

 

context.xml --------altered connection strings

 

hibernate.properties------- changed the dialect class

 

For am getting the following exception

SQL state

some oracle....error -----Invalid table name

 

Here the major problem is there is a table in mysql database called User used by the jasper server system.

This table cannot be created in oracle, becoz it is a reserved word in oracle.If i create alternate table i need to modify it in the jasper server product core functionality itself .... which might be a critical approach..

 

Also tell me how i can get the source code for jasper server ?

 

 

 

plz try to understand my problem specifically if possible try send the solution as early as possible....

 

with thanks and regards

SHIVARAJ

spoo_anu@rediffmail.com

 

 

 

 

 

 

 

 

 

By: M d ric RIBREUX - medspx

RE: Connecting -JasperServer & Oracle

2006-06-24 02:12

We gat exactly the same problem with postgreSQL. Actually, by using a table named "User", I was able to create a complete database but I've got the same error than you: jasperserver cannot run with such a named table...

But perhaps the new release will fix it !

 

 

By: Sherman Wood - sgwood

RE: Connecting -JasperServer & Oracle

2006-06-24 10:44

 

You can change the Hibernate mappings to deal with these DBMS specific naming issues. In 0.9.2, we used XDoclet to generate some of the mappings. In 1.0.0, which we are wrapping up now, the mapping files are not genrated and are in a separate JAR, so you can change everything for your particular DBMS.

 

 

Sherman

JasperSoft