Somewhere you have code that is trying to read from a ResultSet after the connection has been closed.
On 2013-05-13 14:56, davide.cavestro wrote:
Hi, I've configured a H2 XA datasource to be orchestred by JBossTS. Sometimes I get some failures complaining /Caused by: org.h2.jdbc.JdbcSQLException: The object is already closed [90007-169] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.message.DbException.get(DbException.java:135) at org.h2.jdbcx.JdbcXAConnection$PooledJdbcConnection.checkClosed(JdbcXAConnection.java:473) at org.h2.jdbc.JdbcStatement.checkClosed(JdbcStatement.java:930) at org.h2.jdbc.JdbcPreparedStatement.checkClosed(JdbcPreparedStatement.java:1514) at org.h2.jdbc.JdbcStatement.checkClosed(JdbcStatement.java:904) at org.h2.jdbc.JdbcResultSet.checkClosed(JdbcResultSet.java:2948) at org.h2.jdbc.JdbcResultSet.next(JdbcResultSet.java:123)/ or similar (sometimes it fails during /ResultSet.getObject()/). I've seen JdbcXAConnection <http://www.h2database.com/javadoc/org/h2/jdbcx/JdbcXAConnection.html#getTransactionTimeout> implementation always returns 0 as transaction timeout. What do you think? Could it be the cause of my exception? Mine is a huge legacy webapp and I have no easy way to produce a standalone test case, but I can try to reproduce it with another transaction manager and a groovy script if needed. I suppose if I open a transaction and start accessing h2 for a long time, then at some point I get this kind of failures. Cheers Davide -- View this message in context: http://h2-database.66688.n3.nabble.com/JdbcXAConnection-and-transaction-timeout-The-object-is-already-closed-tp4026399.html Sent from the H2 Database mailing list archive at Nabble.com.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
