| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problems using PASSTHRU and Database Links to Remote Oracle |
« View previous topic :: View next topic » |
| Author |
Message
|
| Newtier |
 Posted: Fri Mar 15, 2002 12:19 pm Post subject: |
 |
|
Newbie
Joined: 14 Mar 2002
Posts: 3
|
We are trying to use PASSTHRU to access Oracle tables via Database links to remote databases (in a Compute node).
The following query uses a database link, and works from SQL*Plus (same uid/pwd and database hostname):
SELECT * FROM VW_MY_TABLE@uid.city.company.com;
When we place the query in a PASSTHRU, the Compute node follows the FAILURE connector path:
SET OutputRoot.XML.HR.Person[]= PASSTHRU('
SELECT * FROM VW_MY_TABLE@uid.city.company.com;
');
When we select against our own copy of the table (not using a link) this works...
SET OutputRoot.XML.HR.Person[]= PASSTHRU('
SELECT * MY_TABLE
');
Anyone have any knowledge on whether database links are supported, and what we may be doing wrong?
Is there a way to retrieve the native SQL Code value to see what errors the database may be issuing?
(Notes:
1. We are using the same uid/pwd for database as broker, non-link calls working fine
2. Using Microsoft ODBC drivers, with the Disable MTS Support checked
3. Config. Mgr and Broker db on W2K
4. Oracle DB on AIX
5. There are no messages in the Event Viewer under any of the topics
6. Nothing we are displaying in a Trace node seems to help
7. We don't know where else to look for diagnostics when a database call does not work from MQSI
)
|
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Mar 15, 2002 1:04 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Did you try printing ExceptionList in catch path? You may get more details of the error in EceptionList.
Kiran
|
|
| Back to top |
|
|
| chaman |
| Posted: Fri Mar 15, 2002 1:12 pm Post subject: |
|
|
Newbie
Joined: 14 Mar 2002
Posts: 7
Location: Montreal, Canada
|
To connect to a remote Database, you need to setup an ODBC Data source on your windows machine, in your case, you can use the merant driver to connect to Oracle. You can then use the data source name in your flow to connect to Oracle.
If you want more info like the SQL error code, you can enable the traces for one specific flow in MQSI under the Operations tab and start the command to read the result, something like this:
mqsireadlog MQSI -u -e default -o trace.xml
mqsiformatlog -i trace.xml -o trace.log
where default is the name of the execution group your tracing. |
|
| Back to top |
|
|
| Newtier |
| Posted: Fri Mar 15, 2002 3:09 pm Post subject: |
|
|
Newbie
Joined: 14 Mar 2002
Posts: 3
|
Thanks for your help.
The ExceptionList is giving us the SQL error detail. We are getting the same ORA-02041 errors we were getting before using DB links without using Passthru (Oracle 8 ODBC driver). The solution then was to turn on the check box "Disable MTS Support". But that is on, and now that we have to use Passthru (for outer joins) we are back to getting that error. I've tried several other ODBC drivers, including MS and Merant drivers, but same result.
Has anyone else had to use DB links with PASSTHRU? |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
