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 String	SQL_ERROR SQL error code.

Method Summary

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

Field Detail

SQL_ERROR

static final String SQL_ERROR

SQL error code.

See Also:

Constant Field Values

Method Detail

runSQL

void runSQL(ExecutionContext ctx,
            String sql)
     throws ErrorException

Runs a given SQL script in a current transaction.

Parameters:

ctx -

sql -

Throws:

ErrorException

runSQLInNewTransaction

void runSQLInNewTransaction(ExecutionContext ctx,
                            String sql)
                     throws ErrorException

Runs a given SQL script in a new transaction.

Parameters:

ctx -

sql -

Throws:

ErrorException

getCurrentDatabaseName

String getCurrentDatabaseName()
                       throws ErrorException

Returns:

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

Throws:

ErrorException