Re: Oracle to MySQL migration from windows 2003 to linux
Posted by: bhargava chivukula
Date: July 05, 2005 03:53PM

Hi Michael

Thanks for the prompt reply and sorry i couldnt follow up on it. I installed the drivers for both the windows and the linux machines, and as I proceed with the migration, I am getting an error message in the first step. The message is as follows

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using SID
Opening connection ...
Connection jdbc:oracle:thin:*****/****@139.78.89.46:1521:iris
Fetching schemata list.
SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME
Return schemata list.
Schemata names retrieved successfully.
Testing connection ...
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 3.1
Opening connection ...
Connection jdbc:mysql://139.78.89.38:3306/?user=***&password=***&useServerPrepStmts=false
The connection to the target database could not be established (error: 0).
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
at com.mysql.grt.modules.ReverseEngineeringMysqlJdbc.testConnection(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mysql.grt.Grt.callModuleFunction(Unknown Source)


** END NESTED EXCEPTION **



Last packet sent to the server was 31 ms ago.
Details:
com.mysql.jdbc.Connection.createNewIO(Connection.java:2607)
com.mysql.jdbc.Connection.<init>(Connection.java:1474)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringMysqlJdbc.testConnection(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

I did make sure that the java connector is properly installed for the linux box and also set the classpath properly

In the migration process, it is showing that it is connecting to the source correctly but is unable to connect to the target which is when i get this error message

Please help

Thank you in advance

Bhargava

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.