com.atlassian.jira.database

Interface DbConnection

All Known Implementing Classes:

DbConnnectionImpl

public interface DbConnection

A handle to a Database Connection obtained from JIRA's connection pool.

Since:

v6.4

See Also:

DbConnectionManager

Method Summary

Methods

Modifier and Type	Method and Description
void	commit()
Connection	getJdbcConnection() Returns the JDBC connection wrapped by this object.
com.mysema.query.sql.SQLQuery	newSqlQuery() Starts a SELECT statement on this connection.
void	rollback()
void	setAutoCommit(boolean autoCommit)
com.mysema.query.sql.dml.SQLUpdateClause	update(com.mysema.query.sql.RelationalPath<?> entity) Starts an update statement on the given DB Table.

Method Detail

getJdbcConnection

Connection getJdbcConnection()

Returns the JDBC connection wrapped by this object.

Returns:

the JDBC connection wrapped by this object.

newSqlQuery

com.mysema.query.sql.SQLQuery newSqlQuery()

Starts a SELECT statement on this connection.

Example usage:

     QVersion v = new QVersion("v");

     final List versions =
             dbConnection.newSqlQuery()
                     .from(v)
                     .where(v.project.eq(projectId))
                     .orderBy(v.sequence.asc())
                     .list(v);
 

Returns:

the new Query builder.

update

com.mysema.query.sql.dml.SQLUpdateClause update(com.mysema.query.sql.RelationalPath<?> entity)

Starts an update statement on the given DB Table.

Example usage:

        dbConnection.update(QIssueLink.ISSUE_LINK)
                .set(QIssueLink.ISSUE_LINK.linktype, newIssueLinkTypeId)
                .where(QIssueLink.ISSUE_LINK.id.eq(issueLink.getId()))
                .execute();
 

Parameters:

entity - The DB entity you want to update eg QIssue.ISSUE

Returns:

a builder to create your update statement.

setAutoCommit

void setAutoCommit(boolean autoCommit)

commit

void commit()

rollback

void rollback()