Dear All,

Does the Firebird JDBC driver provide support for rollback retaining?
because i use rollback function but it's not work fine.

try
{
con.setAutoCommit(false);

if (vPrepare != null && vPrepare.size() > 0)
{
int rresult = 0;

for (int i = 0; i < vPrepare.size(); i++)
{
count = i;
rresult =
(( PreparedStatement ) vPrepare.get(i)).executeUpdate();
result += rresult;
}
}
if (result == vPrepare.size()){
iReturn = 1;
con.commit();
con.setAutoCommit(true);
}else{
iReturn = 0;
con.rollback();
con.setAutoCommit(true);
}
}
catch (SQLException e)
{
try
{
iReturn = 0;
con.rollback();
con.setAutoCommit(true);
}
catch (SQLException re)
{
}
}
finally
{
vPrepare = null;
vQuery = null;

poolManager.returnConnection(dataBase, con);
}

Thanks and Regards,
Benny Setiawan T