| Author |
Message
|
| kishoreraju |
 Posted: Wed Jun 09, 2010 10:45 am Post subject: Connecting to Oracle database from broker on mainframes |
 |
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
Hi All,
I never worked on Message broker running on mainframes.
Presenlty i have to work on an interface which need to retrieve some data from oracle database tables.
is it possible to connect oracle db from broker on mainframes
if yes then where i need add the Datasource information.
where i need look to verify that required drivers installed correctly(DataDirect 5.3 64bit Oracle Wire Protocol)
Thanks in advance
Kishore. |
|
| Back to top |
|
 |
| wschutz |
| Posted: Wed Jun 09, 2010 11:46 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Jun 09, 2010 11:55 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jun 09, 2010 12:45 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| wschutz wrote: |
http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/index.jsp
"If you need to access databases that are not on DB2 on z/OS, you can use DB2's Distributed Data Facility (DDF) and Distributed Relational Architecture (DRDA) to incorporate a remote unit of work within a message flow." |
Well, this almost certainly is true of v6.1 as well, which if kishoreraju is using DD version 5.3 is the most likely version of Broker to be involved.
Broker v7 uses the DataDirect v6.0 drivers. |
|
| Back to top |
|
|
| Cubersome |
| Posted: Wed Dec 23, 2015 1:49 pm Post subject: |
|
|
Apprentice
Joined: 02 Mar 2012
Posts: 37
|
Hi Mqjeff,
I created a configurable service (Type - JDBC Provider) to connect to Oracle Database and I am providing that service name in the Compute Node DSN.
I am getting the following error during the establishment of the connection:
| Code: |
DatabaseException
File:CHARACTER:/srvbuild/v800/wmb/fp04/ERIE915/src/DataFlowEngine/ImbOdbc.cpp
Line:INTEGER:2260
Function:CHARACTER:ImbOdbcConnection::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2393
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
Insert
Type:INTEGER:5
Text:CHARACTER:ORACLECCCX1_CCDEV_A1
Insert
Type:INTEGER:14
Text:CHARACTER:DB2.ODBC64
DatabaseException
File:CHARACTER:/srvbuild/v800/wmb/fp04/ERIE915/src/DataFlowEngine/ImbOdbc.cpp
Line:INTEGER:2446
Function:CHARACTER:ImbOdbcConnection::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:22024
Insert
Type:INTEGER:2
Text:CHARACTER:-300
Insert
Type:INTEGER:5
Text:CHARACTER:{DB2 FOR OS/390}{ODBC DRIVER} DSNT408I SQLCODE = -300, ERROR: THE STRING CONTAINED IN HOST VARIABLE OR PARAMETER 1 IS NOT NUL-TERMINATED DSNT418I SQLSTATE = 22024 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRIHB SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -335 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFEB1' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ERRLOC=1:13:2 |
Can you please advice whether broker running on z/os can connect to Oracle DB using JDBC provider with Compute or Database Node? |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Dec 24, 2015 12:04 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Cubersome wrote: |
Hi Mqjeff,
I created a configurable service (Type - JDBC Provider) to connect to Oracle Database and I am providing that service name in the Compute Node DSN.
|
As per the documentation (you know that thing that nobody reads) an ESQL COMPUTE Node uses an ODBC DSC and most certainly not a JDBC connection. Other compute node types may differ but their features are fully described in .... the Documentaion
As for the Database node, I will leave you to find the answer in the Documentation.
_________________
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 |
|
|
| Vitor |
| Posted: Thu Dec 24, 2015 6:02 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Cubersome wrote: |
| Can you please advice whether broker running on z/os can connect to Oracle DB using JDBC provider with Compute or Database Node? |
No, a broker running on z/OS can't use a JDBC provider with a Compute node. A broker running on Windows or any other distributed platform can't use a JDBC provider with a Compute node.
The InfoCenter explains which database connection types go with which nodes.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
