Re: [h2] DELETE throws a java.lang.IndexOutOfBoundsException

2014-11-21 Thread Steve
Thank you for your fast response! As requested - the complete stack trace. ... I replaced my class & package names with more meaningful ones. org.h2.jdbc.JdbcSQLException: General error: "java.lang.IndexOutOfBoundsException: Index: 1, Size: 0"; SQL statement: DELETE FROM FEATURE_1 WHERE _ID_$$_

Re: [h2] DELETE throws a java.lang.IndexOutOfBoundsException

2014-11-21 Thread Thomas Mueller
Hi, Could you send the complete stack trace please (including all "caused by"). Regards, Thomas On Fri, Nov 21, 2014 at 1:51 PM, Noel Grandin wrote: > It's working for me, something like: > > Statement stat = conn.createStatement(); > stat.execute("CREATE TABLE t1 (c1 INT)"); >

Re: [h2] DELETE throws a java.lang.IndexOutOfBoundsException

2014-11-21 Thread Noel Grandin
It's working for me, something like: Statement stat = conn.createStatement(); stat.execute("CREATE TABLE t1 (c1 INT)"); stat.execute("INSERT INTO t1 SELECT X FROM SYSTEM_RANGE(1, 10);"); prep = conn.prepareStatement("DELETE FROM t1 WHERE c1 IN (SELECT x from TABLE