I’ve got a H2 database with URL "jdbc:h2:test"
. I create a table using CREATE TABLE PERSON (ID INT PRIMARY KEY, FIRSTNAME VARCHAR(64), LASTNAME VARCHAR(64));
. I then select everything from this (empty) table using SELECT * FROM PERSON
. So far, so good.
However, if I change the URL to "jdbc:h2:mem:test"
, the only difference being the database is now in memory only, this gives me an org.h2.jdbc.JdbcSQLException: Table "PERSON" not found; SQL statement: SELECT * FROM PERSON [42102-154]
. I’m probably missing something simple here, but any help would be appreciated.