1. Introduction

The Jdbi plugin enables lightweight access to datasources using JDBI.. This plugin does NOT provide domain classes nor dynamic finders like GORM does.

Griffon version: 2.2.0

2. Usage

The following sections describe how you may use this plugin in an project.

2.1. Configuration

This plugin relies on the griffon-datasource-plugin. Please follow the instructions to configure this plugin first.

The plugin’s module registers a JdbiHandler helper class that defines the base contract for accessing a datasource and issue SQL queries to it. This class has the following methods

griffon.plugins.jdbi.JdbiHandler.java
@Nullable
<R> R withJdbi(@Nonnull JdbiCallback<R> callback)
    throws RuntimeJdbiException;

@Nullable
<R> R withJdbi(@Nonnull String datasourceName, @Nonnull JdbiCallback<R> callback)
    throws RuntimeJdbiException;

void closeJdbi();

void closeJdbi(@Nonnull String datasourceName);

These method are aware of multiple datasources. If no datasourceName is specified when calling them then the default datasource will be selected. You can inject an instance of this class anywhere it’s needed using @Inject. There is one callback you may use with this method: JdbiCallback.

This callback is defined using a functional interface approach, which means you can apply lambda expressions if running with JDK8+ or closures if running Groovy.

griffon.plugins.jdbi.JdbiCallback.java
public interface JdbiCallback<R> {
    R handle(@Nonnull String datasourceName, @Nonnull DBI dbi);
}

2.1.1. Bootstrap

You may execute arbitrary database calls during connection and disconnection from a datasource. Simply create a class that implements the JdbiBootstrap interface and register it within a module, for example

src/main/groovy/com/acme/SampleJdbiBootstrap.groovy
package com.acme

import griffon.plugins.jdbi.JdbiBootstrap
import org.skife.jdbi.v2.DBI

import javax.annotation.Nonnull
import javax.inject.Named

@Named("sample")
class SampleJdbiBootstrap implements JdbiBootstrap {
    @Override
    void init(@Nonnull String datasourceName, @Nonnull DBI dbi) {
        // operations after first connection to datasource
    }

    @Override
    void destroy(@Nonnull String datasourceName, @Nonnull DBI dbi) {
        // operations before disconnecting from the datasource
    }
}
src/main/java/com/acme/ApplicationModule.java
package com.acme;

import griffon.plugins.jdbi.JdbiBootstrap;
import griffon.core.injection.Module;
import org.codehaus.griffon.runtime.core.injection.AbstractModule;
import org.kordamp.jipsy.ServiceProviderFor;

@ServiceProviderFor(Module.class)
public class ApplicationModule extends AbstractModule {
    @Override
    protected void doConfigure() {
        bind(JdbiBootstrap.class)
            .to(SampleJdbiBootstrap.class)
            .asSingleton();
    }
}

2.2. Example

The following is a trivial usage of the JdbiHandler inside a Java service

com.acme.SampleService.java
package com.acme;

import griffon.core.artifact.GriffonService;
import griffon.metadata.ArtifactProviderFor;
import org.codehaus.griffon.runtime.core.artifact.AbstractGriffonService;

import griffon.plugins.jdbi.JdbiHandler;
import griffon.plugins.jdbi.JdbiCallback;
import org.skife.jdbi.v2.DBI;

import javax.inject.Inject;

@ArtifactProviderFor(GriffonService.class)
public class SampleService {
    @Inject
    private JdbiHandler jdbiHandler

    public String getPersonName(final int id) {
         return jdbiHandler.withJdbi(new JdbiCallback<String>() {
             public String handle(@Nonnull String datasourceName, @Nonnull DBI dbi) {
                 PersonDAO dao = dbi.open(PersonDAO.class);
                 Person person = dao.findById(id);
                 return person != null ? person.getName() : null;
             }
         });
    }
}

Here’s the Groovy version of it

com.acme.SampleService.groovy
package com.acme

import griffon.core.artifact.GriffonService
import griffon.metadata.ArtifactProviderFor

import griffon.plugins.jdbi.JdbiHandler
import org.skife.jdbi.v2.DBI

import javax.inject.Inject

@ArtifactProviderFor(GriffonService)
class SampleService {
    @Inject
    private JdbiHandler jdbiHandler

    String getPersonName(final int id) {
         jdbiHandler.withJdbi { String datasourceName, DBI dbi ->
             dbi.open(PersonDAO)?.findById(id)?.name
         }
    }
}

2.3. Events

The following events will be triggered by JdbiHandler

JdbiConnectStart(String datasourceName, Map<String, Object> config)

Triggered before connecting to the datasource.

JdbiConnectEnd(String datasourceName, Map<String, Object> config, DBI dbi)

Triggered after connecting to the datasource.

JdbiDisconnectStart(String datasourceName, Map<String, Object> config, DBI dbi)

Triggered before disconnecting from the datasource.

JdbiDisconnectEnd(String datasourceName, Map<String, Object> config)

Triggered after disconnecting from the datasource.

DataSource events may be triggered during connection and disconnection from a datasource.

2.4. AST Transformation

You can apply the @JdbiAware AST transformation on any class. This injects the behavior of JdbiHandler into said class. The previous Groovy service example can be rewritten as follows

com.acme.SampleService.groovy
package com.acme

import griffon.core.artifact.GriffonService
import griffon.metadata.ArtifactProviderFor
import griffon.transform.JdbiAware

import org.skife.jdbi.v2.DBI

@JdbiAware
@ArtifactProviderFor(GriffonService)
class SampleService {
    String getPersonName(final int id) {
         withJdbi { String datasourceName, DBI dbi ->
             dbi.open(PersonDAO)?.findById(id)?.name
         }
    }
}

2.5. DSL Descriptors

This plugin provides DSL descriptors for Intellij IDEA and Eclipse (provided you have the Groovy Eclipse plugin installed). These descriptors are found inside the griffon-jdbi-groovy-compile-1.1.0.jar, with locations

  • dsdl/griffon_jdbi.dsld

  • gdsl/griffon_jdbi.gdsl

3. Build Configuration

3.1. Gradle

You have two options for configuring this plugin: automatic and manual.

3.1.1. Automatic

As long as the project has the org.codehaus.griffon.griffon plugin applied to it you may include the following snippet in build.gradle

dependencies {
    griffon 'org.codehaus.griffon.plugins:griffon-jdbi-plugin:1.1.0'
}

The griffon plugin will take care of the rest given its configuration.

3.1.2. Manual

You will need to configure any of the following blocks depending on your setup

dependencies {
    compile 'org.codehaus.griffon.plugins:griffon-jdbi-core:1.1.0'
}
Compile Only
dependencies {
    compileOnly 'org.codehaus.griffon.plugins:griffon-jdbi-groovy-compile:1.1.0'
}

3.2. Maven

First configure the griffon-jdbi-plugin BOM in your POM file, by placing the following snippet before the <build> element

<dependencyManagement>
    <dependencies>
        <dependency>
            <groupId>org.codehaus.griffon.plugins</groupId>
            <artifactId>griffon-jdbi-plugin</artifactId>
            <version>1.1.0</version>
            <type>pom</type>
            <scope>import</scope>
        </dependency>
    </dependencies>
</dependencyManagement>

Next configure dependencies as required by your particular setup

<dependency>
    <groupId>org.codehaus.griffon.plugins</groupId>
    <artifactId>griffon-jdbi-core</artifactId>
</dependency>
Provided scope
<dependency>
    <groupId>org.codehaus.griffon.plugins</groupId>
    <artifactId>griffon-jdbi-groovy-compile</artifactId>
</dependency>

Don’t forget to configure all -compile dependencies with the maven-surefire-plugin, like so

<plugin>
    <groupId>org.apache.maven.plugins</groupId>
    <artifactId>maven-surefire-plugin</artifactId>
    <configuration>
        <classpathDependencyExcludes>
            <classpathDependencyExclude>
                org.codehaus.griffon:griffon-jdbi-groovy-compile
            </classpathDependencyExclude>
        </classpathDependencyExcludes>
    </configuration>
</plugin>

4. Modules

The following sections display all bindings per module. Use this information to successfully override a binding on your own modules or to troubleshoot a module binding if the wrong type has been applied by the Griffon runtime.

4.1. Jdbi

Module name: jdbi

Depends on: datasource

bind(JdbiStorage.class)
    .to(DefaultJdbiStorage.class)
    .asSingleton();

bind(JdbiFactory.class)
    .to(DefaultJdbiFactory.class)
    .asSingleton();

bind(JdbiHandler.class)
    .to(DefaultJdbiHandler.class)
    .asSingleton();

bind(GriffonAddon.class)
    .to(JdbiAddon.class)
    .asSingleton();