Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select 10000 rows from Oracle in shortest way

843859Jan 23 2006 — edited Jan 23 2006

Looking for a good desicions for trasfering more than 10000 rows from
oracle to mysql using only jdbc. Connect is mostly slow about 1 row in
a second, rights on oracle are just for select, update, insert
operations. I think if I can devide 10000 rows in 10 parts and transfer
them in concurent threads and connections. Any suggestion can help me
to solve this problem.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2006

Added on Jan 23 2006

#java-database-connectivity-jdbc

3 comments

438 views