Issue migrated from: https://sourceforge.net/tracker/index.php?func=detail&aid=1486078&group_...
Tony, this is a 7 in sf.net, we do not have that category of issue on sfee. Hopefully 5 is ok.
[ 1482022 ] [iReport plugin/Web Services] unable to connect
Submitted By: Daryl - daryld
Date Submitted: 2006-05-04 10:58
Last Updated By: sgwood - Settings changed
Date Last Updated: 2006-05-05 13:51
Number of Comments: 0
Number of Attachments: 0
Assigned To: T Kavanagh
[iReport plugin/Web Services] unable to connect
When attempting to connect to server from iReport, received the following error:
Error: 1 - Could not open Hibernate Session for transaction; nexted exception is
org.hibernate.exception.GenericJDBCException: Cannot open connection
jasperserver 0.9.2 (linux installer.bin)
I followed the "JasperServer Web Services War InstallGuide Date: 04-24-06" instructions.
I edited the
webapps/jasperserver-ws/META-INF/context.xml file with the username and password I needed. When I attempted the
connection from iReport, the catalina.out log file showed the error "MESSAGE: Access denied for user 'root'@'localhost'
(using password: YES)".
I am not too familiar with Tomcat but what seems to have happened is that the context.xml was cached by
Tomcat at the time that it opened up the .war file.
Rather then editing the context.xml file mentioned above and in the documentation, edited the file:
Once I had the correct username and password in this file, the above error no longer occurred when
connecting to the server.
No follow-up comments have been posted.
Name Description Download
No Files Currently Attached
Field Old Value Date By
assigned_to nobody 2006-05-05 13:51 sgwood
Teodor Danciu: 02/20/2007 7:33 AM PST
This should be reopened or reposted as a bug in case we face it again, if ever.
Closed set to 02/20/2007
Status changed from Open to Closed