MQSeries.net :: View topic - Limit of size of data while retrieving from database

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Limit of size of data while retrieving from database

Limit of size of data while retrieving from database

« View previous topic :: View next topic »

Author

Message

sudeepm

Posted: Fri Aug 05, 2011 1:11 am Post subject: Limit of size of data while retrieving from database

Acolyte

Joined: 31 Jan 2008
Posts: 57

I am trying to extract data from Database using select query from Java Compute node.
There is a payload field in the resultset. If the size of payload is around 2.5 MB then I am able to retrieve data easily, but if the size increases say 4 mb then a blank value is returned.

Data is stored in CLOB format in Database table.
Can anybody tell me is there any limit on size of data that can be retrieved from database.

lancelotlinc

Posted: Fri Aug 05, 2011 4:37 am Post subject:

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

There is no limit imposed by Broker. If you are hitting a limit, look at your ODBC/JDBC driver limitations or parameters you can change.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Limit of size of data while retrieving from database

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