Question

JDBCProducer while insertion in SQL server decimal values get rounded of

  • 14 April 2023
  • 2 replies
  • 27 views

I am using JDBCProducer to insert data in SQL Server, I am doing this in batches,

when I start pipeline for bulk (for all Ids, aprox. 6 Lakh record) decimal value is getting rounded of.

When try with preview for one id, it shows correct values (non rounded)

Can any one please help in this? 

 


2 replies

Userlevel 4
Badge

Hi @pankaj.vishwasrao - Thank you for reaching out to the StreamSets Community. This looks compatibility issues to me however would you please try adding the Field Type converter and convert the decimal value before the destination?

Let us know how it goes.

Thank you - AkshayJ

Userlevel 5
Badge +1

@pankaj.vishwasrao 

Hi Pankaj

If the data type is double then field type converter will fix the issue.

Below the sample input and output details for your use case.

If you are converting double to decimal type , please make sure the destination having correct data type to handle the decimal type.

If you can provide me the sample data for which you are having issues , then i can give a try to reproduce it in my setup and will help you on it.

 

Please let me know if you have any concerns/questions.

 

 

Thanks & Regards

Bikram_

Reply