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 web162

Solution icon of googlegroups
via Google Groups by Steve McLeod, 9 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 web
via nabble.com by Unknown author, 9 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.NullPointerException; SQL statement: DELETE FROM FILES WHERE PATH=? AND CONTAINER_ID=?; [50000-122]

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.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 web
Timeout trying to lock table TOPLEVELVERSIONMANAGEMENT_TREECHILD; SQL statement: SELECT cdo_id, top FROM TopLevelVersionManagement_TreeChild WHERE cdo_version>0 AND cdo_revised=0 AND top IN

Solution icon of github
Allgemeiner Fehler: "java.lang.NullPointerException" General error: "java.lang.NullPointerException"; SQL statement: SELECT prp1.subject AS left, prp2.subject AS right, MIN(prp1.id) AS sourceId1, 'objectPropertyAssertion' AS sourceTable1, MIN(prp1

Solution icon of googlegroups
via Google Groups by Jezzper, 1 year ago
Column CONSTRAINT_NAME not found; SQL statement: SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION KEY_SEQ, IFNULL(CONSTRAINT_NAME, INDEX_NAME) PK_NAME FROM INFORMATION_SCHEMA.INDEXES WHERE TABLE_CATALOG LIKE ? AND TABLE_SCHEMA LIKE ? AND TABLE_NAME = ? AND PRIMARY_KEY = TRUE ORDER BY COLUMN_NAME [42122-79]

Solution icon of googlegroups
via Google Groups by Eric J. Christeson, 4 months ago
Table "COURSE" not found; SQL statement: Select coalesce(Course2.meaninglessLongOption,?) as v1 From Course Course2 Where ((coalesce(Course2.meaninglessLongOption,?) <> ?) and (coalesce(Course2.meaninglessLongOption,?) = ?)) [42102-127]

Solution icon of web
テーブル SML_JMEIS のロック試行がタイムアウトしました Timeout trying to lock table SML_JMEIS; SQL statement: select count(SML_JMEIS.SMJ_SID) as cnt from SML_JMEIS, SML_SMEIS, CMN_USRM, CMN_USRM_INF where SML_JMEIS.USR_SID = ? and SML_JMEIS.SMJ_JKBN

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