What I have found to be useful when deploying against MySQL but testing against H2 is the following:
1. Liquibase for defining schema 2. SpringLiquibase bean for unit testing 3. UPPERCASE for all table names and columns 4. "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;IGNORECASE=TRUE" as the H2 URL You many not need "IGNORECASE=TRUE" if you do not define case-insensitive columns. On Sunday, April 20, 2014 12:47:14 AM UTC-7, Brishkit wrote: > > We are using JOOQ against MySQL DB for production code. For > unit/integration testing, we wanted to try out a in memory HSQLDB option. > The problem we are facing is the error 'Three part identifiers prohibited > in statement'. If we try Settings settings = new > Settings().withRenderSchema(false); while setting up the HSQLDB DSLContext, > it complains with a 'table not found in Statement' error. > > How do we work around this? Or should we use the same MySQL setup for > unit/integration tests? > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
