Skip to Main Content

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!

Urgent: Oracle-large tables-copy

843854Jun 24 2004 — edited Jun 25 2004
Hello,

I'll appriciate a lot if somebody can help me solve this problem:
I'm using rdbthin.jar as driver on my client-pc an am trying to copy data from table in Oracle Rdb to table in MySQL with the same structure. When there a more then 500 rows in a result set, I become following exception:
java.sql.SQLException: in <rdbjdbcsrv:fetch>
%RDB-F-SYS_REQUEST, error from system services request
-COSI-F-CREATERR, cannot create file
-RMS-F-DEV, error in device name or inappropriate device type for operation
@rdb.Client.fillCache
@rdb.Client.fillCache
@rdb.Client.fillCache
at oracle.rdb.jdbc.common.Client.throwException(Client.java:3287)
at oracle.rdb.jdbc.common.Client.throwException(Client.java:3254)
at oracle.rdb.jdbc.common.Client.FetchRow(Client.java:863)
at oracle.rdb.jdbc.rdbThin.Rdb.FetchRow(Rdb.java:671)
an there are less datarows in the client then it must be.
I am retrieving now all rows and then insert them row by row in mysql-table.
Is there a way I get row by row or 500 rows an then other 500 better to solve this?

Thank you in forward!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2004
Added on Jun 24 2004
2 comments
184 views