batch insert to different tables for one transaction
posted 5 years ago
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.