ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 4 matches
Author Message
  Topic: How to check database connection before doing query?
j.akershoek

Replies: 7
Views: 2856
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Oct 23, 2012 4:04 am   Subject: How to check database connection before doing query?
I've solved this issue by checking the Exception tree if there is an ORA-03114 error. If so I wait one minute (could probably be shorter but I didn't check that) and redirect back to the Database node ...
  Topic: How to check database connection before doing query?
j.akershoek

Replies: 7
Views: 2856
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Oct 09, 2012 10:32 pm   Subject: How to check database connection before doing query?
Thanks for your suggestions everyone!

I'll let you know how it goes.
  Topic: How to check database connection before doing query?
j.akershoek

Replies: 7
Views: 2856
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Oct 09, 2012 1:22 am   Subject: How to check database connection before doing query?
Hi Marko,

We are using Broker 6.1.0.10.

I am not sure that odbc.ini gives much information, this is what I get from it:
MQSeries DataDirect Technologies 5.3 32-BIT Oracle (32 bit)
Driver32=D:\ ...
  Topic: How to check database connection before doing query?
j.akershoek

Replies: 7
Views: 2856
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Oct 09, 2012 12:59 am   Subject: How to check database connection before doing query?
We have a flow that regularly polls a stored procedure in a source database (Oracle), to see if there are records available that need to be processed. We use ESQL to fetch the data.

The problem I e ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.