Hi, 

I am facing a problem while making my http session persistent (session.ser is 
created)

Caused by: java.sql.SQLException: Connection handle is not currently associated 
with a ManagedConnection 
  |         at 
org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:539)
 
  |         at 
org.jboss.resource.adapter.jdbc.WrappedConnection.getAutoCommit(WrappedConnection.java:327)
 
  |         at 
org.hibernate.jdbc.ConnectionManager.isAutoCommit(ConnectionManager.java:185) 
  |         at 
org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:232) 
  |         ... 35 more 

I am using mysql as backend database with hibernate and done Jndi binding of 
datasource as well as hibernate session factory and packaged all in har archive 
file. 
when i try to run my application i get session is closed error!!!!! 

I make temprorarily working of my application by creating new session if i 
found session closed. 

Now i wanted persistent http sessions and my all objects which i want to put in 
session are serailizable.When i run my application i got above mentioned 
error.... 


12:15:25,343 ERROR [JDBCExceptionReporter] Connection handle is not currently 
associated with a ManagedConnection 
  | 12:15:25,343 ERROR [STDERR] org.hibernate.exception.GenericJDBCException: 
could not inspect JDBC autocommit mode 
  |         at 
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
 
  |         at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) 
  |         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 
  |         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
 
  |         at 
org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:241) 
  |         at 
org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:419) 
  |         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1119) 
  |         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) 
  | 
  | 
  | 
  | 12:15:25,218 WARN  [TxConnectionManager] Connection error occured: [EMAIL 
PROTECTED] [EMAIL PROTECTED] handles=1 lastUse=1150785668218 permit=true 
trackByTx=false [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] 
txSync=null] 
  | java.lang.NullPointerException 
  |         at 
org.jboss.mx.loading.RepositoryClassLoader.findClass(RepositoryClassLoader.java:620)
 
  |         at java.lang.ClassLoader.loadClass(ClassLoader.java:289) 
  |         at 
org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoader.java:464)
 
  |         at 
org.jboss.mx.loading.RepositoryClassLoader.loadClass(RepositoryClassLoader.java:405)
 
  |         at java.lang.ClassLoader.loadClass(ClassLoader.java:235) 
  |         at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) 
  |         at 
com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:147) 
  |         at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1283) 
  |         at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349)
 
  |         at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344)
 
  |         at 
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
 
  |         at 
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
 
  |         at 
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
 
  |         at 
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
 
  |         at 
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561) 
  |         at org.hibernate.loader.Loader.doQuery(Loader.java:661) 
  |         at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
 
  |         at org.hibernate.loader.Loader.doList(Loader.java:2145) 
  |         at 
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) 
  |         at org.hibernate.loader.Loader.list(Loader.java:2024) 
  |         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392) 
  |         at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333) 
  |         at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) 
  |         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114) 
  |         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) 



please help

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3951863#3951863

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3951863


_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to