[#1371] - [iReport plugin/Web Services] unable to connect

Category:
Bug report
Priority:
Low
Status:
Closed
Project: Severity:
Trivial
Resolution:
Fixed
Component: Reproducibility:
Always
Assigned to:

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
Priority: 5

Summary:
[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

Versions:
iReport 1.2.2
jasperserver 0.9.2 (linux installer.bin)
jasperserver-ws 0.9.2

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.

Workaround:
Rather then editing the context.xml file mentioned above and in the documentation, edited the file:
.../jasperserver-0.9.2/apache-tomcat/conf/Catalina/localhost/jasperserver-ws.xml

Once I had the correct username and password in this file, the above error no longer occurred when
connecting to the server.

Followups:

No follow-up comments have been posted.

Attached Files:
Name Description Download
No Files Currently Attached

Changes:

Field Old Value Date By
assigned_to nobody 2006-05-05 13:51 sgwood

Teodor Danciu: 02/20/2007 7:33 AM PST
Comment:

Hi,

This should be reopened or reposted as a bug in case we face it again, if ever.

Thank you,
Teodor

Action: Update
Closed set to 02/20/2007
Status changed from Open to Closed

tcloonan's picture
1597
Joined: Dec 22 2006 - 1:13am
Last seen: 15 years 5 months ago
Feedback