hi,
I have code which has the following structure. I am getting a set of rows using the first statement and then executing the individual statements which may be a bunch of inserts, creates or deletes or drops .
I want to commit if everything works or rollback the entire thing if there is an individual error during the execution of one of the statements.
The problem i am facing is when i have a group of inserts and a drop or create , if there is an error create or drop the inserts prior to it are commiting even though setAutoCommit(false) is set but it works fine if all of the statemnts are inserts . I appreciate your valuable suggestions. I am using oracle 9i.
try
{
conn.setAutoCommit(false);
resultset rs = ...;
while(rs.next())
{
try
{
}
catch(Exception e)
{
conn.rollback();
}
} // end of while
}
catch(Exception e1)
{
}
regards
VVS
I have code which has the following structure. I am getting a set of rows using the first statement and then executing the individual statements which may be a bunch of inserts, creates or deletes or drops .
I want to commit if everything works or rollback the entire thing if there is an individual error during the execution of one of the statements.
The problem i am facing is when i have a group of inserts and a drop or create , if there is an error create or drop the inserts prior to it are commiting even though setAutoCommit(false) is set but it works fine if all of the statemnts are inserts . I appreciate your valuable suggestions. I am using oracle 9i.
try
{
conn.setAutoCommit(false);
resultset rs = ...;
while(rs.next())
{
try
{
}
catch(Exception e)
{
conn.rollback();
}
} // end of while
}
catch(Exception e1)
{
}
regards
VVS