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 | 3 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    CTE: WITH clause (non-recursive) Error

    GitHub | 1 year ago | GoogleCodeExporter
    org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります "recursive queries without UNION ALL"; 期待されるステートメント {1} Syntax error in SQL statement "recursive queries without UNION ALL"; expected {1}; SQL statement: with t(n) as ( select 1 ) select * from t [42001-140]
  2. 0

    JdbcSQLException using GROUP BY on h2 Database

    Stack Overflow | 4 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]
  3. 0

    CTE: Table name Scope Error?

    GitHub | 1 year ago | GoogleCodeExporter
    org.h2.jdbc.JdbcSQLException: 列 "X" が見つかりません Column "X" not found; SQL statement: with recursive t(x) as ( select 0 union all select x + 1 from t where x < 9 ) select * from t [42122-140]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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 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