MQSeries.net :: View topic - Java Compute Node

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 » Java Compute Node

Java Compute Node

« View previous topic :: View next topic »

Author

Message

matuwe

Posted: Mon Sep 03, 2012 11:13 pm Post subject: Java Compute Node

Master

Joined: 05 Dec 2007
Posts: 296

Hi

I am using a java compute node to retrive data from database.. I am reading about 70 000 records and do not want to loop throw all the records to build a message tree. I need to read and pass the information foward like the example below. But this is using ODBC. Is there anyway I in java that I can take the Resultset and pass it to xml and propagate the results?

Currently I doing the old while loop and manualy build the output.

Code:

MbSQLStatement state = createSQLStatement( "dbName",
"SET OutputRoot.XMLNS.integer[] = PASSTHRU('SELECT * FROM " + table + "');" );

mqjeff

Posted: Tue Sep 04, 2012 1:47 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

your sample is not just using ODBC, it's using ESQL - which will end up looping over the results under the covers.

No, I don't believe there's a similar mechanism in the Java API.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Java Compute Node

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