Hi, In the future, please don't re-use old email threads. Please create a new thread.
I guess the JDBC object is already closed. If it's not, could you post a simple, standalone, reproducible test case? Regards, Thomas On Sat, Oct 20, 2012 at 9:19 AM, priyanka <[email protected]> wrote: > hello sir, > > Iam using my localhost connection only then also iam getting the exception > as object already closed > > This is my url > > jdbc:h2:tcp://localhost/~/abc;mvcc=true > > this is the exception iam getting > > 2012-10-20 12:41:22,990 [c-14] DEBUG RPCManager - non-DMI response, > dropExtraFields: false > === 2012-10-20 12:41:23,005 [c-14] ERROR JSTranslater - Error converting > Clob > org.h2.jdbc.JdbcSQLException: *The object is already closed *[90007-169] > > Thanks in advance... > > > On Friday, October 31, 2008 9:05:36 PM UTC+5:30, Thomas Mueller wrote: >> >> Hi, >> >> > PreparedStatement pstmt = connection.prepareStatement(..**......); >> > ... >> > ResultSet rs = pstmt.executeQuery(); >> > while(rs) >> > { >> > a lot of small request generated from rs content >> > } >> >> Most likely the problem is that the result set is closed while >> processing the nested requests. Currently H2 uses a list of 64 open >> JDBC objects per session. Theoretically H2 could use garbage >> collection, but that's slow and not reliable. You can change the limit >> using the system property h2.serverCachedObjects - see also >> http://www.h2database.com/**javadoc/org/h2/constant/** >> SysProperties.html#h2.**serverCachedObjects<http://www.h2database.com/javadoc/org/h2/constant/SysProperties.html#h2.serverCachedObjects> >> >> You can set the limit higher. This shouldn't be a problem unless you >> use many connections. >> >> Please tell me if this doesn't solve the problem. >> >> Regards, >> Thomas >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/_3rIC6aaacEJ. > 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. > -- 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.
