Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4584

Incremental snapshots does not honor column case sensitivity

XMLWordPrintable

      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099)\n\tat oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1293)\n\tat oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)\n\tat io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:644)\n\tat io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:513)\n\tat io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotChangeEventSource.readChunk(AbstractIncrementalSnapshotChangeEventSource.java:274)\n\t... 26 more\nCaused by: Error : 904, Position : 45, Sql = SELECT * FROM \"ODS_XMES_QY\".\"ORDER\" ORDER BY Oid DESC FETCH NEXT 1 ROWS ONLY, OriginalSql = SELECT * FROM \"ODS_XMES_QY\".\"ORDER\" ORDER BY Oid DESC FETCH NEXT 1 ROWS ONLY, Error Msg = ORA-00904: \"OID\": invalid identifier\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)\n\t... 41 more\n"

       PS:"Oid" is primary key,Oracle is case-insensitive。

              ccranfor@redhat.com Chris Cranford
              desctan90 zainc chou (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: