Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Retrieving remaing statements from failed batch

 
Gaurav Chikara
Ranch Hand
Posts: 412
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Chengwei Lee
Ranch Hand
Posts: 884
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic