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

Informix Connector: Tables with uppercase characters throw java.sql.SQLException: The specified table is not in the database.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 3.1.0.Alpha2
    • informix-connector
    • None
    • False
    • Hide

      None

      Show
      None
    • False
    • Important

      What Debezium connector do you use and what version?

      3.1.0.Alpha2

      What is the connector configuration?

         connector.class = io.debezium.connector.informix.InformixConnector
         database.user = informix
         database.dbname = test
         offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore
         errors.retry.delay.max.ms = 10000
         offset.flush.timeout.ms = 5000
         include.schema.changes = false
         schema.history.internal.file.filename = schema.dat
         offset.flush.interval.ms = 60000
         topic.prefix = my-app-connector
         schema.history.internal = io.debezium.storage.file.history.FileSchemaHistory
         offset.storage.file.filename = offsets.dat
         errors.max.retries = 5
         database.hostname = localhost
         database.password = ********
         name = engine
         errors.retry.delay.initial.ms = 300
         table.include.list = test\.informix\.SAMPLE1
         value.converter = org.apache.kafka.connect.json.JsonConverter
         key.converter = org.apache.kafka.connect.json.JsonConverter

      What is the captured database version and mode of deployment?

      On-premises IBM Informix Dynamic Server Version 12.10.FC12W1DE

      What behavior do you expect?

      The snapshot and changes to be captured.

      What behavior do you see?

      Table not found exception.
      io.debezium.DebeziumException: java.sql.SQLException: The specified table (informix.sample1) is not in the database.

      Do you see the same behaviour using the latest released Debezium version?

      Yes, tested eith the latest 3.1.0.Alpha2 version

      Do you have the connector logs, ideally from start till finish?

      Yes

      How to reproduce the issue using our tutorial deployment?

      Create a table with uppercase characters in the table name and add it in the table include list.

              Unassigned Unassigned
              eneatafaa Enea Tafa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: