ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Numeric data types in JDBC adapter

Post new topic  Reply to topic
 Numeric data types in JDBC adapter « View previous topic :: View next topic » 
Author Message
wardster
PostPosted: Thu Jun 15, 2006 6:01 am    Post subject: Numeric data types in JDBC adapter Reply with quote

Newbie

Joined: 17 May 2006
Posts: 5
Hi,
Can anyone shed any light on how to get a numeric (9,9) e.g .100000000 in or out of a database using the WBIA JDBC adapter through WPS/WID?

We are using SQL Server. WBIA JDBC Adapter 2.6.0 and WID

The ODA defualts to creating a business object from such a table with an integer to represent the numeric. A little odd and we suspected this wouldn't work and it doesn't!!! WebSphere Process server running under WID throws a Number format exception trying to convert the input string from the adapter into an int unsurprisingly. Changing the business object to have a string column solves this to get the data into WPS.

To get the numeric back into a WBIA adapter trying to write to a numeric 9,9 is equally problematic! Even assuming there might be some clever conversion going on sending a integer value of 1 (to see what might happen!) through the WID test tool results in the adapter throwing an arithmetic overflow error converting numeric to data type numeric.

Changing the type to string and putting the correct format numeric in, leads to a number format exception in the WBIA JDBC adapter.

Can anyone shed any light - can these adapters deal with numerics?!?
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Jun 15, 2006 7:25 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Maybe you need a long rather than an integer.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
wardster
PostPosted: Thu Jun 15, 2006 7:36 am    Post subject: Reply with quote

Newbie

Joined: 17 May 2006
Posts: 5
Thanks Jeff, unfortunately long is a type supported by the Business Object designer, nor Websphere Integration Developer when selecting data types for the business object.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Numeric data types in JDBC adapter
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.