Hi,
we are currently evaluating VPUML Professional and now have trouble
reverse engineering an Oracle Database scheme to JDBC.
The problem is that this fails with an error dialog appearing right after
specifying driver, url, user, etc. stating “Analyze database error”.
In vp.log log I found the following entries:
[Fri Sep 04 08:03:12 CEST 2009] [message] Starting analyzing database…
[Fri Sep 04 08:03:12 CEST 2009] [warning] java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:623)
at v.iujm.i(:207)
at v.iujm.f(:102)
at v.iujm.i(:55)
at v.ewk.d(:67)
at v.iwph.run(:15)
The big question is now: which table??
I tried to use p6spy for sniffing the JDBC calls but this failed due to the fact that I did
not find the classpath from where this sniffer can load his property file …
I have already successfully reverse engineered two databases. I don’t know what is
special about the one giving me this problem …
My Environment:
- Windows XP SP3
- VPUML Prof. 7.0 Build sp1_20090815 (no install with JRE)
- Oracle 10g
- Oracle JDBC Driver 9.0.2.0.0
Thanks for a hint,
Christian
