Not able to plug-in to jasper server from ire

[ktrinad]

By: mardaraj - mardaraj

Not able to plug-in to jasper server from ire

2006-07-17 04:38

Hi all,

please give me a solution , i ahve installed ireports 1.2.2 and trying to plugin to jasper server from i reports but it gives error as

" could not open Hibernate session for transaction ;nested exception is org.hibernate.exception.GenericJDBCException" Canot open connection."

 

Please find the stack trace as follows,

 

Attempted reconnect 3 times. Giving up.)

16:57:42,360 ERROR ManagementService,http-80-Processor23:87 - error logging in with tomcat/tomcat

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hib

ernate.exception.GenericJDBCException: Cannot open connection

org.hibernate.exception.GenericJDBCException: Cannot open connection

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:363)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:122)

at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125)

at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)

at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309)

at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:515)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:28

 

Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Server connection failure during transactio

n. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)'.

 

** BEGIN NESTED EXCEPTION **

 

java.sql.SQLException

MESSAGE: Access denied for user 'root'@'localhost' (using password: YES)

 

STACKTRACE:

 

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)

at com.mysql.jdbc.Connection.<init>(Connection.java:1485)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)

at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:360)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:122)

at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125)

at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)

at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309)

at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:515)

 

 

 

By: Javy Dreamer - javydreamercsw

RE: Not able to plug-in to jasper server from ire

2006-07-17 05:07

Did you verify the username and password?

 

What version of JI do you have? JI 1.0.0?

 

If not remeber that you need to cchange some files in which the username and password are specified. The error looks like that file with default values.

 

 

By: mardaraj - mardaraj

RE: Not able to plug-in to jasper server from ire

2006-07-17 07:50

hi,

I am very new to jasperserver and irports,i coludnt get term JI ,colud you please let me know about JI.

 

The configuration set up i have done is,

 

Deployed jasperserver and jasperserver-ws in tomcat 5.5 and made changes to context.xml in <insatlle_di>webappsjasperserver-wsMETA-INFcontext.xml for resource name .

 

please find below my context.xml

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="10000"

username="root" password="jasperadmin" driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/jasperserver?autoReconnect=true"/>

 

Thanks and regards,

mardaraj