| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| MQSeries Oracle Integratiom |
« View previous topic :: View next topic » |
| Author |
Message
|
| DKG |
 Posted: Thu Aug 17, 2006 6:16 am Post subject: |
 |
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
Well, no... I'm not using an App Server, only an Oracle 9.2 database which has its own JVM (1.3).
Let me put it this way.
I've created a java stored procedure inside the database which uses the class MQQueueManager.
When I try to compile it, it fails because:
com/ibm/mq/MQSPIQueue could not be resolved
When I resolve that class:
com/ibm/mq/MQSESSIONClient could not be resolved
And then:
com/ibm/mq/MQInternalCommunications could not be resolved
After that:
com/ibm/mq/SSLHelper could not be resolved
One more:
com/ibm/mq/SSLCRLHelper could not be resolved
And then, for the big ending, when I resolve SSLCRLHelper this is what I get:
java/security/cert/CertStore could not be found
java/security/cert/X509CRLSelector could not be found
javax/security/auth/x500/X500Principal could not be found
java/security/cert/CertStoreException could not be found
java/security/cert/LDAPCertStoreParameters could not be found
java/security/cert/CRLSelector could not be found
java/security/cert/CertStoreParameters could not be found
There were more errors which I've solved loading jsse.jar class, but I can't find those classes nowhere but in the JRE 1.4 rt.jar file.
Can I get them somewhere else?
Because to upgrade the JVM from 1.3 to 1.4 on the database I would have to migrate the entire database.
It's kind of odd that the class SSLCRLHelper in MQ 5.3 (which has to work under JRE 1.3) imports classes from JRE 1.4
Please, S.O.S!!!!
Thanks!!! |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Aug 17, 2006 6:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you trying to use SSL on your client channel?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| DKG |
| Posted: Thu Aug 17, 2006 6:40 am Post subject: |
|
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
Nope, and I'm not using any of those classes, but the MQQueueManager class has references through other classes to them.
It's seems that the database needs to have all the classes in order to be able to compile the Java Stored Procedure, it doesn't matter that those classes are never going to be used.
I've tried the same Java Stored Procedure as a Java Class on my Eclipse (with JDK 1.3) and it works, but I think that's so because it only check for the classes at runtime, and because I'm not using them, it works.
The code I'm trying is basically the one that MQ Programming Guide proposes:
| Code: |
MQEnvironment.hostname = "my_mq_server_ip";
MQEnvironment.channel = "my_mq_channel";
MQEnvironment.port = 1414;
MQQueueManager qMgr = new MQQueueManager("my_queue_mgr");
[...] |
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Aug 17, 2006 6:55 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So this is a classpath problem, really.
You've shown that it works in one JDK 1.3 environment, but you can't get it to work in a different JDK 1.3. environment - right?
So then you need to understand the classpath on the oracle server.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
