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.
