durdisoft Posted March 30, 2011 Share Posted March 30, 2011 Hello,I have installed JasperReports Server CP 4.0 on Solaris with separate MySQL and Tomcat Server. For an report I add an JDBC Data Source for Oracle DB, but the function "Test Connection" returns "Connection failed".Data Source definition:Driver: oracle.jdbc.pool.OracleDataSourceURL: jdbc:oracle:thin:@[servername]:1521:[DB]The same definition works on JasperServer 3.7. The driver is located .../tomcat6/webapps/jasperserver/WEB-INF/lib/ojdbc.jar. I can't se any error message in .../tomcat6/webapps/jasperserver/WEB-INF/logs/jasperserver.log or .../tomcat6/webapps/logs/catalina.outHave anybody an idea how to debug or fix the problem?Regardsdurdi Link to comment Share on other sites More sharing options...
sjongenelen Posted March 30, 2011 Share Posted March 30, 2011 I think you should place the driver in a different folder, dont have time to check it now but you might try to place it a bit 'higher' (@tomcat level, not webapp level) also, there are 2 'accepted' oracle url connection strings syntax's: jdbc:oracle:thin:[user/password]@[host][:port]:SIDjdbc:oracle:thin:[user/password]@//[host][:port]/SID you might try those :) (source: http://www.herongyang.com/JDBC/Oracle-JDBC-Driver-Connection-URL.html) Link to comment Share on other sites More sharing options...
durdisoft Posted March 30, 2011 Author Share Posted March 30, 2011 I there maybe an difference between JS 3.7 and JS 4.0? Because the same definition works on JS 3.7.I have put the jar into .../tomcat6/lib directory too, but it still doesn't work.Have you an idea how I can debug the issue?Regardsdurdi Link to comment Share on other sites More sharing options...
durdisoft Posted March 30, 2011 Author Share Posted March 30, 2011 I also tryed the 2 various syntax's for the connection string, but without success. Regards durdi Link to comment Share on other sites More sharing options...
sjongenelen Posted March 31, 2011 Share Posted March 31, 2011 Also, you should delete the old .bin files with the old drivers (if there is any) unfortunately i dont know how to debug; no logfiles in "C:\Program Files (x86)\jasperreports-server-4.0\apache-tomcat\logs" ? Link to comment Share on other sites More sharing options...
durdisoft Posted April 1, 2011 Author Share Posted April 1, 2011 Logfiles are available under .../tomcat6/webapps/jasperserver/WEB-INF/logs/jasperserver.log and.../tomcat6/webapps/logs/catalina.ou, but I can't see any entry for this issue.Has anybody an idee with settings I can made in "Manage -> Log Settings"?Maybe I can define the right object/library to print messages during I test the jdbc connection.Regardsdurdi Link to comment Share on other sites More sharing options...
colddata Posted April 8, 2011 Share Posted April 8, 2011 I am having the same issue with connection to Oracle Database. The MySQL connection worked fine. Link to comment Share on other sites More sharing options...
jgh Posted April 9, 2011 Share Posted April 9, 2011 The jar needs to be under tomcat: /usr/local/tomcat6/lib/restart tomcat Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now