particular SQLCODE bypass in batch mode

[karshyam chandran]

Hi,

I am running a java application in batch mode by reading records from a oracle table and if a matching row found in another table insert a record into 3rd table. While inserting record if I get sqlcode -803 ( duplicate row ) I would not want to stop the process because of sql exception. I want to skip this row and continue processing the next row .

Could anyone tell me how I can code this , please.

Thanks
karshyam

[Jeanne Boyarsky]

Karshyam,
Welcome to JavaRanch!

In JDBC, each transaction is commited to the database by default. So you can just catch the exception and move on to the next record.

[karshyam chandran]

Thanks for your response.

I am trying to find out, is there a way to tell that if a sqlexception with a particular sql code happens donot catch the exception and continue processing as such it is OK to have that exception.

The only way to control this is by coding the logic in catch block I can do it. Before that I wanted to make sure , Is that the correct solution.

Any thoughts , please share it.

Thanks..

[Jeanne Boyarsky]

Karshyam,
Yes, you need to code logic in the catch block. The pattern for this is:

try {
  // do stuff
} catch (SQLException e) {
  if ( e.getMessage().indexOf(CODE) == -1 ) {
    throw e;
  } else {
    // log database exception
  }
}