Question Re: JDBC: Convert string to NUMERIC in Technology Q&A

JDBC: Convert string to NUMERIC

Former Member — Thu, 08 Dec 2005 15:51:07 GMT

Hi,

I have to update a database table and so far all fields works find during SQL Update. Only a DB-field type numeric doesn't work. On XI I have a string value.

How should I convert it? Any helps welcome.

THX

Matt

Re: JDBC: Convert string to NUMERIC

Former Member — Thu, 08 Dec 2005 16:02:36 GMT

Matthias,

What error does it give or what was the updated data in that numeric field?

regards,

Felix

Re: JDBC: Convert string to NUMERIC

Former Member — Thu, 08 Dec 2005 16:19:03 GMT

Hi Felix,

thx for your quick response... no error I just get no acknowledgement back until I deactivate this field. After deactivation it runs...

Its a 10 digit character and the numeric on DB - side its also 10 digit + decimal places.

THX

Matt

Re: JDBC: Convert string to NUMERIC

Former Member — Thu, 08 Dec 2005 16:57:53 GMT

You can get the error from work directory on the server.

Get the sql error, it could be db specific.

I believe there should be no data conversion needed if your inbound interface also defined as xml:float.

Re: JDBC: Convert string to NUMERIC

Former Member — Thu, 08 Dec 2005 17:34:59 GMT

Matthias,

Does it work for other numeric fields?

regards,

Felix

Re: JDBC: Convert string to NUMERIC

Former Member — Thu, 08 Dec 2005 21:39:30 GMT

Hi Matt,

You better use Numeric field either integer or Long Or double in XI to avoid these confusions..:)

cheers,

Sundararamaprasad.

Re: JDBC: Convert string to NUMERIC

Former Member — Fri, 09 Dec 2005 04:19:13 GMT

Hi,

Use a user-defined java function and convert the String field to Numeric field in ur message mapping.

Try this out.

Regards,

Venkataramanan.

Re: JDBC: Convert string to NUMERIC

Former Member — Fri, 09 Dec 2005 04:51:56 GMT

Hi,

since you use decimal places also, change that field to <b>Double</b> in XI and use.I had a similar situation where a numeric field was not at all retreived when i did a JDBC lookup. Hope this solves your problem.