Hi,
I'm using 1.119, with the following database connection URL:
jdbc:h2:/Users/steve/Library/Application Support/Poker Copilot/
database/
pokercopilot;DATABASE_EVENT_LISTENER='com.barbarysoftware.pokercopilot.database.DatabaseListener';MAX_LENGTH_INPLACE_LOB=65536;DB_CLOSE_ON_EXIT=FALSE;COMPRESS_LOB=DEFLATE;LOG=2
This statement:
update GamePlayerSummary set buyin=20 where tournamentid=20
throws the following:
org.h2.jdbc.JdbcSQLException: General error:
java.lang.ArrayIndexOutOfBoundsException: 2096; SQL statement:
update GamePlayerSummary set buyin=? where tournamentid=? [50000-119]
at org.h2.message.Message.getSQLException(Message.java:106)
at org.h2.message.Message.convert(Message.java:283)
at org.h2.command.Command.executeUpdate(Command.java:228)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal
(JdbcPreparedStatement.java:139)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate
(JdbcPreparedStatement.java:128)
at org.springframework.jdbc.core.JdbcTemplate
$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute
(JdbcTemplate.java:591)
at org.springframework.jdbc.core.JdbcTemplate.update
(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update
(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update
(JdbcTemplate.java:858)
at
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update
(SimpleJdbcTemplate.java:237)
at
com.barbarysoftware.pokercopilot.database.SimpleJdbcTemplateWrapper.update
(SimpleJdbcTemplateWrapper.java:275)
at
com.barbarysoftware.pokercopilot.database.HandAdderer.addTournamentSummary
(HandAdderer.java:179)
at com.barbarysoftware.pokercopilot.parser.TournamentParsedData
$1.run(TournamentParsedData.java:30)
at java.util.concurrent.Executors$RunnableAdapter.call
(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun
(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:637)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2096
at org.h2.store.DataPage.writeInt(DataPage.java:141)
at org.h2.result.RowList.writeRow(RowList.java:62)
at org.h2.result.RowList.writeAllRows(RowList.java:106)
at org.h2.result.RowList.add(RowList.java:137)
at org.h2.command.dml.Update.update(Update.java:118)
at org.h2.command.CommandContainer.update
(CommandContainer.java:72)
at org.h2.command.Command.executeUpdate(Command.java:208)
... 17 more
buyin and tournamentid are both ints.
This only happens for certain values of tournamentid. If I delete the
database, create it and populate it again, I'll sometimes still have
these problems but for other values of tournamentid.
I can supply my database with this problem, if it helps. It is 31 MB
compressed.
Regards,
Steve McLeod
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
