How do I add JDBI into a Spring Boot application?

Question

I am trying to set up a Spring Boot application without Hibernate and use JDBI instead. Now I use maven as my package management but I am unsure how to get this done. Here you can see part of pom.xml. I found some info with gradle but could someone show me how JBDI can be integrated with maven package management? At the same time is there an example how to add connect it to a SQLite db.

  <dependencies>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
      <exclusions>
        <exclusion>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-tomcat</artifactId>
        </exclusion>
      </exclusions>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jetty</artifactId>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>com.jayway.jsonpath</groupId>
      <artifactId>json-path</artifactId>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.jdbi</groupId>
      <artifactId>jdbi</artifactId>
      <version>2.78</version>
    </dependency>
   </dependencies>

What isn't working? You added the dependencies so the classes are available. — M. Deinum, Nov 29 '17 at 18:11

score 1 · Answer 1 · answered Dec 21 '17 at 22:35

You can see a runnable code example and explanation here https://www.surasint.com/spring-boot-database-transaction-jdbi/

Basically, you need this dependency for spring database, jdbi, and Mysql connector in pom.xml

    <!-- for db annotation, ex @Transactional -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <!-- mysql connector -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.10</version>
    </dependency>
    <!-- jdbi: db table mapper -->
    <dependency>
        <groupId>org.jdbi</groupId>
        <artifactId>jdbi</artifactId>
        <version>2.62</version>
    </dependency>
</dependencies>

Then you need a datasource from Spring. You can do like this:

@Qualifier("dataSource")
@Autowired
private DataSource dataSource;

Then you need a connection from that datasource.

Connection conn =  DataSourceUtils.getConnection(dataSource);

Then hook the conneciton with JDBI.

Handle handle = DBI.open(conn);

How do I add JDBI into a Spring Boot application?

1 Answers1