Hi,
I would like to know whether there is a way to begin, rollback and
commite transactions via JDBCcontrols and whether the behavior is same
when the control is injected in a web controller.
For example:
JDBCControl
-----------------
public interface TestControl extends JdbcControl {
@SQL(statement="{sql: statement}")
public void execSQLStatement (String statement) throws SQLException;
}
The Controller uses the injected TestControl and executes:
1. CASE A
Several calls to TestControl.execSQLStatement in a single @Jpf.Action
with BEGIN TRANSACTION, SAVEPOINT, COMMIT
Is the transaction held throughout the @Jpf.Action method
2. CASE B
Several calls to TestControl.execSQLStatement in a several @Jpf.Action
with BEGIN TRANSACTION, SAVEPOINT, COMMIT
Is the transaction held throughout all the @Jpf.Action methods
Kind regards:
al_shopov