Package jetbrains.buildServer.serverSide.db

Interface SQLRunnerEx

All Superinterfaces:

DBFunctionsProvider, SQLRunner

All Known Implementing Classes:

DBFacade, SQLRunnerProxy

public interface SQLRunnerEx
extends SQLRunner, DBFunctionsProvider

Author:

Pavel.Sher Date: 23.11.2007

Nested Class Summary

Nested classes/interfaces inherited from interface jetbrains.buildServer.serverSide.SQLRunner

SQLRunner.NoResultSQLAction, SQLRunner.SQLAction<T>

Method Summary

Modifier and Type	Method	Description
DatabaseType	getDatabaseType()	Returns the type of database this data source connected to.
org.springframework.transaction.support.TransactionTemplate	getTransactionTemplate()	Provides with a ready to use Spring's transaction template.
void	runDdl(String query, String task)
void	runDdls(String[] queries)
void	runDmls(String[] queries)
<T> T	runSql(SQLRunner.SQLAction<T> r)

Methods inherited from interface jetbrains.buildServer.serverSide.db.DBFunctionsProvider

getDialect, getWithDB, runAndRetry, runAndRetry, withDB, withDB

Methods inherited from interface jetbrains.buildServer.serverSide.SQLRunner

commitCurrentTransaction, getNextId, runSql, runSql

Method Detail

getDatabaseType

DatabaseType getDatabaseType()

Returns the type of database this data source connected to. This method is fast because it just returns the type value, doesn't perfrom any request and doesn't interact with database server ot jdbc driver.

Returns:

the database type.

getTransactionTemplate

org.springframework.transaction.support.TransactionTemplate getTransactionTemplate()

Provides with a ready to use Spring's transaction template.

This template may be invalidated on some database maintenance operations (such as cleanup, backup, etc.), so don't persist this reference in your classes.

Returns:

a Spring's transaction template.

runDdl

void runDdl(@NotNull
            String query,
            @NotNull
            String task)
     throws org.springframework.jdbc.UncategorizedSQLException

Throws:

org.springframework.jdbc.UncategorizedSQLException

runDdls

void runDdls(@NotNull
             String[] queries)
      throws org.springframework.jdbc.UncategorizedSQLException

Throws:

org.springframework.jdbc.UncategorizedSQLException

runDmls

void runDmls(@NotNull
             String[] queries)
      throws org.springframework.jdbc.UncategorizedSQLException

Throws:

org.springframework.jdbc.UncategorizedSQLException

runSql

<T> T runSql(@NotNull
             SQLRunner.SQLAction<T> r)

Specified by:

runSql in interface SQLRunner