File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

batch insert to different tables for one transaction

 
mihir maniar
Ranch Hand
Posts: 88
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would like to insert 3 records, 1 records each in 3 different tables to complete a transaction in IBATIS. I need to repeat this for about 3 to 4 lac records. So while using the SQLMAPExecutor object , while putting a different in this object resulted in taking a long time to insert 5000 records where as if I put only one insert query (i.e. inserting to one table only) then it would hardly 2 seconds to do the same. So please help me with this, since the transaction spans across 2 tables, i need to do that at once and then repeat the same for the other records. Thanks in advance.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic