Hi Ken, To add to what Mike said, I've used H2 in the past with pretty good results. You can either let Cayenne create your schema or use something like Flyway/Liquibase if you have that integrated into your application already.
One thing I do differently, though, is I create a temporary on-disk DB instead of in-memory DB. I've found that when a test fails, I can use the H2Console utility to examine the leftover on-disk DB to see what it looks like. On successful tests, though, I close the DB connection and delete it, ready to start over with a clean slate after that. mrg On Wed, May 2, 2018 at 3:59 PM Ken Anderson <[email protected]> wrote: > All, > > We’re thinking about setting up an in-memory database in place of SQL > Server for doing unit tests. Does anyone have any experience doing this > with Cayenne? Any recommendations or warnings? > > Thanks, > Ken > Confidentiality Notice: This e-mail and accompanying documents contain > confidential information intended for a specific individual and purpose. > This e-mailed information is private and protected by law. If you are not > the intended recipient, you are hereby notified that any disclosure, > copying, or distribution, or the taking of any action based on the contents > of this information, is strictly prohibited. >
