So added the debug to my connection URL and it appears that I'm getting a table not found error: org.h2.jdbc.JdbcSQLException: Table "my_table" not found; SQL statement:
I changed the table name above. Im sure the table exists. When I change my connection url to jdbc:h2:~/test it works fine. I'm using this command to start my server: java -cp h2*.jar org.h2.tools.Server. On Feb 5, 6:25 am, Thomas Mueller <[email protected]> wrote: > Hi, > > > Exception in thread "main" java.sql.BatchUpdateException > > at org.h2.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:644) > > at H2Setup.main(H2Setup.java:102) > > That means the operation failed, but the root cause is not listed. > Would it be possible for you to debug H2, and check what the exception > is at JdbcStatement.java, line 635? > > try { > result[i] = executeUpdateInternal(sql); > } catch (Exception e) { > logAndConvert(e); // << ======= what kind of > error is this? > //## Java 1.4 begin ## > result[i] = Statement.EXECUTE_FAILED; > //## Java 1.4 end ## > error = true; > } > > With an in-memory database it's not so easy otherwise. Unless, I > believe if you append ;TRACE_LEVEL_SYSTEM_OUT=3 to the database URL (I > didn't test it however). > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
