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!






Reply via email to