Recently We moved our application to DB2 and Jboss 3.2.3 from MS SQL.  Since then I 
have begun to receive the following error consistently in the same place:

Caused by: java.sql.SQLException: Connection handle has been closed and is unusable
  |     at 
org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:771)
  |     at 
org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:756)
  |     at 
org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:136)
  |     at com.marketron.common.persistence.Record.read(Record.java:87)
  |     ... 101 more

I've seen several proposed solutions from Google, such as:

<check-valid-connection-sql>select * from 
ar_setup_general</check-valid-connection-sql>   
                <min-pool-size>0</min-pool-size>

But when I put in these changes I still receive the exception.  Anybody have any ideas 
on this?

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

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


-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to