Hi group,

Is there a possibility to let jOOQ generate the classes without having a 
connection to a database server? For example by supplying a definition 
file? I haven't found a hint in the documentation.
The reason why I would like to do this is that I'm using MySQL as 
"production" database and H2 for the unit tests. When generating the 
classes for the "production" environment, I can easily connect to MySQL and 
tell jOOQ to do its magic.
When I need to run the unit-tests on Jenkins, I want the classes to be 
re-generated for every build, but Jenkins has no connection to the MySQL 
server. What I came up with is that I create a H2 script based on the MySQL 
schema. In a step before the unit-tests are executed, this script is loaded 
and executed by an in-memory H2 instance which jOOQ connects to and can 
generate the classes from.
This works, but isn't very elegant. Most of the time someone forgets to 
update the H2 script when the MySQL schema changes and breaks the build.

Is there a more elegant solution? (I don't want to check-in the generated 
jOOQ classes).

Thanks,
Andreas

Reply via email to