Description Jean-Francois Brazeau 2015-09-17 04:54:55 EDT

If you reset your Oracle schema by droping all CDO tables, tables are in fact moved to the recycle bin.

When CDO startups it seems to process these tables and fails when executing such a request :  SELECT * FROM BIN$3REAOUPYTJ+AXL21HGB8XQ==$0;

(once a table has been droped, its name looks like "BIN$3REAOUPYTJ+AXL21HGB8XQ==$0" in the recycle bin).

This request could work if the table name was surroundes by double quotes, but CDO doesn't do it and the request fails.

Here is the stack :
java.sql.SQLException: ORA-00933: SQL command not properly ended
  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:743)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
  at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
  at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
  at org.eclipse.net4j.spi.db.DBAdapter.readFields(DBAdapter.java:193)
  at org.eclipse.net4j.spi.db.DBAdapter.readSchema(DBAdapter.java:167)