You can take a look at the cayenne unit tests. These work (or at least used to work) using an in-memory hsqldb.
Off the top of my head, I think it's only a matter of specifying "jdbc:hsqldb:mem:." as your jdbc.url in the .cayenne/connection.properties file in your home directory. On 11/2/06, Christian Mittendorf <[EMAIL PROTECTED]> wrote:
Hi! Can anybody give me hint on how to setup db tables using my cayenne.xml from my class for running an in memory hsqldb? I'd like to create some junit tests that use an in memory table instead of the real db connection. Christian
