org.h2.jdbc.JdbcSQLException

General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: select sum(takeinbigblinds) as takeinbigblinds from PlayerSummary f where f.isHero=true and f.isplaymoney=? and f.istournament=? and f.dayid>=? and f.dayid<? and f.tableSize=? and f.gametypeid=? and buyin=? [50000-124]


Solutions on the web1243

Solution icon of web
via nabble.com by Unknown author, 7 months ago
General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: select sum(takeinbigblinds) as takeinbigblinds from PlayerSummary f where f.isHero=true and f.isplaymoney=? and f.istournament=? and f.dayid>=? and f.dayid<? and f.tableSize=? and f.gametypeid=? and buyin=? [50000-124]

Solution icon of googlegroups
via Google Groups by Steve McLeod, 7 months ago
General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: select sum(takeinbigblinds) as takeinbigblinds from PlayerSummary f where f.isHero=true and f.isplaymoney=? and f.istournament=? and f.dayid>=? and f.dayid<? and f.tableSize=? and f.gametypeid=? and buyin=? [50000-124]

Solution icon of stackoverflow
General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement: delete from FINACLECOREAPPNEWPRREPPAIR1492520606640_SCANNEDLIST where file_path=? and lastModifiedTime=? [50000-171]

Solution icon of web
General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: SELECT bbdata.id, date, player, action, x, y, z, type, data, rbacked, bbworlds.name AS `world` FROM bbdata AS bbdata , bbworlds AS bbworlds , bbusers AS usr WHERE

Solution icon of stackoverflow
General error: java.lang.NullPointerException; SQL statement: DELETE FROM FILES WHERE PATH=? AND CONTAINER_ID=?; [50000-122]

Solution icon of github
General error: java.lang.ArrayIndexOutOfBoundsException: i=4 size=1; SQL statement: select i.folder, i.name from ITEM i where i.repository=? and ((i.type=? or i.type=?) and i.name like ? and regexp_replace(i.folder, '.*[CMFact|PEFact]/', '') in

Solution icon of googlegroups
via Google Groups by Steve McLeod, 1 year ago
Fila no encontrada mientras se intentaba borrar del indice PUBLIC.PLAYERSUMMARY_SHORT_IDX Row not found when trying to delete from index PUBLIC.PLAYERSUMMARY_SHORT_IDX; SQL statement: update PlayerSummary set starttime=?, takeincents

Solution icon of github
General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400754000000"; SQL statement: select this_.id as y0_ from execution this_ where this_

Solution icon of googlegroups
via Google Groups by Daniel Rosenbaum, 1 year ago
General error: "java.lang.NullPointerException"; SQL statement: CREATE VIEW application.OccurrenceAOtherEndophthalmitis40_precondition_391 AS SELECT t150.*, o1.ido1 FROM application.OccurrenceAOtherEndophthalmitis40 t150 JOIN

Solution icon of stackoverflow
via Stack Overflow by user3659052
, 1 year ago
Syntax error in SQL statement "SELECT DISTINCT MAX_SPEED AS LIMIT[*] FROM CAR_SPEED WHERE CAR_SPEED AND SPEED_GROUP = 'CS' "; expected "identifier"; SQL statement: SELECT DISTINCT MAX_SPEED AS LIMIT[*] FROM CAR_SPEED WHERE CAR_SPEED AND SPEED_GROUP = 'CS' [42001-160]

Stack trace

  • org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: select sum(takeinbigblinds) as takeinbigblinds from PlayerSummary f where f.isHero=true and f.isplaymoney=? and f.istournament=? and f.dayid>=? and f.dayid<? and f.tableSize=? and f.gametypeid=? and buyin=? [50000-124] at org.h2.message.Message.getSQLException(Message.java:111) at org.h2.message.Message.convert(Message.java:288) at org.h2.message.Message.convert(Message.java:249) at org.h2.command.Command.executeQueryLocal(Command.java:144) at org.h2.command.Command.executeQuery(Command.java:123) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:98) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591) Caused by: java.lang.ArrayIndexOutOfBoundsException: 0 at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:310) at org.h2.index.PageDataLeaf.getRow(PageDataLeaf.java:427) at org.h2.index.PageDataNode.getRow(PageDataNode.java:284) at org.h2.index.PageDataNode.getRow(PageDataNode.java:284) at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:377) at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:366) at org.h2.table.TableData.getRow(TableData.java:116) at org.h2.index.PageBtreeIndex.getRow(PageBtreeIndex.java:284) at org.h2.index.PageBtreeCursor.get(PageBtreeCursor.java:46) at org.h2.index.IndexCursor.get(IndexCursor.java:146) at org.h2.table.TableFilter.getValue(TableFilter.java:650) at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:168) at org.h2.expression.Comparison.getValue(Comparison.java:215) at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:86) at org.h2.expression.Expression.getBooleanValue(Expression.java:188) at org.h2.command.dml.Select.queryGroup(Select.java:309) at org.h2.command.dml.Select.queryWithoutCache(Select.java:551) at org.h2.command.dml.Query.query(Query.java:236) at org.h2.command.CommandContainer.query(CommandContainer.java:82) at org.h2.command.Command.executeQueryLocal(Command.java:142) ... 8 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago