Re: Importing from Oracle into MySQL

[Fabian Hess]

Hi, seems I have a similar problem with the tool at this stage.
Well, it says Network Adapter could not establish the connection, but if I connect to the Oracle database via sql*plus it works all fine.

Fabian



Details given:

Connecting to source database and retrieve schemata names.
Opening connection ...
Connection jdbc:oracle:thin:xxxxxxxxxxxxxxxxxxxxxxxxxx
Initializing JDBC driver ...
Driver class oracle.jdbc.OracleDriver
The list of schema names could not be retrieved (error: 0).
E/A-Exception: The Network Adapter could not establish the connection
Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringOracle.getSchemata(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)