MQSeries.net :: View topic - Database Already in Transaction

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 » Database Already in Transaction

Database Already in Transaction

« View previous topic :: View next topic »

Author

Message

broker_new

Posted: Sat Sep 06, 2008 4:37 pm Post subject: Database Already in Transaction

Yatiri

Joined: 30 Nov 2006
Posts: 614
Location: Washington DC

We have a message flow which updates the Oracle database.
There are several other applications which talk to the same database.
Sometimes Iam getting Database Already in Transaction and sometimes iam getting Cursor limit exceeded and cannot perform any database operations..
My question is Is there a way to OPEN and CLOSE the database connections from compute node or atleast using PASSTHRU can we achieve this..

elvis_gn

Posted: Sun Sep 07, 2008 2:42 am Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi broker_new,

No, you cannot(easily) and should not be trying to open and close database connections...it's for this purpose that MB has it's own connection pooling.

If you are getting cursor limit exceeded or already in transaction, then check as to who all are doing inserts/updates in the same table.

There is a good possibility that there are applications(perhaps even your MB flows) which could be long running and not doing a commit quickly.

Regards.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database Already in Transaction

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