jdbcUpsertWriter

[Sukanyavrg]

Hi Team,
I am new to Datapipeline concept. I am facing issue with jdbcUpsertWriter() with sql server DB ,throws " Violation of PRIMARY KEY constraint ,Cannot insert duplicate key in object " but same will work with oracle DB.

Can you please guide me in resolving the error.

Thanks in Advance.

[DeleTaylor]

Hi, can you post the full exception?

[Sukanyavrg]

Sorry sir, Due to security reasons, i dodn't have permissions to share complete stack trace.

Error:
com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'Xpktablename. Cannot insert duplicate key in object 'dbo.tablename'.

[DeleTaylor]

Can you try using new GenericUpsert().setInsertFirst(false) as in the following example to force updates to happen first?

https://github.com/NorthConcepts/DataPipeline-Examples/blob/master/src/main/java/com/northconcepts/datapipeline/examples/cookbook/WriteToDatabaseUsingGenericUpsert.java

[Sukanyavrg]

Hi Sir,
Getting below error on using the line new GenericUpsert().setInsertFirst(false)
Error: The method setInsertFirst(boolean) is undefined for the type GenericUpsert

[Sukanyavrg]

Hi Sir,
Is there any other way round to make it work in both oracle and SQL Server for updating part.

[DeleTaylor]

Please use the latest snapshot to get the method you need. Replace the version you're using with 6.0.0-SNAPSHOT.