Hm, I deleted my database and tried again. No joy. Seems to be
sporadic.
On Oct 4, 4:36 pm, Steve McLeod <[email protected]> wrote:
> I just gave 1.2.120 a trial in my application. It zoomed along at
> first, faster than previous versions. But then this exception came...
>
> org.h2.jdbc.JdbcSQLException: General error:
> java.lang.ClassCastException: org.h2.index.PageDataLeaf cannot be cast
> to org.h2.index.PageBtree; SQL statement:
> insert into gameplayersummary (gameid, playerid, playername,
> seatnumber, stakelevelid, positionid, tournamentid, buyin, casinoid,
> gametypeid, tableid, tablename, dayid, isplaymoney, istournament,
> isHero, startTime, tableSize, takeInCents, showdowntakeInCents,
> nonshowdowntakeInCents, takeInBigBlinds, downcard1, downcard2, flop1,
> flop2, flop3, turn, river, handType, numPlayersSittingIn, timesseen,
> flopseen, vpip, preflopraised, postflopbet, postflopcalled,
> postflopfolded, postflopraised, postflopBetOrRaised,
> postFlopCallFoldBetOrRaise,blindStealAttempt,
> blindStealAttemptOpportunity, checkRaised, checkRaisedOpportunity,
> wentToShowdown, wonAtShowdown, wonWithoutShowdown, threeBetPreflop,
> threeBetPreflopOpportunity,blindStealDefenseOpportunityOnBigBlind,
> calledPreflopRaise,
> calledPreflopRaiseOpportunity,continuationBetPreflop,
> continuationBetPreflopOpportunity,foldedToBlindStealOnBigBlind,foldedToContinuationBet,
> foldedToContinuationBetOpportunity,foldedToPreflopThreeBet,
> foldedToPreflopThreeBetOpportunity) values
> (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?,
> 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?)
> [50000-120]
> at org.h2.message.Message.getSQLException(Message.java:106)
> at org.h2.message.Message.convert(Message.java:283)
> at org.h2.table.TableData.addRow(TableData.java:151)
> at org.h2.command.dml.Insert.update(Insert.java:100)
> at org.h2.command.CommandContainer.update(CommandContainer.java:72)
> at org.h2.command.Command.executeUpdate(Command.java:208)
> 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)
> ... 20 more
> Caused by: java.lang.ClassCastException: org.h2.index.PageDataLeaf
> cannot be cast to org.h2.index.PageBtree
> at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:129)
> at org.h2.index.PageBtreeNode.getRowCount(PageBtreeNode.java:350)
> at org.h2.index.PageBtreeNode.getRowCount(PageBtreeNode.java:351)
> at org.h2.index.PageBtreeNode.init(PageBtreeNode.java:267)
> at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:97)
> at org.h2.table.TableData.addRow(TableData.java:132)
> ... 27 more
>
> I'll see if it is reproducible.
>
> Regards,
>
> Steve McLeod
>
> On Oct 4, 4:27 pm, Thomas Mueller <[email protected]>
> wrote:
>
> > Hello,
>
> > A new version of H2 is available athttp://www.h2database.com
> > (you may have to click 'Refresh').
>
> > Changes and new functionality:
> > - This is a beta version.
> > - New databases are now stored in a new file format.
> > Existing databases are kept in the old file format.
> > - Databases created by this version can not be opened with older versions.
> > - In version 1.2, the following system properties are enabled by default:
> > h2.pageStore, h2.nullConcatIsNull, h2.optimizeInList.
> > - PostgreSQL compatibility: function LASTVAL() as an alias for IDENTITY().
> > - Linked tables now support default values when inserting, updating or
> > merging.
> > - Possibility to set a vendor id in Constants.java.
> > - Allow writing to linked tables in readonly databases.
>
> > Bugfixes:
> > - Issue 125: Renaming primary keys was not persistent. Fixed.
> > - Issue 124: Hibernate schema validation failed for decimal/numeric columns.
> > - Bugfixes in the page store.
>
> > For details, see the 'Change Log'
> > athttp://www.h2database.com/html/changelog.html
>
> > For future plans, see the 'Roadmap' page
> > athttp://www.h2database.com/html/roadmap.html
>
> > P.S. If you reply to this message please use a different subject.
>
> > Have fun,
> > 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
-~----------~----~----~----~------~----~------~--~---
