Examples of org.jooq.ConnectionProvider.acquire()

org.jooq.ConnectionProvider.acquire()

Acquire a connection from the connection lifecycle handler.

This method is called by jOOQ exactly once per execution lifecycle, i.e. per {@link 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 {@link #release(Connection)} exactly once. @return A connection for the current ExecuteContext. @throws DataAccessException If anything went wrong while acquiring aconnection

    protected void loadForeignKeys(DefaultRelations relations) throws SQLException {
        ConnectionProvider provider = create().configuration().connectionProvider();
        Connection connection = null;


        try {
            connection = provider.acquire();
            DatabaseMetaData meta = connection.getMetaData();


            for (String table : create()
                    .selectDistinct(DB_INDEX.CLASS_NAME)
                    .from(DB_INDEX)

        // wrapped by a ConnectionProxy, transparently, in order to implement
        // Settings.getStatementType() correctly.


        ConnectionProvider provider = connectionProvider != null ? connectionProvider : configuration.connectionProvider();
        if (connection == null && provider != null) {
            connection(provider, provider.acquire());
        }


        return connection;
    }

        if (meta == null) {
            ConnectionProvider provider = configuration.connectionProvider();
            Connection connection = null;


            try {
                connection = provider.acquire();
                meta = connection.getMetaData();
            }
            catch (SQLException e) {
                throw new DataAccessException("Error while accessing DatabaseMetaData", e);
            }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.