| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Resolving MQ jars in Oracle Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| jmarshall |
 Posted: Wed Jan 04, 2006 11:37 am Post subject: Resolving MQ jars in Oracle Database |
 |
|
Novice
Joined: 04 Jan 2006
Posts: 12
|
I've been trying to load a Java program into an Oracle 9.2 database so I can call it from a pl/sql procedure. The program uses MQ Series jars com.ibm.mq and connector. I have tried to load the jars but get several errors stating that it cant resolve (find) most of the classes. I've tried loading all of the other jars from our MQ Series server, in several different orders, but still cant get them loaded sucessfully. I didnt have much luck in the Oracle forums with this, so I'm hoping the MQ masters can come through. Thanks.
Jeff |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Jan 04, 2006 2:53 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You need probably all the jars from /opt/mqm/java/lib
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jmarshall |
| Posted: Thu Jan 05, 2006 6:59 am Post subject: |
|
|
Novice
Joined: 04 Jan 2006
Posts: 12
|
| Is that directory supposed to be part of the MQ installation? I cant find it anywhere on the server. I searched for jar files in the IBM install directory and found the following of which I tried loading in different orders unsucessfully: com.ibm.mq.jar, com.ibm.mqbind.jar, com.ibm.mqjms.jar, connector.jar, fscontext.jar, jms.jar, jndi.jar, jta.jar, ldap.jar, and providerutil.jar. Also, could it be a version issue? MQ Series 5.3 and Oracle 9.2.0.6. Thanks. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jan 05, 2006 8:17 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well as you are calling the code from a procedure the code running the procedure will need to have all these jars on the CLASSPATH.
Possibly the user starting the DB, before the DB gets started.
Talking about Oracle we run 5.3 CSD06 with the Oracle Messaging gateway.
That means that oracle uses AQ and the gateway moves the messages between MQ and AQ or AQ and MQ.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jmarshall |
| Posted: Fri Jan 06, 2006 10:55 am Post subject: |
|
|
Novice
Joined: 04 Jan 2006
Posts: 12
|
Thank you. I've been considering looking into AQ but have not found much detailed documentation. Can you point me to a good spot?
Thanks again |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Jan 06, 2006 1:43 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Oracle documentation is the start.
Enjoy
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
