I have a struts/hibernate webapp that throws exceptions intermittently relating to the connection handle, eg:
2006-05-22 15:04:24,947 DEBUG [org.hibernate.jdbc.JDBCContext] running Session.finalize() 2006-05-22 15:04:24,947 DEBUG [org.hibernate.jdbc.JDBCContext] running Session.finalize() 2006-05-22 15:04:25,913 DEBUG [org.hibernate.transaction.JDBCTransaction] begin 2006-05-22 15:04:25,913 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC begin failed java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(Wrapped Connection.java:528) at org.jboss.resource.adapter.jdbc.WrappedConnection.getAutoCommit(Wrapp edConnection.java:324) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java: 49) at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19) at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:204) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1014) at uk.gov.brightonhove.central.dao.UserDao.getUser(Unknown Source) at uk.gov.brightonhove.central.users.UserAction.setupEditUser(Unknown So
try { Session session = HibernateUtil.currentSession(); Transaction tx = session.beginTransaction(); Query query = session.createQuery("select u from User as u where u.userid = :id"); query.setInteger("id", id.intValue()); u = (User) query.uniqueResult(); tx.commit(); HibernateUtil.closeSession(); } catch (HibernateException he) { System.out.println("getUser: "+he); }