MQSeries.net :: View topic - JDBC Adapter - Array of business objects

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 Interchange Server + Adapters » JDBC Adapter - Array of business objects

JDBC Adapter - Array of business objects

« View previous topic :: View next topic »

Author

Message

vsircill

Posted: Thu Oct 05, 2006 5:39 am Post subject: JDBC Adapter - Array of business objects

Novice

Joined: 05 Oct 2006
Posts: 10

Hi,

I have a stored procedure with reference cursor which returns multiple rows. I need to get all the rows from the cursor and converted into business object array.

Can somebody shed light on as to how to get array of business objects from JDBC connector.

Any help would be highly appreciated.

Thanks,

Posted: Fri Oct 06, 2006 6:44 am Post subject:

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Which is your database? Are you trying to send data from tables to a queue using the JDBC connector?

For fetching multiple records from the table simultaneouly, you need to define a parent-child relationship in business objects. Parent BO can be a wrapper, if there is only one table to be read from.

You should configure the stored procedure to make an entry into the event table for the JDBC connector, whenever an event happens on the application table.

Regards,
VK.

vsircill

Posted: Fri Oct 06, 2006 7:28 am Post subject:

Novice

Joined: 05 Oct 2006
Posts: 10

Thanks a lot

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » JDBC Adapter - Array of business objects

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