com.atlassian.jira.database

Interface DbConnectionManager

All Known Implementing Classes:

DbConnectionManagerImpl, MockDbConnectionManager

Deprecated.

Use QueryDslAccessor

public interface DbConnectionManager

Provides access to database connections from the Database Connection Pool.

Since:

6.4

Method Summary

Modifier and Type	Method and Description
void	execute(SqlCallback callback) Deprecated. Use QueryDslAccessor.execute(SqlCallback) or QueryDslAccessor.withNewConnection()
<T> T	executeQuery(QueryCallback<T> callback) Deprecated. Use QueryDslAccessor.executeQuery(QueryCallback) or QueryDslAccessor.withNewConnection()
com.querydsl.sql.SQLTemplates	getDialect() Deprecated. This will return a DB dialect as appropriate for usage with Querydsl.

Method Detail

executeQuery

<T> T executeQuery(@Nonnull
                   QueryCallback<T> callback)

Deprecated. Use QueryDslAccessor.executeQuery(QueryCallback) or QueryDslAccessor.withNewConnection()

Executes SQL statements as defined in the callback function and returns the results.

This method is mostly useful for running SELECT statements and returning the given results in some form.

Even if OfBiz is currently running in a ThreadLocal transaction, this will retrieve a fresh connection from the pool. Do not close the given connection - this manager will return it to the pool after the method is complete. If the Callback function throws a RuntimeException and the connection is not in auto-commit mode, then this method will perform a rollback on the connection.

The connection will have the default auto-commit value as defined by the JIRA connection pool. As at JIRA 6.4 this means autocommit == true. See org.apache.commons.dbcp.PoolableConnectionFactory#activateObject(Object) for details.

Type Parameters:

T - type of results

Parameters:

callback - the callback function that runs the query

Returns:

results of the callback function

Since:

6.4

See Also:

execute(SqlCallback)

execute

void execute(@Nonnull
             SqlCallback callback)

Deprecated. Use QueryDslAccessor.execute(SqlCallback) or QueryDslAccessor.withNewConnection()

Executes SQL statements as defined in the callback function.

This method does not return results and is mostly useful for running INSERT, UPDATE, and DELETE operations.

Example Usage:

     dbConnectionManager.execute(new SqlCallback()
     {
         public void run(final DbConnection dbConnection)
         {
             dbConnection.update(QIssueLink.ISSUE_LINK)
                     .set(QIssueLink.ISSUE_LINK.linktype, issueLinkType.getId())
                     .where(QIssueLink.ISSUE_LINK.id.eq(issueLink.getId()))
                     .execute();
         }
     });
 

Even if OfBiz is currently running in a ThreadLocal transaction, this will retrieve a fresh connection from the pool. Do not close the given connection - this manager will return it to the pool after the method is complete. If the Callback function throws a RuntimeException and the connection is not in auto-commit mode, then this method will perform a rollback on the connection.

The connection will have the default auto-commit value as defined by the JIRA connection pool. As at JIRA 6.4 this means autocommit == true. See org.apache.commons.dbcp.PoolableConnectionFactory#activateObject(Object) for details.

Parameters:

callback - the callback function that runs the query

Since:

6.4

See Also:

executeQuery(QueryCallback)

getDialect

@Nonnull
com.querydsl.sql.SQLTemplates getDialect()

Deprecated.

This will return a DB dialect as appropriate for usage with Querydsl.

Returns:

a DB dialect as appropriate for usage with Querydsl.

Since:

6.4