Bug #9923 Error while using Mysql migration tool kit

• Submitted: 15 Apr 2005 5:25
• Modified: 27 May 2005 4:47
• Reporter: sandeep kannan
• Status: No Feedback
• Category: MySQL Migration Toolkit
• Severity: S1 (Critical)
• Version: mysql-migration-toolkit-1.0.4-alpha-win32.msi
• OS: Windows (windows XP)
• Assigned to: Assigned Account
• CPU Architecture: Any

[15 Apr 2005 5:25] sandeep kannan

Description:
When trying to migrate Oracle database to Mysql using “Mysql Migration Toolkit”, I got an error when trying to fetch the files from Oracle database i.e. during the reverse engineering process.

It read as follows:

 

The schema could not be reverse engineered (error: 0).

Invalid column name

Details: 

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)

oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:6218)

oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1557)

oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1543)

com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineerViews(Unknown Source)

com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineer(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 also would like to know whether the code knows which column to read or should we change the code.

I am not able to proceed further. please advice.

How to repeat:
First connect t the source database(Oracle) and then connect to the target database(Mysql). Then after this it asks for us to choose the schemata that are to be migrated.After choosing the schemata, and in the next step it gives an error which reads as shown in the description column.

[18 Apr 2005 5:56] sandeep kannan

Error during the reverse engineering process.While trying to fetch the shemata after connecting to the source database, it gives an error reading "invalid column name and the schemata could not be reverse engineered".

[26 Apr 2005 19:13] Michael G. Zinner

Can you state which version of Oracle are you trying to migrate? The tool is tested against 9i and 10g.

[27 Apr 2005 4:42] sandeep kannan

We are currently using Oracle 9i as our database.

[27 Apr 2005 4:47] sandeep kannan

I would like to know whether this toolkit supports foreign key constraints and primary key constraints.

[27 May 2005 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".