Forums Register Login

BatchUpdateException .UpdateCounts

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
 

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).
+Pie Number of slices to send: Send
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.
Power corrupts. Absolute power xxxxxxxxxxxxxxxx is kinda neat.
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 971 times.
Similar Threads
What approach should be followed?
Firing SQLs in Batch to enhance performance
transaction size and commit
How to speed up Batch Process
NX: design choices..
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 04:04:24.