Ticket #11354

DDL Diff throws Exception
Eröffnet am: 2007-11-19 14:56 Letztes Update: 2007-11-20 23:08

Auswertung:
Verantwortlicher:
(Keine)
Typ:
Status:
Offen
Komponente:
(Keine)
Meilenstein:
(Keine)
Priorität:
5 - Mittel
Schweregrad:
5 - Mittel
Lösung:
Keine
Datei:
Keine

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-Verlauf (1/1 Historien)

2007-11-20 23:08 Aktualisiert von: zigen
Kommentar
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)

Dateianhangliste

Keine Anhänge

Bearbeiten

Please login to add comment to this ticket » Anmelden