Index: src/main/kotlin/org/springframework/samples/petclinic/PetClinicApplication.kt
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- src/main/kotlin/org/springframework/samples/petclinic/PetClinicApplication.kt	(revision c66b152b83be2cdf8c28ca4e3e8869158b47a40b)
+++ src/main/kotlin/org/springframework/samples/petclinic/PetClinicApplication.kt	(date 1507515780000)
@@ -17,6 +17,7 @@

 import org.springframework.boot.SpringApplication
 import org.springframework.boot.autoconfigure.SpringBootApplication
+import org.springframework.transaction.annotation.EnableTransactionManagement

 /**
  * PetClinic Spring Boot Application.
@@ -25,6 +26,7 @@
  * @author Antoine Rey
  */
 @SpringBootApplication
+@EnableTransactionManagement
 class PetClinicApplication

 fun main(args: Array<String>) {
Index: src/main/resources/application.properties
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- src/main/resources/application.properties	(revision c66b152b83be2cdf8c28ca4e3e8869158b47a40b)
+++ src/main/resources/application.properties	(date 1507518432000)
@@ -24,3 +24,17 @@

 # Active Spring profiles
 spring.profiles.active=production
+
+spring.datasource.url=jdbc:h2:~/jooq
+spring.datasource.username=sa
+spring.datasource.password=
+
+
+#Database Configuration
+db.driver=org.h2.Driver
+db.url=jdbc:h2:~/jooq
+db.username=sa
+db.password=
+
+#SQL Dialect
+jooq.sql.dialect=H2
Index: pom.xml
IDEA additional info:
Subsystem: com.intellij.openapi.diff.impl.patch.CharsetEP
<+>UTF-8
===================================================================
--- pom.xml	(revision c66b152b83be2cdf8c28ca4e3e8869158b47a40b)
+++ pom.xml	(date 1515647105000)
@@ -19,6 +19,12 @@

     <!-- Generic properties -->
     <java.version>1.8</java.version>
+    <org.jooq.version>3.9.5</org.jooq.version>
+    <db.url>jdbc:h2:~/jooq</db.url>
+    <db.username>sa</db.username>
+    <db.password></db.password>
+    <db.driver>org.h2.Driver</db.driver>
+
     <kotlin.version>1.1.4-2</kotlin.version>
     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
     <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
@@ -31,7 +37,7 @@
     <thymeleaf.version>3.0.6.RELEASE</thymeleaf.version>

     <cobertura.version>2.7</cobertura.version>
-
+    <com.h2database.version>1.4.191</com.h2database.version>
   </properties>

   <dependencies>
@@ -40,6 +46,11 @@
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-actuator</artifactId>
     </dependency>
+      <dependency>
+          <groupId>com.h2database</groupId>
+          <artifactId>h2</artifactId>
+          <version>${com.h2database.version}</version>
+      </dependency>
     <dependency>
       <groupId>org.springframework.boot</groupId>
       <artifactId>spring-boot-starter-cache</artifactId>
@@ -134,6 +145,17 @@
       <artifactId>jackson-module-kotlin</artifactId>
       <version>2.8.7</version>
     </dependency>
+
+      <dependency>
+          <groupId>org.springframework.boot</groupId>
+          <artifactId>spring-boot-starter-jooq</artifactId>
+          <version>1.3.5.RELEASE</version>
+      </dependency>
+      <dependency>
+          <groupId>org.jetbrains.kotlinx</groupId>
+          <artifactId>kotlinx-coroutines-core</artifactId>
+          <version>0.21</version>
+      </dependency>
   </dependencies>

   <build>
@@ -162,6 +184,16 @@
           </execution>
         </executions>
       </plugin>
+        <plugin>
+            <groupId>org.jetbrains.kotlin</groupId>
+            <artifactId>kotlin-maven-plugin</artifactId>
+            <configuration>
+                <args>
+                    <arg>-Xcoroutines=enable</arg>
+                </args>
+            </configuration>
+        </plugin>
+
       <plugin>
         <groupId>org.codehaus.mojo</groupId>
         <artifactId>cobertura-maven-plugin</artifactId>
@@ -263,6 +295,33 @@
             </dependency>
         </dependencies>
       </plugin>
+        <plugin>
+            <groupId>org.jooq</groupId>
+            <artifactId>jooq-codegen-maven</artifactId>
+            <version>${org.jooq.version}</version>
+            <executions>
+                <execution>
+                    <phase>generate-sources</phase>
+                    <goals>
+                        <goal>generate</goal>
+                    </goals>
+                    <configuration>
+                        <jdbc>
+                            <driver>${db.driver}</driver>
+                            <url>${db.url}</url>
+                            <user>${db.username}</user>
+                            <password>${db.password}</password>
+                        </jdbc>
+                        <generator>
+                            <target>
+                                <packageName>org.springframework.samples.petclinic.model</packageName>
+                                <directory>src/main/java</directory>
+                            </target>
+                        </generator>
+                    </configuration>
+                </execution>
+            </executions>
+        </plugin>
     </plugins>
   </build>
   <reporting>