Error in passing decimal from Proxy to SQL

[Former Member]

Hi,

I am having a Proxy to JDBC scenario.

In the proxy sender if the value is 123.45 then I want to pass it as it is to JDBC. The type is FLTP for this.

But unfortunately, proxy sends it as 1.2345E2 and it creates an error in data insertion in SQL.

Please tell me that how can I remove the 'E' stuff.

thanks,

Piyush

[sugata_bagchi2 · Accepted solution]

Hi Piyush,

Declare this field as String.

Thanks

Sugata

[Former Member]

useed formatNumber