This implementation wraps a JDBC {@link 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 {@link Connection#close() close()} all connections after query execution (andresult 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 {@link DefaultConnectionProvider}instead, to control the connection's lifecycle, or implement your own {@link ConnectionProvider}.
@author Aaron Digulla
@author Lukas Eder
| |