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
>
> 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.
