Hey Thomas,
here are contents of trace file
12-21 23:56:05 jdbc[2]: exception
org.h2.jdbc.JdbcSQLException: Table "STAGEDBAG" not found; SQL statement:
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)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
Caused by: java.lang.OutOfMemoryError: Java heap space
at org.h2.value.Value.cache(Value.java:346)
at org.h2.value.ValueString.get(ValueString.java:127)
at org.h2.store.Data.readValue(Data.java:767)
at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:600)
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:330)
at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97)
at org.h2.index.PageDataCursor.next(PageDataCursor.java:49)
at org.h2.index.IndexCursor.next(IndexCursor.java:238)
at org.h2.table.TableFilter.next(TableFilter.java:353)
at org.h2.command.dml.Select.queryGroup(Select.java:311)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:613)
at org.h2.command.dml.Query.query(Query.java:297)
at org.h2.command.dml.Query.query(Query.java:267)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.ddl.Analyze.analyzeTable(Analyze.java:101)
at org.h2.table.RegularTable.analyzeIfRequired(RegularTable.java:404)
at org.h2.table.RegularTable.addRow(RegularTable.java:153)
at org.h2.command.dml.Insert.insertRows(Insert.java:124)
at org.h2.command.dml.Insert.update(Insert.java:84)
at org.h2.command.CommandContainer.update(CommandContainer.java:73)
at org.h2.command.Command.executeUpdate(Command.java:226)
... 6 more
12-22 00:08:31 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
12-22 00:08:32 jdbc[2]: exception
org.h2.jdbc.JdbcBatchUpdateException: The database has been closed
[90098-162]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1107)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
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)
at com.ariba.catalog.data.DBUtil.insert(DBUtil.java:67)
at com.ariba.catalog.data.DBUtil.readDataFromCSV(DBUtil.java:155)
at H2Test.doWork(H2Test.java:55)
at H2Test.main(H2Test.java:23)
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: The database has been closed [90098-162]
org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement:
Insert into StagedBag values(?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[90108-162]
On Thu, Dec 22, 2011 at 4:58 PM, Vinaya Kumar Thimmappa <
[email protected]> wrote:
> Hello Thomas,
>
> Thanks for the information.I was running this on Windows 7. is there limit
> on file size in on this OS ?
>
> I re-ran the same code with a different JVM flavour(earlier used sun jdk
> 1.6.0) which is available on ubuntu latest version and it worked fine.
>
>
> vinaya
>
> On Thu, Dec 22, 2011 at 1:17 PM, Thomas Mueller <
> [email protected]> wrote:
>
>> Hi,
>>
>> The exception message only says the database was closed. Could you also
>> post the contents of the file h2Test.trace.db? Maybe it contains more info.
>>
>> H2 supports larger databases (see the FAQ), but possibly the file system
>> you use only supports files up to 8 GB size. In that case, you can use the
>> 'Split File System' - see the docs (Advanced - Split File System).
>>
>> 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.
>>
>
>
--
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.
