Skip to main content
Solved

jdbc tee processor not write data in microsoft sql server for control hub 3.x


lakshmi_narayanan_t
Discovered Fame

hi,

I am facing issue , to write  a data in  Microsoft Sql server database  by  using JDBC tee processor but its not work .I tried the identity insert on and off in database level .if it Possibile or not .suggest any processor to  achieve this .

ERROR
demo pipeline
jdbc tee configuration 

 

Best answer by Bikram

@lakshmi_narayanan_t 

Kindly check if you have the duplicate entries in the table which is causing the problem.

Also tried remove the column mappings if its the same column is there from the source ,so no need to do the mapping.

View original
Did this topic help you find an answer to your question?

5 replies

Bikram
Headliner
Forum|alt.badge.img+1
  • Headliner
  • 486 replies
  • Answer
  • February 7, 2023

@lakshmi_narayanan_t 

Kindly check if you have the duplicate entries in the table which is causing the problem.

Also tried remove the column mappings if its the same column is there from the source ,so no need to do the mapping.


lakshmi_narayanan_t
Discovered Fame

yes i tried as you mentioned but its not use ,can you please look arround that link tutorial-crud-microservice here i post method is not work .


lakshmi_narayanan_t
Discovered Fame
lakshmi_narayanan_t wrote:

yes i tried as you mentioned but its not use ,can you please look arround that link tutorial-crud-microservice here i post method is not work .

actually jdbc tee procesor  work on mic sql server or  not.


Bikram
Headliner
Forum|alt.badge.img+1
  • Headliner
  • 486 replies
  • February 7, 2023

@lakshmi_narayanan_t 

 

I will have a look into it and update you on the same.


lakshmi_narayanan_t
Discovered Fame
Bikram wrote:

@lakshmi_narayanan_t

 

I will have a look into it and update you on the same.

Any updates from your side.I eagerly waiting for your reply .it’s urgent requirement 


Reply