Hi,
What is your database URL? It looks like you are using the server
mode. In this case, a temporary object is create on the client side
(relative to the current working directory), so that the client
doesn't run out of memory. Unfortunately, this currently can't be
disabled using a system property, because it is hardcoded in
Constants.DEFAULT_MAX_LENGTH_CLIENTSIDE_LOB. I will create a system
property for it. Currently, to disable it, you would need to use the
experimental "lob in database" feature:
http://h2database.com/javadoc/org/h2/constant/SysProperties.html#h2.lobInDatabase
In my test case, however I can't reproduce the exception:
Class.forName("org.h2.Driver");
DeleteDbFiles.execute("data", null, true);
Server s = Server.createTcpServer().start();
Connection conn = DriverManager.getConnection(
"jdbc:h2:tcp://localhost/data/test");
Statement stmt = conn.createStatement();
ResultSet rs = null;
stmt.execute(
"create table TEST (ID int, data clob)");
stmt.execute(
"insert into TEST values (1, space(1000000))");
rs = stmt.executeQuery(
"select * from test");
while(rs.next());
conn.close();
s.stop();
Regards,
Thomas
--
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.
