DDL Diff throws Exception

• 報告者: jigarshah
• 担当者: (未割り当て)
• チケットの種類: バグ
• 状況: オープン
• コンポーネント: (未割り当て)
• マイルストーン: (未割り当て)
• 優先度: 5 - 中
• 重要度: 5 - 中
• 解決法: なし
• ファイル: なし

詳細

DDL Diff throws following exception. This is just a
tracker. as per zigen mail this is due to Oracle 10g.
Can this be handled programatically to show some error
? Or ignore this and and take diff of other tables ?

java.sql.SQLException: ORA-01424: missing or illegal
character following the escape character

at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at
oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:262)
at
zigen.plugin.db.core.ColumnSearcher.execute(ColumnSearcher.java:89)
at
zigen.plugin.db.diff.DDLDiffJob.loadColumn(DDLDiffJob.java:280)
at
zigen.plugin.db.diff.DDLDiffJob.loadAll(DDLDiffJob.java:212)
at
zigen.plugin.db.diff.DDLDiffJob.run(DDLDiffJob.java:93)
at
org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
java.lang.NullPointerException
at
zigen.plugin.db.DbPlugin.getShell(DbPlugin.java:251)
at
zigen.plugin.db.DbPlugin.showErrorDialog(DbPlugin.java:638)
at
zigen.plugin.db.diff.DDLDiffJob.loadAll(DDLDiffJob.java:242)
at
zigen.plugin.db.diff.DDLDiffJob.run(DDLDiffJob.java:93)
at
org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

チケットの履歴 (1 件中 1 件表示)

2007-11-20 23:08 更新者: zigen

コメント

Logged In: YES
user_id=31258

This problem occurs with there a table in the garbage box
in the
Oracle10g environment.

When you execute DROP TABLE
The table like BIN$HGnc55/7rRPgQPeM/qQoRw==$0 is made.

This table name is a problem.

It tries to retrieve column information on this table, and
SQLException is thrown out by the
DatabaseMetaData#getColumns()
method.

To solve this problem
It is necessary to see a peculiar table to Oracle.
(USER_RECYCLEBIN)