Thanks for the pointer Thomas, I'll compile an H2 with the constant tweaked. You are correct, I am running client/server, though with both ends in the same JVM. I also tried to construct a minimal test case and was not able to repeat it, so I need to get a better picture of my situation.
Jim On Sep 3, 6:46 am, Thomas Mueller <[email protected]> wrote: > 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.l... > > 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.
