• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Junilu Lacar
  • Martin Vashko
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Scott Selikoff
  • salvin francis
  • Piet Souris

Batch SQL Delete

 
Ranch Hand
Posts: 168
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

There is a way to perform SQL update operation in batch using BatchSqlUpdate class.Similarly is there any way to perform delete operation also in batch?.Say i want to delete set of records at one stretch.I know there is no such class like BatchSqlDelete.But is there any other way to perform the same?.

Any inputs on this would be very much appreciated.

Thanks in advance...

Regards,
Priya.
 
Ranch Hand
Posts: 387
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi Priya,

BatchSqlUpdate works for inserts as well (see www.springdeveloper.com/oscon/jdbc.pdf), so it probably works for deletes too.

javax.sql.Statement also has executeUpdate(..) method that does insert, delete
(and update of course)

Herman
 
When it is used for evil, then watch out! When it is used for good, then things are much nicer. Like this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!