I ran the same test with a sun jdk 1.7.0 and everything worked as expected.
This seems to be an issue with sun jdk 1.6.0 -Vinaya On Thu, Dec 22, 2011 at 5:28 PM, Vinaya Kumar Thimmappa < [email protected]> wrote: > Hello Noel, > Thanks for the response. I don't have any code where i say "Close". > > The stack happens when i use sun jdk 1.6.0 and during execution of > statement "prepareStatement.executeBatch" > Note: if i change jvm flavour to open-java, then everything works fine. > > Trace.db file contents are as below > > > Select * from StagedBag [42102-162] > 12-22 00:08:31 jdbc[2]: exception > org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement: > Insert into StagedBag values(?, ?, ?, ?, ?, ?, ?, ?, ?, > > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) > [90108-162] > at org.h2.message.DbException. > getJdbcSQLException(DbException.java:329) > at org.h2.message.DbException.get(DbException.java:158) > at org.h2.message.DbException.convert(DbException.java:275) > at org.h2.command.Command.executeUpdate(Command.java:230) > > at > org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092) > at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67) > > -Vinaya > > > On Thu, Dec 22, 2011 at 5:20 PM, Noel Grandin <[email protected]>wrote: > >> >> yes. some part of your code closed the database connection. >> >> Vinaya wrote: >> > Hello All >> > org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162] >> > at >> > org.h2.message.DbException.getJdbcSQLException(DbException.java:329) >> > at org.h2.message.DbException.get(DbException.java:169) >> > at org.h2.message.DbException.get(DbException.java:146) >> > at org.h2.message.DbException.get(DbException.java:135) >> > at org.h2.engine.Database.checkPowerOff(Database.java:433) >> > at org.h2.command.Command.executeUpdate(Command.java:237) >> > at >> > >> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java: >> > 143) >> > at >> > >> org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java: >> > 1092) >> > >> > I am getting the above error when trying to insert 1 million rows each >> > having 34 columns of Strings >> > >> > Any clue what could be the reason ? >> > >> > Thanks >> > Vinaya >> > >> >> > -- 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.
