Basic Data Source Provider

The com.google.code.ibaguice.datasource.dbcp.BasicDataSourceProvider is the provider that builds the org.apache.commons.dbcp.BasicDataSource and helps users to configure it.

Follows below the resume table of supported properties; for more details please consult the Official reference.

Shared Pool Data Source

The com.google.code.ibaguice.datasource.dbcp.SharedPoolDataSourceProvider is the provider that builds the org.apache.commons.dbcp.datasources.SharedPoolDataSource and helps users to configure it.

NOTE This class requires a javax.sql.ConnectionPoolDataSource existing binding in order to be instantiated.

Follows below the resume table of supported properties:

Per User Pool DataSource

The com.google.code.ibaguice.datasource.dbcp.PerUserPoolDataSourceProvider is the provider that builds the org.apache.commons.dbcp.datasources.PerUserPoolDataSource and helps users to configure it.

NOTE This class requires a javax.sql.ConnectionPoolDataSource existing binding in order to be instantiated.

Follows below the resume table of supported properties:

Configuring 'PerUser' properties since these settings can't be easily covered using com.google.inject.name.Named annotations, and we don't want to put a limit on how users can retrieve these informations, the library provides the com.google.code.ibaguice.datasource.dbcp.PerUserPoolDataSourceModule module that alleviates the task of binding 'per users' properties.

So, developers have to write their own com.google.inject.Provider for mapped properties and binding them through the module; keep in mind that every provider is optional so, if not specified, properties won't be set.

Let's take a look at an example that shows how to set the perUserDefaultAutoCommit properties; first of all, let's implement the provider that communicates he user bindings:

import com.google.inject.Provider;
import com.google.inject.name.Named;

class MyPerUserDefaultAutoCommit implements Provider<Map<String, Boolean>> {

    private final Map<String, Boolean> perUserDefaultAutoCommitMap;

    public MyPerUserDefaultAutoCommit(@Named("perUserDefaultAutoCommit.url") URL url) {
        // reads the URL and populate a map
    }

    public Map<String, Boolean> get() {
        return this.perUserDefaultAutoCommitMap;
    }

}

then, create the com.google.code.ibaguice.datasource.dbcp.PerUserPoolDataSourceModule and binding it:

PerUserPoolDataSourceModule perUserPoolDataSourceModule = new PerUserPoolDataSourceModule();
perUserPoolDataSourceModule.setPerUserDefaultAutoCommitProviderClass(MyPerUserDefaultAutoCommit.class);

So, finally you're ready to create the context:

import com.google.code.ibaguice.core.SqlSessionFactoryModule;
import com.google.code.ibaguice.datasource.dbcp.PerUserPoolDataSourceModule;
import com.google.code.ibaguice.datasource.dbcp.PerUserPoolDataSourceProvider;

Injector injector = Guice.createInjector(
    new SqlSessionFactoryModule(PerUserPoolDataSourceProvider.class),
    perUserPoolDataSourceModule
);

that's all :)

Note it's strongly reccommended to use the same com.google.code.ibaguice.datasource.dbcp.PerUserPoolDataSourceModule to set also the other 'per user' bindings, resumed in the following table:

Connection Pool Data Source driver adapter

The com.google.code.ibaguice.datasource.dbcp.DriverAdapterCPDSProvider provides the org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS adapter for jdbc drivers that do not include an implementation of javax.sql.ConnectionPoolDataSource.

Follows below the resume table of supported properties: