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