DDL Diff throws Exception

• Reporter: jigarshah
• 소유자: (None)
• Type: Bugs
• Status: Open
• Component: (None)
• MileStone: (None)
• Priority: 5 - Medium
• Severity: 5 - Medium
• Resolution: None
• File: None

Details

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)

Ticket History (1/1 Histories)

2007-11-20 23:08 Updated by: 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)