I have a problem with my application running in jboss 4.2.2. I recive randomly the following error:
java.sql.SQLException: The result set is closed. at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkState(WrappedResultSet.java:1939) at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1181)
<local-tx-datasource> <jndi-name>myDS</jndi-name> <connection-url>jdbc:microsoft:sqlserver://dbserver:1433;SelectMethod=cursor;DatabaseName=myDBSchema</connection-url> <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> <user-name>user</user-name> <password>password</password> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <min-pool-size>1</min-pool-size> <max-pool-size>10</max-pool-size> <idle-timeout-minutes>15</idle-timeout-minutes> <blocking-timeout-millis>5000</blocking-timeout-millis> <!-- sql to call on an existing pooled connection when it is obtained from pool <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>MS SQLSERVER2000</type-mapping> </metadata> </local-tx-datasource>
Setting the property
<track-statements>false</track-statements>
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.