| Author |
Message
|
| mac1929 |
 Posted: Tue Nov 26, 2002 6:44 am Post subject: Two phase commit transacction between JMS and JDBC |
 |
|
Novice
Joined: 15 Oct 2002
Posts: 10
|
We are building a Java broker. Some listeners take messages from different queues, update some database tables and send messages to other queues.
For this purpose we are using JMS over MQSeries and JDBC over Oracle.
Two phase commit transactions should not be a problem in this screnario. It shoud be enough to registrer a XAQueueConenectionFactory and a XADatasource in Name Server.
But the problem is: how can I use JTA transaccions and JMS listeners simultaneously. How do I create a session and a listener for this session under the scope of JTA? Has anybody got an example to do it? |
|
| Back to top |
|
 |
| manojgusa |
| Posted: Fri Dec 13, 2002 3:43 pm Post subject: |
|
|
Newbie
Joined: 13 Dec 2002
Posts: 3
|
| I am having the same problem....did you find some solution for this problem......I am also looking for a solution....If you find this please put it in the forum and if I find it I will put it in the forum so that others can be beniffed by this...... |
|
| Back to top |
|
|
| kingdon |
| Posted: Sat Dec 14, 2002 1:19 am Post subject: |
|
|
Acolyte
Joined: 14 Jan 2002
Posts: 63
Location: UK
|
Hi,
MQJMS and JDBC2 drivers both provide JTA compliant interfaces. To coordinate between them you need a JTA transaction coordinator. The most obvious place to find one of those is an a J2EE application server, so the simplest (and recommended) route to achieve what you want to is to write your application as a J2EE application and run it in WebSphere.
Regards,
James. |
|
| Back to top |
|
|
| manojgusa |
| Posted: Sat Dec 14, 2002 11:48 am Post subject: |
|
|
Newbie
Joined: 13 Dec 2002
Posts: 3
|
I agree with you on that and that what we are doing right now.But I have a following questions for you
In am using MQ Series 5.2, Websphere 4.0.4, Aix 5.2 to run JMS applications.My Production environment will have two boxes having two MQ Managers and two Websphere instances .We dont have a LDAP servers.Is it necessary for us to to LDAP servers to look into JMS resources like Destinations,Connection factory or we are fine without using LDAP.Can you please explain how will be be able to find out to which one out of the two MQ manager it has to connect.We are also using 2PC in this environment.
Please let me know in the above infrastructure whether this is possible. |
|
| Back to top |
|
|
| udaybho |
| Posted: Mon Dec 16, 2002 7:33 am Post subject: |
|
|
Voyager
Joined: 09 May 2002
Posts: 94
Location: Chicago
|
James, You cannot use JMS (MA88 suppoer pack) as a part of Global transaction with Websphere 4.0. You have to use Websphere 5.0 only.
Uday Bhosle |
|
| Back to top |
|
|
| kingdon |
| Posted: Mon Dec 16, 2002 7:44 am Post subject: |
|
|
Acolyte
Joined: 14 Jan 2002
Posts: 63
Location: UK
|
Hello Uday,
I believe you are mistaken. I did the first work to allow JMS to participate in a global transaction with WAS 3.5. It certainly works with 4, although I would agree that WAS 5.0 takes the JMS integration to a new level.
Unless you know of platform specific problems which I'm not aware of?
Kind regards,
James. |
|
| Back to top |
|
|
| udaybho |
| Posted: Mon Dec 16, 2002 8:28 am Post subject: |
|
|
Voyager
Joined: 09 May 2002
Posts: 94
Location: Chicago
|
James, I had a requirement where I have to use JMS(MA88 support pack + MQ 5.2) as a part of Global transaction and IBM rep told us not to use it, as there are some issues involved with it( I did not paid attention which issues..my fault) .
Now I surprised to hear from you that it works for you. Thanks for your feedback. My apologies.
Uday Bhosle |
|
| Back to top |
|
|
|
|
