| Author |
Message
|
| raquel.saracay |
 Posted: Tue Jun 12, 2007 10:18 am Post subject: Connecting to an Oracle Database |
 |
|
Novice
Joined: 10 May 2007
Posts: 11
|
We have an issue trying to develop a flow to read some tables in an oracle database.
The broker is installed in aix, and we alredy change the odbc.ini and set the dbparms using mqsisetdbparms, but we can't get connected.
We are using the handler error code from the sample, and had the right data source name in the filter node. the failure output is connected to a throw node, but when we check the error table there is no exception message.
How can we try the connection?
Do we have to install the oracle client in the broker server?
Thanks, |
|
| Back to top |
|
 |
| EddieA |
| Posted: Tue Jun 12, 2007 10:29 am Post subject: Re: Connecting to an Oracle Database |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| raquel.saracay wrote: |
How can we try the connection?
Do we have to install the oracle client in the broker server? |
You can test the connection by using SQLPlus.
If the Oracle is remote to the Broker, yes, you need the client.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| jbanoop |
| Posted: Tue Jun 12, 2007 10:37 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
| I think you definitely should get an exception in the syslog.user (or equivalent) complaining about the same. |
|
| Back to top |
|
|
| raquel.saracay |
| Posted: Tue Jun 12, 2007 2:50 pm Post subject: Re: Connecting to an Oracle Database |
|
|
Novice
Joined: 10 May 2007
Posts: 11
|
we were checking the syslog and found the next info.
It seems the odbc is failling
-------------------------------------------------------------------
Jun 12 16:17:52 WASAIX user:err|error WebSphere Broker v6003[6947056]: (BROKERTS
T.TEST)[2854]BIP2232E: Error detected whilst handling a previous error in node '
f_UniversoClientes_sinOracle.ThrowMapping'. : BROKERTST.6d14f0c3-1201-0000-0080-
fdbc97e34e77: /build/S600_P/src/DataFlowEngine/ImbDataFlowNode.cpp: 430: ImbData
FlowNode::logExceptionList: ComIbmThrowNode: f_UniversoClientes_sinOracle#FCMCom
posite_1_7
Jun 12 16:17:52 WASAIX user:err|error WebSphere Broker v6003[6947056]: (BROKERTS
T.TEST)[2854]BIP2230E: Error detected whilst processing a message in node 'f_Uni
versoClientes_sinOracle.Filter'. : BROKERTST.6d14f0c3-1201-0000-0080-fdbc97e34e7
7: /build/S600_P/src/DataFlowEngine/ImbDataFlowNode.cpp: 616: ImbDataFlowNode::c
reateExceptionList: ComIbmFilterNode: f_UniversoClientes_sinOracle#FCMComposite_
1_1
Jun 12 16:17:52 WASAIX user:err|error WebSphere Broker v6003[6947056]: (BROKERTS
T.TEST)[2854]BIP2321E: Database error: ODBC return code '-1'. : BROKERTST.6d14f0
c3-1201-0000-0080-fdbc97e34e77: /build/S600_P/src/DataFlowEngine/ImbOdbc.cpp: 22
7: ImbOdbcHandle::checkRcInner: :
Jun 12 16:17:52 WASAIX user:err|error WebSphere Broker v6003[6947056]: (BROKERTS
T.TEST)[2854]BIP2322E: Database error: SQL State '82'; Native Error Code '0'; Er
ror Text '523 80'. : BROKERTST.6d14f0c3-1201-0000-0080-fdbc97e34e77: /build/S600
_P/src/DataFlowEngine/ImbOdbc.cpp: 355: ImbOdbcHandle::checkRcInner: :
--------------------------------------------------------------------------
| raquel.saracay wrote: |
We have an issue trying to develop a flow to read some tables in an oracle database.
The broker is installed in aix, and we alredy change the odbc.ini and set the dbparms using mqsisetdbparms, but we can't get connected.
We are using the handler error code from the sample, and had the right data source name in the filter node. the failure output is connected to a throw node, but when we check the error table there is no exception message.
How can we try the connection?
Do we have to install the oracle client in the broker server?
Thanks, |
 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jun 12, 2007 2:58 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What driver did you specify in odbc.ini?
Did you follow all the exacting, complicated instructions in the Info Center for configuring an ODBC data source on Unix, including determining if you need to configure both a 32bit and 64bit ODBC entry?
Go through the Info Center section on connecting to databases, page by page. Review everything to make sure your setup matches what the info center say. It's not easy at all.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| raquel.saracay |
| Posted: Tue Jun 12, 2007 3:37 pm Post subject: Re: Connecting to an Oracle Database |
|
|
Novice
Joined: 10 May 2007
Posts: 11
|
This is the ODBC.ini specification. we are using the 5.0 oracle driver
[SUNNELP]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=192.168.151.83
PortNumber=1524
SID=SUNNELP
User=sunint
Password=sunint
WorkArounds=536870912
ProcedureRetResults=1
TraceFile=/home/mqm/devdb.out |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jun 12, 2007 4:26 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Well. There could be a lot of subtle things wrong with your setup. Or it might be a lot simpler.
As I said, the InfoCenter has a lot of information that needs to be double-checked.
And confirm that you can connect from the machine otherwise, using sqlplus.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| davecrighton |
| Posted: Wed Jun 13, 2007 2:45 am Post subject: |
|
|
Novice
Joined: 13 Jun 2007
Posts: 12
|
| Remember that Oracle requires tnsnames.ora and sqlnet.ora to be configured as well as the odbc.ini. |
|
| Back to top |
|
|
|
|
