Insert explicit value for identity column mssql database - Githubissues

confluentinc / kafka-connect-jdbc

Kafka Connect connector for JDBC-compatible databases

Other

19 stars 955 forks source link

Insert explicit value for identity column mssql database #1287

Open sgv0007 opened 1 year ago

sgv0007 commented 1 year ago

Hi Team,

I am getting error while inserting records to ms sql database table. Can you please let me know if there is any solution or workaround for this problem.

java.sql.BatchUpdateException: Cannot insert explicit value for identity column in table 'Clients' when IDENTITY_INSERT is set to OFF.

similar to issue: https://github.com/confluentinc/kafka-connect-jdbc/issues/837

Thanks, Shiva