Transactions controlling database inserts and Vectors

[Marcus Leon]

How can you put database modifications and access to Java collections
in one transaction?

For example, have one transaction where you insert a row into a
database and add an object to a Vector? If an exception is thrown,
then the database insert is rolled back and the object is not added to
the Vector.

Thanks

 

[enrique]

In a try-catch block, put the rollback and return statement in the
"catch", and the Vector operation somewhere below that.

try
{
MyObject o = sqlInsert(mySQLstatement);
}
catch (DBException e)
{
rollback();
return;
}

myVector.add(o);

 

[shakah]

In a try-catch block, put the rollback and return statement in the
"catch", and the Vector operation somewhere below that.

try
{
MyObject o = sqlInsert(mySQLstatement);
}
catch (DBException e)
{
rollback();
return;
}

myVector.add(o);

Alternatively:

try {
MyObject o = sqlInsert(mySQLstatement);
myVector.add(o);
}
catch (DBException e) {
rollback();
}

return ;