Hi! Our Webapp has the constraint that it must work again HSQLDB (for offline use) and Oracle (for online use). This constraint has the benefit that we can use an HSQLDB to generate the Jooq files during our build process. Our build process does the following (we use gradle). 1. Create a file based HSQLDB database. 2. Run the liquibase file on it 3. Run jooq on the HSQLDB.
Some Remarks: 1. We are currently using 3 schemas. The schemas have standard names, lets say A, B and C. In HSQLDB, they are named like that. For Oracle, we use the Schema Mapping functionality. 2. We use liquibase variables for schema names: you can "inject" the real schema names from the environment or the java properties resp. 3. We use liquibase variables for types, so that differences between Oracle and HSQLDB are abstracted away. Does this help? I shall write some blog article to give more details, I'll try to do it this week. Cheers, stan. On Thursday, August 14, 2014 10:53:04 PM UTC+2, [email protected] wrote: > > Stan, > > Can you provide some insight on how you're using Liquibase and Jooq > together? I'm about to step into this for a project, and would love to get > a head start from someone who's already tackled it. > > > > On Tuesday, July 1, 2014 12:21:28 PM UTC-4, Stanislas Nanchen wrote: >> >> Hello everyone, >> >> We are successfully using Liquibase and Jooq together. Ping me if you >> need any help. >> >> Cheers. stan. >> >> On Friday, June 27, 2014 1:53:13 PM UTC+2, Kailash wrote: >>> >>> thanks i will give that a try today >>> >>> Sent from my iPhone >>> >>> On Jun 27, 2014, at 3:51 AM, Lukas Eder <[email protected]> wrote: >>> >>> Hello, >>> >>> We have attempted some initial implementation of an integrated API with >>> Liquibase, although we found that the integration would only add little >>> value to our users. This project has effectively been cancelled. This >>> doesn't mean that you cannot use jOOQ and Liquibase in a single project. We >>> have a couple of customers doing that, in fact. >>> >>> So to answer your question: >>> >>> 2014-06-25 23:39 GMT+02:00 <[email protected]>: >>> >>>> so should i integrate liquibase separately then ? >>>> >>> >>> Yes, a "separate" integration would probably be the way to go >>> >>> Best Regards, >>> Lukas >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "jOOQ User Group" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/jooq-user/CQv7i4jDyCc/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- 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.
