kafka-connect-jdbc icon indicating copy to clipboard operation
kafka-connect-jdbc copied to clipboard

informix dialect is missing.

Open CodingKrishna opened this issue 6 years ago • 4 comments
trafficstars

While connecting to the informix it is able to connect but query is not working, because there is no informix dialect. plz let me know if i'm doing something wrong.

Failed to run query for table TimestampIncrementingTableQuerier{table="db_xyz "." informix "." test", query='null', topicPrefix='abc-', incrementingColumn='testid', timestampColumns=[]}: {} (io.confluent.connect.jdbc.source.JdbcSourceTask) java.sql.SQLSyntaxErrorException: A syntax error has occurred.

CodingKrishna avatar Jan 22 '19 10:01 CodingKrishna

Correct, there is no Informix dialect yet. If the general JDBC dialect does not work, then we'd need to add an Informix dialect that has the Informix-specific behaviors.

rhauch avatar Jan 22 '19 22:01 rhauch

Is somebody have a solution for this issues? Please help.

dungba82 avatar Sep 10 '20 04:09 dungba82

Hi @dboyce , @rhauch,@stheppi, I have a fix for this please do let me know whether i need to contributor to add this feature.

vigneshtvp avatar Apr 21 '21 18:04 vigneshtvp

@vigneshtvp could you share your jdbc with the modifications in some repository? I would greatly appreciate it. :)

maximilianobl avatar Aug 26 '22 01:08 maximilianobl