com.whitestein.lsps.stdlib.sql

Class RunSQLImpl

java.lang.Object

com.whitestein.lsps.stdlib.sql.RunSQLImpl

All Implemented Interfaces:

RunSQL

@PermitAll
public class RunSQLImpl
extends java.lang.Object
implements RunSQL

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

Author:

mvo

Field Summary

Fields inherited from interface com.whitestein.lsps.stdlib.sql.RunSQL

SQL_ERROR

Constructor Summary

Constructors

Constructor and Description
RunSQLImpl()

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.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

RunSQLImpl

public RunSQLImpl()

Method Detail

runSQL

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

Description copied from interface: RunSQL

Runs a given SQL script in a current transaction.

Specified by:

runSQL in interface RunSQL

Throws:

ErrorException

runSQLInNewTransaction

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

Description copied from interface: RunSQL

Runs a given SQL script in a new transaction.

Specified by:

runSQLInNewTransaction in interface RunSQL

Throws:

ErrorException

getCurrentDatabaseName

public java.lang.String getCurrentDatabaseName()
                                        throws ErrorException

Specified by:

getCurrentDatabaseName in interface RunSQL

Returns:

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

Throws:

ErrorException