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

Connecting to Oracle 12.1.0.2.0 generates ERROR- "NoSuchMethodError: oracle.streams.XStreamUtility.convertSCNToPosition(Loracle/sql/NUMBER;I)[B"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • None
    • None
    • oracle-connector
    • None
    • Hide

      Initial connection not able to get the changes when using Oracle 12.1.0.2.0

      Show
      Initial connection not able to get the changes when using Oracle 12.1.0.2.0

    Description

      Please refer to the group discussion at https://groups.google.com/d/msgid/debezium/7f73b99d-0d8e-4e53-b4d5-f2eee756acd6%40googlegroups.com

      Debezium is unable to work with Oracle 12.1.0.2.0. Produces ERROR as below:

      ERROR Producer failure (io.debezium.pipeline.ErrorHandler:36)
      java.lang.RuntimeException: java.lang.NoSuchMethodError: oracle.streams.XStreamUtility.convertSCNToPosition(Loracle/sql/NUMBER;I)[B

      at io.debezium.connector.oracle.OracleStreamingChangeEventSource.execute(OracleStreamingChangeEventSource.java:74)

      at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:86)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

      Caused by: java.lang.NoSuchMethodError: oracle.streams.XStreamUtility.convertSCNToPosition(Loracle/sql/NUMBER;I)[B

      at io.debezium.connector.oracle.OracleStreamingChangeEventSource.convertScnToPosition(OracleStreamingChangeEventSource.java:111)

      at io.debezium.connector.oracle.OracleStreamingChangeEventSource.execute(OracleStreamingChangeEventSource.java:63)

      ... 6 more

      Configuration used:

      curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" localhost:8083/connectors/ -d '{ "name": "oracle-source-connector", "config":

      { "connector.class" : "io.debezium.connector.oracle.OracleConnector", "tasks.max" : "1", "database.server.name" : "E1Local", "database.hostname" : "VAIO", "database.port" : "1521", "database.user" : "system", "database.password" : "password", "database.dbname" : "E1Local", "table.whitelist" : "XSTRMADMIN.customers", "database.out.server.name" : "dbzxout", "database.history.kafka.bootstrap.servers" : "localhost:9092", "database.history.kafka.topic": "schema-changes.customer" }

      }'

      Log file attached.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ehkhan11 Ehsan Khan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: