File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Retrieving  remaing statements from failed batch Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Retrieving  remaing statements from failed batch" Watch "Retrieving  remaing statements from failed batch" New topic
Author

Retrieving remaing statements from failed batch

Gaurav Chikara
Ranch Hand

Joined: Jun 09, 2000
Posts: 410
Dear All

I have been looking into JAVA API of java.sql package but couldn't find any way where we can retrive the remaing statments of a batch( excluding culprit one which caused batch to fail)

Do any one of you knows anything about it?
Thanks in advance
[ March 22, 2007: Message edited by: Gaurav Chikara ]

SCJP,SCWCD,SCBCD<br />If Opportunity doesn't knock then build the door
Chengwei Lee
Ranch Hand

Joined: Apr 02, 2004
Posts: 884
Won't it be better to rollback the entire transaction if the batch update failed? So you won't need to find out which statements executed successfully and which failed.


SCJP 1.4 * SCWCD 1.4 * SCBCD 1.3 * SCJA 1.0 * TOGAF 8
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Retrieving remaing statements from failed batch
 
Similar Threads
Batch updation
marble puzzle
regarding access of another server
how to avoid numberformat Exception
5 letter scrabble