I noticed that running a select statment only works when it is limited to a number, There are some corropted records,
SELECT count(*) FROM BIKER_ETL.ORDERS2 where "#id"<'70212' //this works SELECT count(*) FROM BIKER_ETL.ORDERS2 where "#id"<'70213' //this gives an error On Wednesday, October 17, 2012 10:46:29 AM UTC+2, kais haddadin wrote: > > Hello! > > I am trying to run a simple delete on a table. This error comes up: > > Allgemeiner Fehler: "java.lang.ArrayIndexOutOfBoundsException" > General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement: > delete from "BIKER_ETL"."ORDERS2" > [50000-169]<http://192.168.2.89:8082/query.do?jsessionid=f1beeeb39e09125c1e98283c70fef629#>HY000/50000 > > (Hilfe)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c50000> > org.h2.jdbc.JdbcSQLException: Allgemeiner Fehler: > "java.lang.ArrayIndexOutOfBoundsException" > General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement: > delete from "BIKER_ETL"."ORDERS2" [50000-169] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:329<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=329&build=169>) > > > at > org.h2.message.DbException.get(DbException.java:158<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=158&build=169>) > > > at > org.h2.message.DbException.convert(DbException.java:281<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=281&build=169>) > > > at > org.h2.command.Command.executeUpdate(Command.java:234<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=234&build=169>) > > > at > org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=177&build=169>) > > > at > org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=152&build=169>) > > > at > org.h2.server.web.WebApp.getResult(WebApp.java:1311<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1311&build=169>) > > > at > org.h2.server.web.WebApp.query(WebApp.java:1001<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1001&build=169>) > > > at > org.h2.server.web.WebApp$1.next(WebApp.java:964<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=964&build=169>) > > > at > org.h2.server.web.WebApp$1.next(WebApp.java:953<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=953&build=169>) > > > 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=169>) > > > at > org.h2.server.web.WebThread.run(WebThread.java:93<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=169>) > > > at java.lang.Thread.run(Unknown Source) > Caused by: java.lang.ArrayIndexOutOfBoundsException > > I can not make any query after that. Then I disconnect,connect again, run > the simple select query, and it works. Delete does not work though. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/lpoP8VGlrl4J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
