Jump to content
Changes to the Jaspersoft community edition download ×

Not able to plug-in to jasper server from ire


ktrinad

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...