Greeting, I will load millions of data from Oracle10 to postgreSQL8 through JDBC.
I like the spring+ibatis framework. May I know how ibatis deal with big chunk of data please?
The example I had is the following, would you suggest better solution?
(1)Transaction begins
(2) select from oracle.table1 into object1
. possible solution is to split table1 into
table1_subgroupdata1, ...n
(3) for loop object1
=> insert into postgreSQL
(4) if success commit
else rollback
(5) Transaction ends
Thanks a lot!
