MQSeries.net :: View topic - Accessing Oracle DB from WMB flow running on main frames

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing Oracle DB from WMB flow running on main frames

Accessing Oracle DB from WMB flow running on main frames

« View previous topic :: View next topic »

Author

Message

vsr

Posted: Tue Jun 16, 2009 11:20 am Post subject: Accessing Oracle DB from WMB flow running on main frames

Centurion

Joined: 04 Apr 2006
Posts: 104

Hi,

I have a requirement to access an oracle database from message flow. The broker is running on z/OS and we are using Message Broker V6.1 running on main frames. The oracle database is on a Unix server.

I didn't have any idea of setting ODBC DSNs on the main frame. Can anyone please suggest me the steps that I should follow?

ovasquez

Posted: Tue Jun 16, 2009 7:37 pm Post subject:

Centurion

Joined: 09 Dec 2005
Posts: 141
Location: Lima, Peru

WMB in z/OS only connect native to DB2 with Compute node...BUT can you use JavaCompute node and use JDBC...with JDBC you have 2 options:
-Use clasic JDBC connection...Class.forName("Oracle...")
-Use JDBC factory
Is better use Use JDBC factory for performance and management...but..this option have problem in 6.1 for z/OS, I create PMR for IBM....maybe is a bug.
Clasic JDBC connection work fine.

OR can you use Compute node with Java..use External function:
Compute_Node--->External_Function--->Java--->JDBC--->Oracle

i have post in this blog..but in spanish..sorry...
http://eoscarvf.blogspot.com/search/label/WebSphere%20Message%20Broker
_________________
Oscar VÃ¡squez Flores

vsr

Posted: Wed Jun 17, 2009 3:18 am Post subject:

Centurion

Joined: 04 Apr 2006
Posts: 104

Thank you ovasquez!

I used JavaCompute node for accessing oracle database JDBC connection and it's working fine.

Actually I was trying to use Compute node because of the performance issues.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing Oracle DB from WMB flow running on main frames

Jump to:

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

Protected by Anti-Spam ACP