MQSeries.net :: View topic - 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 Interchange Server + Adapters » JDBC adapter - design Question

JDBC adapter - design Question

« View previous topic :: View next topic »

Author

Message

venky

Posted: Wed Aug 29, 2007 7:29 pm Post subject: JDBC adapter - design Question

Master

Joined: 08 Jul 2003
Posts: 205

Hi All,

Here is the scenario....

First message flow: Using JDBC adapter we are planning to update a DB table with messages from source application.

Potentially there could be a 2nd message flow sending messages to the same adapter (different BO) and updating the same table.

Is there a possibility that we could run into table/row lock issues or other potential issues?

Any suggestion?

Thx,

Posted: Fri Sep 07, 2007 12:54 pm Post subject:

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Hi Venky,

Quote:

Potentially there could be a 2nd message flow sending messages to the same adapter (different BO) and updating the same table

Why do you need to have a different BOs for the same table? You need to have only 1 BO per table. The first flow can send requests with Verb as Create and second flow can send requests with Verb as Update.

Quote:

Is there a possibility that we could run into table/row lock issues or other potential issues?

Yes. If the connector tries to do 2 updates to the same row simultaneously. Or if the connector tries to update a row that is not yet inserted etc.

Quote:

Any suggestion?

There is a property jms.NumConcurrentRequests in the connector configuration file under Standard Properties. If you set this to 1, then the connector will process only one request at a time. So you would not have to worry about row locks.

By default, this property has a value of 10, meaning the connector will process up to 10 requests simultaneously. We can specify a higher value for this property when there are a lot of requests coming in and you just have to insert all the requests into the table.

Regards,
VK.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » JDBC adapter - design Question

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