kafka-connect-jdbc-sink icon indicating copy to clipboard operation
kafka-connect-jdbc-sink copied to clipboard
verified publisher icon ibm-messaging

🐛 [BUG] - JDBC Sink Connector Not Writing to Existing Db2 Table

Open Joel-hanson opened this issue 2 years ago • 0 comments

What happened?

It appears that the connector only works if the target table in Db2 isn't already defined. When attempting to write to an existing Db2 table, it fails to do so.

Steps To Reproduce

  1. Set up the JDBC sink connector with the IBM supported version.
  2. Configure it to write to an existing Db2 table.
  3. Run the connector.

Environment

No response

Anything else?

Upon investigation, it was discovered that the issue may be related to the table.name.format configuration parameter. Using a lowercase schema name caused problems, but changing it to uppercase seemed to prevent the connector from trying to create a new table on startup.

Version

1.0.0 (Default)

Relevant log output

com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=DB2INST1.COMPANY;TABLE, DRIVER=4.32.28

Code of Conduct

  • [X] I agree to follow this project's Code of Conduct

Joel-hanson avatar Oct 31 '23 12:10 Joel-hanson