org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement: SELECT * FROM "SYS_2003652629_mc" ORDER BY "p_T1_ORG_NAME_edi" DESC [50000-164]

nabble.com | 6 days ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    JdbcSQLException using GROUP BY on h2 Database

    Stack Overflow | 3 years ago | ETN
    org.h2.jdbc.JdbcSQLException: Column "ACTOR.ID" must be in the GROUP BY list; SQL statement: SELECT ACTOR.ID, ACTOR.PERSONID FROM ACTOR GROUP BY PERSONID [90016-161]
  2. 0

    New issue with numeric scale in decimal data type

    Google Groups | 6 years ago | dariof
    org.h2.jdbc.JdbcSQLException: Invalid value "32767" for parameter "scale (precision = 1)"; SQL statement: CREATE MEMORY TABLE PUBLIC.T1_COPY_2_0( SALARY DECIMAL(1, 32767), F1 INT ) AS SELECT SALARY, NULL FROM PUBLIC.T1 [90008-155]
  3. 0

    Corrupted Database - unable to recover

    Google Groups | 5 years ago | beetle
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: SELECT * FROM JESIG [50000-155] at org.h2.message.DbException.getJdbcSQLException(DbException.java:327<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=327&build=155>) at org.h2.message.DbException.get(DbException.java:156<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=156&build=155>) at org.h2.command.Command.executeQuery(Command.java:185<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=185&build=155>) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:173<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=173&build=155>) at org.h2.server.web.WebApp.getResult(WebApp.java:1304<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1304&build=155>) at org.h2.server.web.WebApp.query(WebApp.java:994<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=994&build=155>) at org.h2.server.web.WebApp$1.next(WebApp.java:960<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=960&build=155>) at org.h2.server.web.WebThread.process(WebThread.java:166<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=166&build=155>)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    3 unregistered visitors
    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. java.lang.ArrayIndexOutOfBoundsException

      0

      at org.h2.index.PageDataLeaf.getRowAt()
    2. H2 Database Engine
      WebThread.run
      1. org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:327)
      2. org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97)
      3. org.h2.index.PageDataCursor.next(PageDataCursor.java:49)
      4. org.h2.index.IndexCursor.next(IndexCursor.java:238)
      5. org.h2.table.TableFilter.next(TableFilter.java:353)
      6. org.h2.command.dml.Select.queryFlat(Select.java:513)
      7. org.h2.command.dml.Select.queryWithoutCache(Select.java:618)
      8. org.h2.command.dml.Query.query(Query.java:297)
      9. org.h2.command.dml.Query.query(Query.java:267)
      10. org.h2.command.dml.Query.query(Query.java:36)
      11. org.h2.command.CommandContainer.query(CommandContainer.java:82)
      12. org.h2.command.Command.executeQuery(Command.java:187)
      13. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:173)
      14. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
      15. org.h2.server.web.WebApp.getResult(WebApp.java:1311)
      16. org.h2.server.web.WebApp.query(WebApp.java:1001)
      17. org.h2.server.web.WebApp$1.next(WebApp.java:964)
      18. org.h2.server.web.WebApp$1.next(WebApp.java:967)
      19. org.h2.server.web.WebThread.process(WebThread.java:166)
      20. org.h2.server.web.WebThread.run(WebThread.java:93)
      20 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame