This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes BatchUpdateException .UpdateCounts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "BatchUpdateException .UpdateCounts" Watch "BatchUpdateException .UpdateCounts" New topic
Author

BatchUpdateException .UpdateCounts

N Naveen
Greenhorn

Joined: Sep 04, 2003
Posts: 27
Hi,
I am doing some batch deletion.
When i am deleting some records from a particular table,if there
are any child records found for a particular statement
in the batch ,will the oracle thin driver
proceed with the rest of the statements in the batch ?
Currently ,i dont think it is doing so.
I used the batchupdateexception.getUpdateCounts and checked for value of -3
(which means statement failed) in the array.
after the non successful record,
it is giving -3 for the statements which dont have child records and
should be deleted.Is there any work around for this ?
In my batch operation,i must be able to identify only those deletions (of records)
which violate the referential constraint for the child record.
I cant do this in a seperate select query.
Can somebody pls help ?

Thanks
Naveen.N
Sadanand Murthy
Ranch Hand

Joined: Nov 26, 2003
Posts: 382
Originally posted by N Naveen:
Hi,
I am doing some batch deletion.
When i am deleting some records from a particular table,if there
are any child records found for a particular statement
in the batch ,will the oracle thin driver
proceed with the rest of the statements in the batch ?
Currently ,i dont think it is doing so.
I used the batchupdateexception.getUpdateCounts and checked for value of -3
(which means statement failed) in the array.
after the non successful record,
it is giving -3 for the statements which dont have child records and
should be deleted.Is there any work around for this ?
In my batch operation,i must be able to identify only those deletions (of records)
which violate the referential constraint for the child record.
I cant do this in a seperate select query.
Can somebody pls help ?

Thanks
Naveen.N

Naveen, I'm not quite sure what you are trying to do. Do you want to delete those rows in parent that don't have any child rows? If so, you can write your delete statement with the where clause of something like the following:
delete parent table where <yr conditions> and not exists (select 1 from child table where child.keys = parent.keys).


Ever Existing, Ever Conscious, Ever-new Bliss
N Naveen
Greenhorn

Joined: Sep 04, 2003
Posts: 27
my purpose is not to delete only those records which dont have child records.
On my screen,i have a set of values which the user may delete.
these values present in x table may or may not have child records in either y or z table.
while trying to delete using batch update,i must be able to identify those values which are giving error /referential constraint error.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: BatchUpdateException .UpdateCounts