cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Kienenberger <>
Subject Re: H2 rev engineer
Date Fri, 20 Oct 2017 16:04:54 GMT
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:


On Fri, Oct 20, 2017 at 11:55 AM, Tony Giaccone <> 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 -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
> 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

View raw message