Re: Oracle 8.1.7 to MySQL still has issues with Views
Posted by: Jim Howard
Date: July 07, 2005 12:12PM

Hi Mike,

I am having the same problem with the new 1.0.10Beta as listed above:

Here is where I get to in the conversion... again from Oracle 8i (8.1.7)

SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c WHERE v.OWNER=? AND c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V' ORDER BY v.OWNER, v.VIEW_NAME
The schema could not be reverse engineered (error: 0).
ORA-00942: table or view does not exist

Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:500)
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:532)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2946)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineerProcedures(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)

interestingly enough, replacing the ? in the query and running from the command line works great, with just cutting and pasting the rest. Perhaps there is a problem before this query?

Jim




Edited 1 time(s). Last edit at 07/07/2005 12:29PM by Jim Howard.

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.