-
1. Re: Is JBossTS required for coordinated transactions?
vickyk Nov 3, 2008 11:06 PM (in response to weinfie)"weinfie" wrote:
I want to coordinate transactions between a database and IBM MQSeries.
Can I do this with JB 4.2.3 or do I need to install JBossTS as an add-on?
You should be able to coordinate the transaction using Jboss server, it had embedded arjuna(jbossts) Transaction Manager. -
2. Re: Is JBossTS required for coordinated transactions?
weinfie Nov 3, 2008 11:10 PM (in response to weinfie)Thanks. I am asking the question because we are seeing errors in our coord. trx. Perhaps I am missing something in my db2-ds.xml. Are there special keywords that indicate an xa transaction?
-
3. Re: Is JBossTS required for coordinated transactions?
vickyk Nov 3, 2008 11:14 PM (in response to weinfie)"weinfie" wrote:
Thanks. I am asking the question because we are seeing errors in our coord. trx. Perhaps I am missing something in my db2-ds.xml. Are there special keywords that indicate an xa transaction?
You need to configure the xa-datasource type for the xa transaction.
What are the errors that you see for the xa transaction ? -
4. Re: Is JBossTS required for coordinated transactions?
weinfie Nov 4, 2008 8:54 AM (in response to weinfie)Error msg is "Adding multiple last resources is disallowed"
Looks like the problem is that we are using the wrong deploy descriptor. The standard db2-ds.xml does not have a "xa-transaction" stanza. -
5. Re: Is JBossTS required for coordinated transactions?
vickyk Nov 4, 2008 9:07 AM (in response to weinfie)"weinfie" wrote:
Error msg is "Adding multiple last resources is disallowed"
Looks like the problem is that we are using the wrong deploy descriptor. The standard db2-ds.xml does not have a "xa-transaction" stanza.
Read this
http://www.jboss.org/wiki/Wiki.jsp?page=Multiple1PC
These forum entries must be helpful in configuring xa datasource for db2
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4129694#4129694
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4101927#4101927
For datasource related posts move to the jca forums and try some google searches also , google is your friend ;) -
6. Re: Is JBossTS required for coordinated transactions?
weinfie Nov 4, 2008 9:56 AM (in response to weinfie)Actually, the intent was to use 2 different resource managers (DB2 and MQ) in a 2-phase XA transaction. I think there are 2 problems: (1) the developer is not creating a xa DB2 connection [I need to confirm] and (2) we need to use the "xa" type descriptor.
I tried #2 before consulting with the developer's code and now I see:
Throwable while attempting to get a null connection . . .
Could not find accessor on XADataSource . . .