[Persistence, JBoss/CMP, Hibernate, Database] - valid hibernate session from Dao
by jnl
hi All...
I'm using hibernate 3.2.2ga, jboss 4.0.5.ga, jdk 1.5. I'm trying to run a stored proc (and a query) within my daoImpl class but it's throwing an "unknown connection2" error. The full stack is below. Searching around jboss, I found this site....
http://wiki.jboss.org/wiki/Wiki.jsp?page=IGetquotTryingToReturnAnUnknownC...
but it states it's only a hibernate 2 issue. The code is being executed within a callback. I also tried without the callback. My daoImpl extends org.springframework.orm.hibernate3.support.HibernateDaoSupport. below is the code and stack. any help would be appreciated..
thanks in advance..jim
public java.util.Set findVolunteers(final int transform, final java.lang.String queryString, int pageNumber, int pageSize, final java.lang.String firstName, final java.lang.String lastName, final java.lang.String phoneNumber, final java.lang.String status, final java.lang.Boolean requiresFollowUp)
| {
|
| org.springframework.orm.hibernate3.HibernateCallback callback = new org.springframework.orm.hibernate3.HibernateCallback()
| {
| final java.util.Set volunteers = new java.util.HashSet();
| java.sql.PreparedStatement stmt = null;
| java.sql.ResultSet rs = null;
| org.dcri.recruit.VolunteerSearchObject searchObject = null;
|
|
| public Object doInHibernate(org.hibernate.Session session)
| throws org.hibernate.HibernateException
| {
| try {
|
| // Get the connection from hibernate
| Connection conn = session.connection();
| stmt = conn.prepareStatement(query);
|
|
| rs = stmt.executeQuery();
|
| // Process the results
| while (rs.next())
| {
| .....
| }
| }
| catch (Exception e) {
| e.printStackTrace();
| throw new java.lang.RuntimeException("Could not execute Volunteer search", e);
| }
| finally {
| try {
| rs.close();
| session.close();
| }
| catch (Exception e) {
| e.printStackTrace();
| }
| try {
| stmt.close();
| }
| catch (Exception e) {
| e.printStackTrace();
| }
| }
|
| return volunteers;
| }
| };
| return (java.util.Set)this.getHibernateTemplate().execute(callback);
|
and the stack trace...there's more if that'll help...
java.lang.IllegalStateException: Trying to return an unknown connection2! org.jboss.resource.adapter.jdbc.WrappedConnect
| ion@798797
| at org.jboss.resource.connectionmanager.CachedConnectionManager.unregisterConnection(CachedConnectionManager.jav
| a:342)
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnect
| ionManager.java:606)
| at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:26
| 6)
| at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:129)
| at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectio
| nProvider.java:95)java.lang.IllegalStateException: Trying to return an unknown connection2! org.jboss.resource.adapter.jdbc.WrappedConnect
| ion@798797
| at org.jboss.resource.connectionmanager.CachedConnectionManager.unregisterConnection(CachedConnectionManager.jav
| a:342)
| at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnect
| ionManager.java:606)
| at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:26
| 6)
| at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:129)
| at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectio
| nProvider.java:95)
|
|
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4106026#4106026
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4106026
18 years, 8 months