org.jooq.impl

Class DataSourceConnectionProvider

java.lang.Object

org.jooq.impl.DataSourceConnectionProvider

All Implemented Interfaces:

ConnectionProvider

public class DataSourceConnectionProvider
extends java.lang.Object
implements ConnectionProvider

A default implementation for a pooled DataSource-oriented ConnectionProvider

This implementation wraps a JDBC DataSource. jOOQ will use that data source for initialising connections, and creating statements.

Use this connection provider if you want to run distributed transactions, such as javax.transaction.UserTransaction. jOOQ will close() all connections after query execution (and result fetching) in order to return the connection to the connection pool. If you do not use distributed transactions, this will produce driver-specific behaviour at the end of query execution at close() invocation (e.g. a transaction rollback). Use a DefaultConnectionProvider instead, to control the connection's lifecycle, or implement your own ConnectionProvider.

Author:

Aaron Digulla, Lukas Eder

Constructor Summary

Constructors

Constructor and Description
DataSourceConnectionProvider(javax.sql.DataSource dataSource)

Method Summary

Modifier and Type	Method and Description
java.sql.Connection	acquire() Acquire a connection from the connection lifecycle handler.
javax.sql.DataSource	dataSource()
void	release(java.sql.Connection connection) Release a connection to the connection lifecycle handler.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DataSourceConnectionProvider

public DataSourceConnectionProvider(javax.sql.DataSource dataSource)

Method Detail

dataSource

public javax.sql.DataSource dataSource()

acquire

public java.sql.Connection acquire()

Description copied from interface: ConnectionProvider

Acquire a connection from the connection lifecycle handler.

This method is called by jOOQ exactly once per execution lifecycle, i.e. per ExecuteContext. Implementations may freely chose, whether subsequent calls to this method:

• return the same connection instance
• return the same connection instance for the same thread
• return the same connection instance for the same transaction (e.g. a javax.transaction.UserTransaction)
• return a fresh connection instance every time

jOOQ will guarantee that every acquired connection is released through ConnectionProvider.release(Connection) exactly once.

Specified by:

acquire in interface ConnectionProvider

Returns:

A connection for the current ExecuteContext.

release

public void release(java.sql.Connection connection)

Description copied from interface: ConnectionProvider

Release a connection to the connection lifecycle handler.

jOOQ will guarantee that every acquired connection is released exactly once.

Specified by:

release in interface ConnectionProvider

Parameters:

connection - A connection that was previously obtained from ConnectionProvider.acquire(). This is never null.