confusion about password and data not showing up

29 görüntüleme
İlk okunmamış mesaja atla

Narahari 'n' Savitha

okunmadı,
25 Haz 2016 01:01:2125.06.2016
alıcı H2 Database
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
Tümünü yanıtla
Yazarı yanıtla
Yönlendir
0 yeni ileti