Apache\u00a0Groovy<\/a>\u00a0(Groovy) is an object-oriented dynamic\u00a0programming language for the Java platform. It is dynamically compiled to the Java Virtual Machine (JVM) bytecode, and inter-operates with other Java source codes and libraries. Groovy is written in Java and was first released in 2007. Groovy SQL module<\/a> provides a higher-level abstraction on JDBC technology.<\/p>\n The Groovy SQL API<\/a> supports a wide variety of databases: HSQLDB<\/a>, Oracle<\/a>, SQL Server<\/a>, MySQL<\/a>, MongoDB<\/a>. In this example, I will create a Spring boot application which utilizes Groovy SQL to manage data in an\u00a0H2<\/a> database.<\/p>\n<\/p>\n The example code in this article was built and run using:<\/p>\n Spring is the greatest tool to manage resources. In this example, we use Spring to manage database connections and transactions.<\/p>\n The easiest way to generate a Spring-boot application is via the\u00a0Spring starter tool<\/a>. Please check my other article\u00a0here<\/a>\u00a0for more details. A maven project will be generated and downloaded to your workstation. Import it into your Eclipse work space. You should have no errors on building and running it. The generated project has a\u00a0 We will add\u00a0Groovy library as a dependency in the generated\u00a0 pom.xml<\/em><\/span><\/p>\n2. Technologies Used<\/h2>\n
\n
3. Spring-boot Application<\/h2>\n
Java<\/code>\u00a0source folder. We will add two\u00a0folders:\u00a0src\/main\/groovy<\/code>\u00a0and\u00a0src\/test\/groovy<\/code>. Then we will include them as the build resources.<\/p>\n3.1 Dependencies<\/h3>\n
pom.xml<\/code>.<\/p>\n