| Author |
Message
|
| JohnJeff |
 Posted: Thu Dec 11, 2003 11:50 am Post subject: MQSeries Oracle Integratiom |
 |
|
Newbie
Joined: 11 Dec 2003
Posts: 1
|
Does anyone have any experience they would like to share, taking data of queues and bunging it in oracle tables. Options I could consider are 1/writting c code
2/MA01 SupportPak (not sure if this results in a triggerable app)
3/Buy an IBM WebSphere Oracle Adapter
4/Find an Oracle product
5/Any other vendors adapters
Option 1 is straight forward. Anyone know about MA01 and triggering or tried any adapters?
Thanks |
|
| Back to top |
|
 |
| bgoldstein |
| Posted: Wed Apr 21, 2004 8:46 am Post subject: Mqseries Oracle Integration |
|
|
Novice
Joined: 14 Feb 2002
Posts: 19
Location: Ameren Services, St.Louis,Mo., USA
|
We trigger our PL/SQL code containing mqseries calls with a script.
1. The trigger monitor starts a script which uses sqlplus to connect with Oracle and request execution of a stored procedure.
2. The stored procedure opens the queue, gets the messages, and inserts the rows into a table.
_________________
+
| Barry Goldstein
| Ameren Services
| Saint Louis, Missouri
| bgoldstein@ameren.com
| (314) 554-4351
+ |
|
| Back to top |
|
|
| Tibor |
| Posted: Wed Apr 21, 2004 3:35 pm Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
(5) MQBroker/Oracle seems very pretty because it supports the native PL/SQL and transactional integrity.
http://www.multiconn.com/mq_oracle.html
I don't tell you any pros and cons, because we are in planning phase in this theme, too.
Tibor
PS: do anyone heard about handling mq from oracle java stored procedures? |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Apr 21, 2004 11:51 pm Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
technically there are many ways to get from Oracle to MQ and back.
Most 'problems' I have seen is the difference with authorisations.
Oracle userids are not native OS userids like on UNIX and some solutions provide access to resources outside Oracle by using the external procedure listener.
This process runs under it's own OS account and that account needs to be authorised for access to MQ, if you have more then 1 application on the same box using this external procedure listener you have a security problem as both applications are granted access to the listener in Oracle and thus can access each others MQ resources...
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| DKG |
| Posted: Wed Aug 31, 2005 10:17 am Post subject: |
|
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
I have an Oracle 9i database and I need to use MQ Series.
Most of the messages will be generated by the database and not the application.
I've been told to install an MQ Client, to create Java Stored Procedures and to use JMS to connect Java SPs with MQ, is that so?
Anybody has a better advice?
Thanks!
German. |
|
| Back to top |
|
|
| JT |
| Posted: Wed Aug 31, 2005 11:24 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
| DKG |
| Posted: Wed Aug 31, 2005 11:42 am Post subject: |
|
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
I don't want to abuse of you kindness but I've been researching a lot, since there're so many possibilities I was really lost, do you know where can I find some examples about connecting JMS with MQ client?
The thing about Messaging Gateway is that I would be adding another Queue Manager (AQ) to the whole picture, that might not be the best.
Thanks in advance! |
|
| Back to top |
|
|
| SAFraser |
| Posted: Thu Sep 01, 2005 1:26 pm Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
We have had good experience using the Messaging Gateway for messages outbound (from Oracle to MQ). We have it deployed in about 25 environments, although none of them have very high traffic.
The AQ is administered by the DBAs. To us (MQ), the Messaging Gateway just looks like another client connection. Our MQ queue managers are remote from the database server.
Shirley |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Sep 01, 2005 7:35 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
We live on the Oracle DB server and use the Messaging Gateway for inbound/outbound traffic.
No major problems but for some version sensitivities (ORA 9i <==> MQ 5.3 CSD 06)...
The messages are moving from MQ to AQ and AQ to MQ seemlessly.
Enjoy  |
|
| Back to top |
|
|
| DKG |
| Posted: Fri Sep 02, 2005 5:23 am Post subject: |
|
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
Thanks all for your replies!
So, bottomline... nobody is using Java Stored Procs and JMS???   |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Sep 02, 2005 5:44 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| DKG wrote: |
Thanks all for your replies!
So, bottomline... nobody is using Java Stored Procs and JMS??? |
I'm sure a number of people are. And some of them are probably using JMS to talk to AO, and some of them are using JMS to talk to MQ, and some of them are using JMS to talk to AO or MQ via a bridge...
JMS is an API, it's not a messaging server and you can't use it without one somewhere.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| DKG |
| Posted: Fri Sep 02, 2005 5:49 am Post subject: |
|
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
| jefflowrey wrote: |
| DKG wrote: |
Thanks all for your replies!
So, bottomline... nobody is using Java Stored Procs and JMS??? |
I'm sure a number of people are. And some of them are probably using JMS to talk to AO, and some of them are using JMS to talk to MQ, and some of them are using JMS to talk to AO or MQ via a bridge...
JMS is an API, it's not a messaging server and you can't use it without one somewhere. |
Yes, I omitted the word MQ Series, that is a MUST use for us, I'm just talking about the interface to connect Oracle DB with it. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Sep 02, 2005 5:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I guess nobody mentioned Java/JMS/J2EE since JohnJeff said "writing c code".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| DKG |
| Posted: Wed Aug 16, 2006 7:54 am Post subject: Loading MQ libraries into Oracle Database |
|
|
Newbie
Joined: 31 Aug 2005
Posts: 7
Location: Buenos Aires, ARG
|
Well, after all this time, I started working on this.
I've first tried putting and getting messages from an MQ Client (connecting to a server), based on mq.jms package, creating a factory for the connection.
Everything works smoothly from Java.
The second step I took was try to upload the MQ jar files into the database.
The database has JRE 1.3.1, and its corresponding rt.jar file.
I'm using 5.3 libraries (also tried with 6.0) on a windows environment.
It seems that besides the libraries provided by MQ it also needs jaas.jar and jsse.jar, but I'm still having problems of missing libraries:
java/security/cert/CertStore
java/security/cert/X509CRLSelector
javax/security/auth/x500/X500Principal
java/security/cert/CertStoreException
java/security/cert/LDAPCertStoreParameters
java/security/cert/CRLSelector
java/security/cert/CertStoreParameters
But those libraries are on JRE 1.4.
So, why MQ 5.3 says it works under JRE 1.3??
Am I missing something???
Is there any documentation containing this libraries dependence?
I read "WebSphere MQ Using Java" and "WebSphere MQ Application Programming Guide" and besides MQ libraries it says nothing more.
Any help or tip would be very appreciate it!
Thanks in advance!
Germán. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 16, 2006 2:39 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well if you are using an APPServer features and not plain old JMS you will need JAAS and JSSE and JCE and all that stuff. For java 3.1 JSSE and JCE are extensions. You need to download them extra.
But for just a stored procedure why do you bother with all the appserver stuff ?? Is your connection encrypted? Do you work with X501 certs?
Enjoy
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
