This example application demonstrates how to setup and run a jOOQ project.
This example uses MySQL as the database:
mysql> CREATE DATABASE pubs;
$ mysql -u username [options] pubs < [path]/pubs.sql
The SQL file, pubs.sql, is included in this project.
The application can be built with Maven by executing the following command:
mvn clean compile
jOOQ will generate the necessary Java code from the database which will be located in the folder, src/main/java/org/redlich/pubs/model/tables, followed by compiling all the relevant source code.
To execute the application:
mvn exec:java -Dexec.mainClass=org.redlich.pubs.Application -Dexec.cleanupDaemonThreads=false
Please don't hesitate to contact me at mike@redlich.net with any questions.