I see a couple of possible reasons: First I would guess that "jdbc:h2:mem" is creating a separate in-memory database rather than using your tcp-served db.
Second, you might need to specify your non-standard schemas like as follows. Below is a url I use modified for what values you provided: jdbc:h2:tcp://localhost/<path-to-test>;AUTO_SERVER=TRUE;MVCC=TRUE;SCHEMA_SEARCH_PATH=CORE_OPERATION On Fri, Oct 20, 2017 at 11:55 AM, 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
