memiiso/debezium-server-jdbc

Consume debezium events to a jdbc database

debezium-server-jdbc's Issues

Replace Jooq library used to createdestination tables with intial deployment

There is support to create destination tables automatically for this jooq library used.

Find alternative opensource library to do this or implement a method to do it. one option is querydsl

Failed to copy data from sqlserver to postgres

Hi,

I'm doing some tests to use debezium-server-jdbc and when trying to copy data from sqlserver to postgres the following error occurs:

'{"version":"1.9.3.Final","connector":"sqlserver","name":"localhost","ts_ms":1670434961413,"snapshot":"true","db":"ab_prototipo","sequence":null,"schema":"dbo","table":"MOVTO","change_lsn":null,"commit_lsn":"00000034:000001f0:0001","event_serial_no":null}', 'dbo', NULL) was aborted: **ERROR: column "databasename" of relation "cdc_localhost"** does not exist Position: 29 Call getNextException to see other errors in the batch. [statement:"INSERT INTO cdc_localhost (databaseName , tableChanges , source , schemaName , ddl ) VALUES (:databaseName, :tableChanges, :source, :schemaName, :ddl)", arguments:{positional:{}, named:{databaseName:ab_prototipo,tableChanges:[{type=CREATE, id="ab_prototipo"."dbo"."MOVTO", table={defaultCharsetName=null, primaryKeyColumnNames=[CODEMPRESA, DATAMOVTO, NROMOVIMENTO],

Is it possible to use in this case (sqlserver as source -> postgres as sink)?
Because I believe it's just the lack of quotes when using the column that has camel case (in the case of postgres)
I looked here and it would be necessary to change the code where it is used (as this is not configurable in postgres). Am I correct?

Thanks!