Hi, > I have an embedded H2 database > jdbc:h2:mem:play
The JDBC URL you used is for an in-memory database. See http://h2database.com/html/features.html#database_url Regards, Thomas On Sun, Aug 5, 2012 at 12:04 AM, Amir <[email protected]> wrote: > I have an embedded H2 database (inside Java Play framework). I want to > query this database while it's running in it's own JVM from command line > > I ran an H2 client on command line (h2.jar): $ java -cp h2.jar > org.h2.tools.Shell > > Then used the same jdbc connection string i.e.: jdbc:h2:mem:play > > Then used user/pass: sa/sa > > It connects and logs in but there is no sign of tables which I know exists > (since the java app could automatically generate data, read and write it > and show on the webpage)! > > sql> show tables; > TABLE_NAME | TABLE_SCHEMA > (0 rows, 0 ms) > > sql> show schemas; > SCHEMA_NAME > PUBLIC > INFORMATION_SCHEMA > (2 rows, 0 ms) > > I seem to be missing something simple. > > Thoughts? > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/5Iz-VZAFdHsJ. > 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. > -- 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.
