Friends: This may be a simple thing for folks but I can't figure this out.
I run the following to get the server started java -cp "/Users/nlakshmi/Downloads/h2/bin/h2-1.4.192.jar:$H2DRIVERS:$CLASSPATH" org.h2.tools.rver -web -tcp -baseDir cool I follow that up with the following sql java -cp bin/h2*.jar org.h2.tools.RunScript -url "jdbc:h2:tcp://localhost/mem:test;DB_CLOSE_ON_EXIT=FALSE;INIT=RUNSCRIPT FROM '/Users/nlakshmi/Downloads/h2/putdata.sql'" -script tst.sql -showResults -user cool -password cool .... .... .... .... After this I run the following [nlakshmi@ROSELCDV0080787 h2]$ java -cp bin/h2*.jar org.h2.tools.RunScript -url "jdbc:h2:tcp://localhost/mem:test;DB_CLOSE_ON_EXIT=FALSE" -script tst.sql -showResults -user cool -password cool select * from test ;Exception in thread "main" org.h2.jdbc.JdbcSQLException: Table "TEST" not found; SQL statement: select * from test [42102-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2. The table TEST exists but I get this error. Please help out. -Narahari -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
