MQSeries.net :: View topic - Data not inserting in DB

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 » Data not inserting in DB

Data not inserting in DB

« View previous topic :: View next topic »

Author

Message

vikas.bhu

Posted: Wed Apr 25, 2012 7:44 pm Post subject: Data not inserting in DB

Disciple

Joined: 17 May 2009
Posts: 159

Hi,

we are facing while inserting the data in DB.It is not getting inserted and not throwing any error.
we have set Auto commit On.
But when we set commit in compute node it is throwing error "One or more task is pending to update"

We have talked to DBA but no help.

WMB6.1.0.8
Oracle10g

mqsiuser

Posted: Wed Apr 25, 2012 8:31 pm Post subject: Re: Data not inserting in DB

Yatiri

Joined: 15 Apr 2008
Posts: 637
Location: Germany

I guess there is a lock...

Your DBA should look at "open/current" connections (users) and close them (probably just the relevant) forcefully (I guess you are in a dev/test environment)!... I remember there was/is an administration-table (in Oracle) where all connections (I think it was like "user names", like "MeullerA") are listed (and with the option to kill/disconnect them).

Remind your collegues to do commits and not keep (DB-)connections open (in their Database-Tools).

Go/ask around (in your team/department) who is working with exactly that db-table(s) and ask them if they have "open commits", or "done UPDATES/INSERTs without committing (or rolling back)".

Tell them to commit/undo(roll back) (probably add a pushy "now!" or "do it now, I wait here until you are done") and... remind them to not leave "UOW" (unit of works) open in the future (basically that means to "commit;" in Oracle-SQL-Developer) !
_________________
Just use REFERENCEs

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Data not inserting in DB

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