I mean, we will not change existing functionality/behavior/code as there may be dependency applications with same behavior
i.e. currently conn.setAutoCommit (false) is using "BEGIN;"
and the new functionality can be like conn.setAutoCommit(false, <new-parameter> ), where new-parameter can be Boolean or flag which does following way for statements
try
{
conn.savepoint(SP);
SQL-statement;
}
catch(Exception exp)
{
conn.rollback(SP);
throw exp;
}
autocommit is not option as end-user need control/decision to commit or rollback on successful transactions
our applications build with Oracle, SQL-Sever compatible ( i.e. using setAutCommit FALSE at every transaction ),
now are migrating applications compatible with PostgreSQL on cloud,
Thanks
Sridhar