| Author |
Message
|
| vb.swathij@tcs.com |
 Posted: Wed Jun 27, 2007 10:00 pm Post subject: errors loading MQ jar files at oracle9 server. Urgent |
 |
|
Newbie
Joined: 27 Jun 2007
Posts: 3
|
hi,
I am working on MQ 5.3 version. I have written a sqlj file for which few MQ jar files are required during compilation. When I am trying to load these jar files in oracle 9 server, it is giving below errors.
ORA-29534: referenced object MPCPGM.com/ibm/mq/MQMsg2 could not be resolved
errors : class com/ibm/mq/BindingsConnectionRequestInfo
ORA-29521: referenced name javax/resource/spi/ConnectionRequestInfo could not be found
ORA-29534: referenced object MPCPGM.com/ibm/mq/MQEnvironment could not be resolved
many more like above
Env variables are set as below
MQ_HOME is
/opt/mqm
Ld_LIBRARY_PATH is
/oracle/OraHome1/lib:/opt/mqm/java/lib/fscontext.jar:/opt/mqm/java/lib:/opt/mqm/java/lib/providerutil.jar:/opt/mqm/java/lib/jndi.jar:/opt/mqm/java/lib/com.ibm.mq.jar:/opt/mqm/java/lib/com.ibm.mqjms.jar:/opt/mqm/java/lib/com.ibm.mqbind.jar:/opt/mqm/java/lib/connector.jar:/opt/mqm/java/lib/jms.jar:/opt/mqm/java/lib/jta.jar:/opt/mqm/java/lib/jdbc
CLASSPATH is
/oracle/OraHome1/JRE:/oracle/OraHome1/jlib:/oracle/OraHome1/rdbms/jlib:/oracle/OraHome1/network/jlib:/oracle/OraHome1/jdbc/lib/ojdbc14.jar:/opt/mqm/java/lib/fscontext.jar:/opt/mqm/java/lib:/opt/mqm/java/lib/providerutil.jar:/opt/mqm/java/lib/jndi.jar:/opt/mqm/java/lib/com.ibm.mq.jar:/opt/mqm/java/lib/com.ibm.mqjms.jar:/opt/mqm/java/lib/com.ibm.mqbind.jar:/opt/mqm/java/lib/connector.jar:/opt/mqm/java/lib:/opt/mqm/java/lib/jms.jar:/opt/mqm/java/lib/jta.jar:/opt/mqm/java/lib/jdbc
Could any one help me in resolving the same asap as I am unable to proceed further with coding
Advance Thanks
Swathi |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Jun 28, 2007 3:30 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Install MQ client or MQ server on Oracle machine.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| vb.swathij@tcs.com |
| Posted: Thu Jun 28, 2007 3:40 am Post subject: |
|
|
Newbie
Joined: 27 Jun 2007
Posts: 3
|
jefflowrey,
I don't think one can run the program without installing the MQ server or client on the machine which is a basic initial step.
I have installed MQ on oracle machine and after that I tried loading jar files into oracle database server
Thanks
Swathi |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jun 28, 2007 3:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Okay, sometimes people try to do this with just moving jar files around.
You don't need the jar files in LD_LIBRARY_PATH, I think.
It seems you're missing a jar on the CLASSPATH, though. Based on the missing javax/resource/spi/ConnectionRequestInfo... I'd think it would be the connector.jar or providerutil.jar, but I see those on the classpath.
Is there a separate classpath thing for sqlj deployed files in Oracle?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| marcin.kasinski |
| Posted: Thu Jun 28, 2007 3:59 am Post subject: |
|
|
Sentinel
Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw
|
Where do you have these jars placed , /opt/mqm/java/lib or /usr/mqm/java/lib ?
_________________
Marcin |
|
| Back to top |
|
|
| vb.swathij@tcs.com |
| Posted: Thu Jun 28, 2007 4:07 am Post subject: |
|
|
Newbie
Joined: 27 Jun 2007
Posts: 3
|
hi jefflowrey
I have included all the required jar files in the classpath as mentioned.
I am not very sure abt the classpath for sqlj deployed in Oracle
Thanks
Swathi |
|
| Back to top |
|
|
|
|
