| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC adapter and decimals |
« View previous topic :: View next topic » |
| Author |
Message
|
| 4integration |
 Posted: Tue Jul 10, 2007 6:19 am Post subject: JDBC adapter and decimals |
 |
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hello,
We are using JDBC adapter and want to create records in the database (Oracle). One of the fields are have the type NUMBER(18, 4) i.e. 4 decimals.
The BO type is set to "Double".
When creating and debugging the message in WMB the field contains 100.10 and when the message is on the REQUESTQUEUE it says 1.001E+2 which are correct.
When the message is in the database it contains the value 1.001, not 100.10.
Why is that?
Is it a bug in WBIA for JDBC not able to handle the E+2 stuff and just ignoring?
_________________
Best regards
4 Integration |
|
| Back to top |
|
 |
| pakya |
| Posted: Thu Aug 09, 2007 9:58 pm Post subject: Re: JDBC adapter and decimals |
|
|
Novice
Joined: 22 Mar 2004
Posts: 14
|
Hi,
The above problem is not a bug in Adapter.
The Problem can be resolved with setting a parameter in the BO,at the function where you find set & get function, add function bigDec = true,
This will also give you Dynamic Invvocation problem in your connector configuration
Regards,
Pakya |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
