| Author |
Message
|
| r2504 |
 Posted: Fri Mar 05, 2004 2:17 am Post subject: Problems loading com.ibm.mq.jar (V5R3) into Oracle 9i |
 |
|
Novice
Joined: 05 Mar 2004
Posts: 22
|
We're doing some tests on MQ V5R3 and Oracle 9i, but it seems I can no longer load com.ibm.mq.jar into Oracle ?
If I use the V5R2 com.ibm.mq.jar, it however loads fine with loadjava -u myuser/mypassword@mydb -f -v -r /opt/mqm/java/lib/com.ibm.mq.jar
With the V5R3 version, everything goes well until I gets lot of these ORA-29534 and ORA-29521 errors...
resolving: class com/ibm/mq/BatchMatchingCriteria
errors : class com/ibm/mq/BatchMatchingCriteria
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 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Mar 05, 2004 6:28 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Have you previously loaded com.ibm.mqbind.jar?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sachin_gk |
| Posted: Fri Mar 05, 2004 8:27 am Post subject: |
|
|
Newbie
Joined: 16 May 2001
Posts: 7
|
| You may need to load connector.jar too (for the following javax/resource/spi/ConnectionRequestInfo ) |
|
| Back to top |
|
|
| r2504 |
| Posted: Mon Mar 08, 2004 1:14 am Post subject: |
|
|
Novice
Joined: 05 Mar 2004
Posts: 22
|
Loading connector.jar gives the following issue...
resolving: class javax/resource/ResourceException
resolving: class javax/resource/Referenceable
resolving: class javax/resource/spi/ManagedConnection
errors : class javax/resource/spi/ManagedConnection
ORA-29521: referenced name javax/security/auth/Subject could not be found
skipping : class javax/resource/spi/ConnectionRequestInfo
errors : class javax/resource/spi/ConnectionEventListener
ORA-29534: referenced object MPCPGM.javax/resource/spi/ConnectionEvent could not be resolved
skipping : class javax/resource/spi/LocalTransaction
Is there a way I can find out about these dependencies. Is this documented somewhere ?
Regarding loading com.ibm.mqbind.jar, I believe I tried this in the past, however Java code within Oracle isn't capable of accessing the required shared libraries (with native code) for the bind version. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Mar 08, 2004 6:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
This is starting to look like you have a CLASSPATH issue. Does your Oracle documentation tell you how to adjust the relevant CLASSPATH?
| r2504 wrote: |
| Regarding loading com.ibm.mqbind.jar, I believe I tried this in the past, however Java code within Oracle isn't capable of accessing the required shared libraries (with native code) for the bind version. |
This could be a PATH issue, as well.
I mentioned com.ibm.mqbind.jar, since it looked like your first try was complaining about not finding a class for a Bindings connection.
But maybe you're not running Oracle on the same machine as a Queue Manager? If so, you won't be able to make a BINDINGS connection, so make sure your Java code specifies a hostname and port number in the connection information - so that it acts as a client.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| r2504 |
| Posted: Mon Mar 08, 2004 6:34 am Post subject: |
|
|
Novice
Joined: 05 Mar 2004
Posts: 22
|
I'm not an Oracle specialist, so I might do some things wrong 
Anyway, Oracle is running on the same box as the queuemanager, but I remember from the past that it wasn't possible to use the bindings method as it needs to access native code, and that seems to be a restriction in Oracle as far as I know (unless some proves the opposite).
We do use the bindings method outside of Oracle however (so just native on HP-UX with Java) and that works fine.
About the classpath I don't know... loading Java classes into Oracle is magic to me, and I don't know how it relates to a classpath. The Java runtime itself is loaded by some DBAs, but they don't know much more.
Fact is, it worked fine with the V5R2, and fails on lots of dependencies in V5R3... unless someone else has some extra tips, I'll guess I've to dig deeper in the documentation and Google  |
|
| Back to top |
|
|
| rcrippen |
| Posted: Fri Jun 04, 2004 6:20 am Post subject: Problems loading com.ibm.mq.jar (V5R3) into Oracle 9i |
|
|
Apprentice
Joined: 01 Aug 2002
Posts: 45
Location: Rochester, NY
|
r2504:
Have you been able to resolve this issue. I have a client that is encountering the same type of problem. They have loaded all of the jar files in the /opt/mqm/java/lib directory into Oracle, added that directory to the LD_LIBRARY_PATH variable. and still are getting
ORA29534: referenced object com.ibm.mq.MQQueueManager object cannot be resolved.
Any assistance would be appreciated.
Thanks,
Rob Crippen |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Jun 05, 2004 8:44 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Talk to your Unix Admin.
the LD_LIBRARY_PATH environment variable name changes slightly depending on your OS and platform (AIX, Solaris, HP-UX etc...)
Make sure you have the right environment variables set.
From the problem analysis I have to agree. This does look like a classpath/library path problem.
Make sure you have following in your libpath:
This is an example:
MQ_HOME=/usr/mqm
$MQ_HOME/java/lib:$MQ_HOME/java/lib/jdbc
as for the jars in the classpath I would try and add:
com.ibm.mq.jar
com.ibm.mqjms.jar
com.ibm.mqbind.jar
connector.jar
jndi.jar
provider.jar
jms and jta should be taken care of by the was
You may have to add a few more, dependent mostly on WAS support and specificity as well as web platform.
Hope this helps some.
F.J.  |
|
| Back to top |
|
|
|
|
