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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 3.2.0.CR1
    • 3.1.0.Alpha2
    • informix-connector
    • None
    • 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?

      IBM Informix Dynamic Server Version 12.10.FC12W1DE
      On-premises

      What behavior do you expect?

      The snapshot and changes to be retrieved.

      What behavior do you see?

      A table not found exception.

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

      (Ideally, also verify with latest Alpha/Beta/CR version)

      The behavior is the same using the latest Alpha.

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

      (You might be asked later to provide DEBUG/TRACE level log)

      Yes

      How to reproduce the issue using our tutorial deployment?

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

              Unassigned Unassigned
              eneatafaa Enea Tafa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: