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]

Google Groups | Steve McLeod | 7 years ago
  1. 0

    java.lang.ArrayIndexOutOfBoundsException: 0 in 1.2.124

    Google Groups | 7 years ago | Steve McLeod
    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]
  2. 0

    Row not found exception [90112-115]

    Google Groups | 7 years ago | Steve McLeod
    org.h2.jdbc.JdbcSQLException: 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=?, showdowntakeInCents=?, nonshowdowntakeInCents=?, takeinbigblinds=?, timesseen=?, flopseen=?, vpip=?, preflopraised=?, postflopbet=?, postflopraised=?, postflopcalled=?, postflopfolded=?, postflopcallfoldbetorraise=?, postflopbetorraised=?, blindstealattempt=?, blindstealattemptopportunity=?, checkraised=?, wenttoshowdown=?, wonatshowdown=?, wonwithoutshowdown=?, threebetpreflop=?, threebetpreflopopportunity=?, blindStealDefenseOpportunityOnBigBlind=?, calledPreflopRaise=?, calledPreflopRaiseOpportunity=?, continuationBetPreflop=?, continuationBetPreflopOpportunity=?, foldedToBlindStealOnBigBlind=?, foldedToContinuationBet=?, foldedToContinuationBetOpportunity=?, foldedToPreflopThreeBet=?, foldedToPreflopThreeBetOpportunity=? where playerid=? and dayid=? and tablesize=? and gametypeid=? and ishero=? and istournament=? and isplaymoney=? [90112-115]
  3. 0

    H2: "data conversion error" in WHERE clause

    Stack Overflow | 4 years ago | Victor Nedioglo
    org.h2.jdbc.JdbcSQLException: Data conversion error converting "USA"; SQL statement: select * from table_country c where c.code&gt;0 AND 'USA' = c.name(+) [22018-170]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    H2 select query fails in memory mode but not in embedded mode

    Stack Overflow | 3 years ago | user1274500
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: Unexpected code path"; SQL statement: SELECT * FROM Flights A INNER JOIN (SELECT AircraftId, MIN(DepartureDate) AS DepDate FROM Flights GROUP BY AircraftId) B ON A.AircraftId = B.AircraftId AND A.DepartureDate = B.DepDate ORDER BY A.AircraftId ASC [50000-173]
  6. 0

    How to delete entities with GORM(Grails) and HQL(Hibernate) using executeUpdate()

    Stack Overflow | 2 years ago | Dennis
    org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "DELETE FROM LABEL_TEST_ENTITY CROSS[*] JOIN LABEL LABEL1_ WHERE TEST_ENTITY_NAME=? AND TEST_ENTITY_SPEC_PATH=? AND TEST_ENTITY_SPEC_FILE_NAME=? AND LABEL_TYPE=? "; SQL statement: delete from label_test_entity cross join label label1_ where test_entity_name=? and test_entity_spec_path=? and test_entity_spec_file_name=? and label_type=? [42000-176]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. H2 Database Engine
      Command.executeQuery
      1. org.h2.message.Message.getSQLException(Message.java:111)
      2. org.h2.message.Message.convert(Message.java:288)
      3. org.h2.message.Message.convert(Message.java:249)
      4. org.h2.command.Command.executeQueryLocal(Command.java:144)
      5. org.h2.command.Command.executeQuery(Command.java:123)
      5 frames