> jdbc:h2:mem:test;MVCC=TRUE This is an in-memory DB URL. So it exists in Squirrel SQL Client process and not on disk. Try an experiment - close and reopen Squirrel SQL Client and see if the DB is still there.
You will need to use a URL that points to a file. E.g. jdbc:h2:/data/sample FWIW I prefer Derby for my embedded DB. Feels more reliable than H2 or HSQL. Also has an in-memory and on-disk modes. Andrus > On Oct 20, 2017, at 6:55 PM, Tony Giaccone <[email protected]> wrote: > > I created an H2 database, using our standard SQL. Now I'd like to > rev-engineer that db with cayenne, but the schema doesn't show up in the > modeler. > > To reproduce this problem, I follow these steps: > > $ java -cp bin/h2*.jar org.h2.tools.Server -tcp -tcpAllowOthers > > this creates a H2 database. > > I connect with Squirrel SQL Client > driver: org.h2.Driver > URL: jdbc:h2:mem:test;MVCC=TRUE > > This connects to the H2 Db, where I execute > > CREATE SCHEMA IF NOT EXISTS CORE AUTHORIZATION SA; > > This creates the new schema which, when I refresh the tree in squirrel, is > displayed. > > I then try to rev-engineer with the cayenne modeler 4.1.M1 > > Only two schema's show up in the modeler drop down, INFORMATION_SCHEMA and > PUBLIC the newly created schema CORE is not in the list. > > > Any Suggestions? > > > Tony Giaccone
