c3p0 connectionCustomizer implementation example

ConnectionCustomizer

..
..
..
dataSource = new ComboPooledDataSource();
dataSource.setConnectionCustomizerClassName(SchemaConnectionCustomizer.class.getSimpleName());
..
..
..
public class SchemaConnectionCustomizer extends AbstractConnectionCustomizer {

    private static final Logger LOG = LoggerFactory.getLogger(SchemaConnectionCustomizer.class);
    private static final String SCHEMA_LOCATION = "ALTER SESSION SET CURRENT_SCHEMA = <<schema>>";

    @Override
    public void onAcquire(final Connection c, final String parentDataSourceIdentityToken) throws Exception {
        try (Statement statement = c.createStatement()) {
            statement.executeUpdate(SCHEMA_LOCATION);
        } finally {
            LOG.info("Schema now configured");
        }
    }

}