| Author |
Message
|
| sam55 |
 Posted: Sun Sep 23, 2012 6:39 pm Post subject: database issue/odbc doesn't timeout |
 |
|
Newbie
Joined: 23 Sep 2012
Posts: 4
|
Hello MB Guru's
I am using sql query in mb and hitting the database. Some other applications are causing deadlock in the db (and stops processing transactions of broker). Since db calls in the mb (ver 6.1) are sync calls, mb flow is waiting forever to get response from db , which leads to different kinds of issues . We have large number of flows which are running in production, it is impossible to add timeout logic for all these flows. I am looking for changing odbc setting to timeout the query in Unix system.I am not sure whether is there any default setting to timeout query in odbc/odbc oracle driver V 5.3 64bit Wire Protocol.
Correct answer will be awarded with 1000 
Last edited by sam55 on Mon Sep 24, 2012 6:36 pm; edited 5 times in total |
|
| Back to top |
|
 |
| sam55 |
| Posted: Sun Sep 23, 2012 6:41 pm Post subject: |
|
|
Newbie
Joined: 23 Sep 2012
Posts: 4
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Sep 23, 2012 6:49 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
A good thing then that you're not using the ORACLE ODBC driver but the DATASOFT ODBC driver for the oracle protocol.... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sam55 |
| Posted: Sun Sep 23, 2012 7:01 pm Post subject: |
|
|
Newbie
Joined: 23 Sep 2012
Posts: 4
|
How can you say I am using different driver ? I am using oracle odbc database driver.Oracle stanza contains
| Quote: |
;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol |
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Sep 24, 2012 12:39 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| sam55 wrote: |
How can you say I am using different driver ? I am using oracle odbc database driver.Oracle stanza contains
| Quote: |
;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol |
|
Perhaps you are a little confused by the terminology.
Oracle provided ODBC Compliant drivers with its Database. However those drivers do not work with Broker. You have to use the ones supplied with the Broker products.
These happen to be provided by DataDirect.
So you are connecting to Oracle using the Broker supplied DataDirect ODBC Driver. That is correct!
NOT as you posted in your Original Question. That is where the possible confusion might lie. If you had shown the odbc.ini stanza in the first place then therw would have been no confusion.
Your second post is also a 'red herring' as you are not using the Microsoft ODBC Drivers either.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| sam55 |
| Posted: Mon Sep 24, 2012 5:12 pm Post subject: |
|
|
Newbie
Joined: 23 Sep 2012
Posts: 4
|
Thanks for reply. 
So how can we achieve timeout in odbc for mb v 6.1, which parameter do I need to change .Following is the stanza we are using in unix
| Code: |
;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
SID=<Your Oracle SID>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1 |
|
|
| Back to top |
|
|
|
|
