com.whitestein.lsps.stdlib.sql

Interface RunSQL

All Known Implementing Classes:

RunSQLImpl

public interface RunSQL

Runs a given SQL script, either in a current transaction or in a new transaction.

Author:

mvo

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	SQL_ERROR SQL error code.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getCurrentDatabaseName()
void	runSQL(ExecutionContext ctx, java.lang.String sql) Runs a given SQL script in a current transaction.
void	runSQLInNewTransaction(ExecutionContext ctx, java.lang.String sql) Runs a given SQL script in a new transaction.

Field Detail

SQL_ERROR

static final java.lang.String SQL_ERROR

SQL error code.

See Also:

Constant Field Values

Method Detail

runSQL

void runSQL(ExecutionContext ctx,
            java.lang.String sql)
     throws ErrorException

Runs a given SQL script in a current transaction.

Parameters:

ctx -

sql -

Throws:

ErrorException

runSQLInNewTransaction

void runSQLInNewTransaction(ExecutionContext ctx,
                            java.lang.String sql)
                     throws ErrorException

Runs a given SQL script in a new transaction.

Parameters:

ctx -

sql -

Throws:

ErrorException

getCurrentDatabaseName

java.lang.String getCurrentDatabaseName()
                                 throws ErrorException

Returns:

upper cased name of the database (ORACLE, MYSQL, H2, etc.)

Throws:

ErrorException