SQLJ problem

[Jeff6776]

Using Oracle 8.1.5 and Sqlj

I have a class with a member variable declared as such.
private ExecutionContext context = new ExecutionContext();

Here is my code to set the rollback segment
try{
#sql [context] {
set transaction use rollback segment R01
};
}
catch(java.sql.SQLException ex){...}
 

After a huge delete using sqlj and the same Execution Context

try{
#sql [context] {
// delete 185,000 records
};
}
catch(java.sql.SQLException ex){...}


I get this as my error.
java.sql.SQLException: ORA-01562: failed to extend rollback segment number 5
ORA-01650: unable to extend rollback segment R04 by 64 in tablespace RBS



My question is, does anyone know why I'm still using R04 after I've set the rollback segment to R01?

 

[karluk]

It's just a guess, but maybe your transaction has ended before you get to code that generates the Ora-01562. For example a commit should terminate the transaction and release the rollback segment.