Re: Oracle to MySQL migration from windows 2003 to linux
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
Subject
Written By
Posted
Re: Oracle to MySQL migration from windows 2003 to linux
July 05, 2005 03:53PM
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.