I've got the following exception when using H2:
org.h2.jdbc.JdbcSQLException: The object is already closed [90007-100]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.message.Message.getSQLException(Message.java:149)
at org.h2.util.SmallMap.getObject(SmallMap.java:90)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:
330)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:127)
at java.lang.Thread.run(Thread.java:619)
at org.h2.engine.SessionRemote.done(SessionRemote.java:493)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)
at
org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:397)
at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1035)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
2)
at
org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:212)
I have no idea about which object is supposed to be closed. The
function where it happens is pretty big but there's nothing special in
it: it does a SELECT request and execute a lot of small SELECT request
inside a while loop on the result set, it is like this:
PreparedStatement pstmt = connection.prepareStatement(........);
...
ResultSet rs = pstmt.executeQuery();
while(rs)
{
a lot of small request generated from rs content
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
