MQSeries.net :: View topic - Message Broker with JDBC Adapter...

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 » Message Broker with JDBC Adapter...

Message Broker with JDBC Adapter...

« View previous topic :: View next topic »

Author

Message

kiran_mvr

Posted: Tue Jul 26, 2005 8:28 am Post subject: Message Broker with JDBC Adapter...

Apprentice

Joined: 12 Dec 2004
Posts: 35

Can someone please explain how we could achieve this?

We are using Message Broker with JDBC adapter.
What will be the best way to do a two step database process in one call..

a) Insert data (BO)
b) Call Stored Proc

Need to roll back 'a' if 'b' fails.

Any reference, experience..will help.
_________________
Kiran_manny

recallsunny

Posted: Tue Jul 26, 2005 10:57 am Post subject:

Disciple

Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts

You could try doing the insert within the stored Proc all in the same transaction... Send the parameters for insert as IN variables for the stored proc.

Use CreateSP attribute in the BO for invoking the SP using JDBC adapter.

Code:

CREATE OR REPLACE PROCEDURE XYZ (parms)
AS
BEGIN
Insert into table
Exec your stored proc code
COMMIT;

EXCEPTION
WHEN OTHERS THEN ROLLBACK;
END

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker with 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