Adding Data Source Oracle JDBC to Jasper Server failed

[florian.johannssen]

Hi folks,

I have deployed my jasper server via: executing the js-install-ce.sh minimal as web application inside a jboss which is locacted on a linux maschine.

When I try to create a new JDBC Oracle Datasource I get the followining error after uploading the Oracle Driver: ojdbc6.jar

Does anyone know what is wrong? Thanks for any suggestions.

Best Regards

Florian

 

 

[stasp]

Hello Florian,

 

The exception you are getting usually means exactly what it says: application cannot insert value into database for some reason. Does your database user have enough permissions to modify the Jasperserver repository database? Is it possible that there are soem storage constraints preventing you from adding a jar file to database?

 

Also it might be helpful to check Jasperserver log file, which is <js-webapp>/WEB-INF/logs/jasperserver.log. There should be full stack trace of the exception you are getting, which may provide some additional hints.

 

- Stas

[hozawa]

Are you using MySQL for repository database? There's a setting in my.ini that by default sets limitation on the size of file that may be uploaded. Log should state the setting necessary.

 

Another way is to just put ojdbc.jar in Tomcatlib folder and restart tomcat.

[starkanimozhi]

Hi,

 

Did you get solution for your question