-
1. Re: XA Resource Survey
lazan Oct 6, 2009 7:15 AM (in response to tomjenkinson)Hi Tom.
We are using DB2 with Tuxedo now, and I'm sure we're not going to switch to another database engine.
I'm not sure it's possible for you to use/test against without a licence though.
Regards
/Fredrik -
2. Re: XA Resource Survey
tomjenkinson Oct 6, 2009 5:15 PM (in response to tomjenkinson)Hi Frederik,
Thanks for the feedback! I will take a look and see what the licensing implications of us testing with DB2 are...
Much appreciated,
Tom -
3. Re: XA Resource Survey
tomjenkinson Dec 15, 2009 2:47 AM (in response to lazan)Hi Frederik,
Just so you know, we are currently working on providing an example of integrating BlackTie with the DB2 XA driver.
Thanks for your patience!
Tom
-
4. Re: XA Resource Survey
weberjava Jan 25, 2010 11:35 AM (in response to tomjenkinson)I hope, it's OK to post to the old thread.
IBM - DB2 Express-C and PostgresQL (not sure, if they support XA) would be nice.
Juergen
-
5. Re: XA Resource Survey
tomjenkinson Jan 25, 2010 12:38 PM (in response to weberjava)Hi Juergen,
Its totally fine to post to this old thread! We will hopefully be imminently about to announce something on the support for DB2 front However, we will have to get back to you on the Postgres support as the last time I looked I couldn't see support for XA via C in the DB. Do you currently use Postgres in your XATMI applications?
Tom
-
6. Re: XA Resource Survey
weberjava Jan 26, 2010 5:38 AM (in response to tomjenkinson)Tom, actually we haven't a finished XATMI application yet. We just have a low priority research project going. As for PostgresQL, I thought it would be suiting, if an open source TX monitor would support the last remaining true open source database, you might even package PostgresQL with Blacktie and base ready-to-run samples on it, same as there is Derby included with Java and some Java appservers.
Greetings, Juergen
-
7. Re: XA Resource Survey
tomjenkinson Jan 26, 2010 5:47 AM (in response to weberjava)Hi Juergen,
Thanks for the tip! We did used to have support for Berkeley DB to have a database with an open source friendly licence, unfortunately the XA support for this DB was removed by Oracle mid-late last year
Tom
-
8. Re: XA Resource Survey
mmusgrov Jan 26, 2010 6:05 AM (in response to weberjava)weberjava wrote:
As for PostgresQL, I thought it would be suiting, if an open source TX monitor would support the last remaining true open source database, you might even package PostgresQL with Blacktie and base ready-to-run samples on it, same as there is Derby included with Java and some Java appservers.
We are not aware of any open source database products which include a C API for XA transactions. We have checked MySQL, Postgresql and BerkelyDB which all support XA via JDBC but there is no C API. We have not investigated Ingress. Consequently we have only provided examples using Oracle and DB2 both of which provide free versions but they aren't open source so we cannot bundle them with the BlackTie distribution.
-
9. Blacktie and PostgresQL - the perfect match
weberjava Jan 26, 2010 7:00 AM (in response to mmusgrov)Might be that there was no need for an XA C API for PostgresQL. Organisations who could afford Tuxedo probably went for some expensive commercial database, too. Up to now the only open source tx monitors were Java based (JBoss comes to mind), this explains the existence of XA Java API for PostgresQL and the lack of a C one.
But now with the advent of Blacktie things change. I think Blacktie and PostgresQL would complement each other perfectly. One would only have to address the development of a C XA API for PostgresQL ...
Maybe the Blacktie project could talk to the PostgresQL project.
Juergen
-
10. Re: Blacktie and PostgresQL - the perfect match
tomjenkinson Jan 26, 2010 7:04 AM (in response to weberjava)Thanks for the feedback Juegen, we are more than happy to work with the Postgres guys if they would like to add XA to their C APIs. I have added a task for this in our Jira so we can track it here: https://jira.jboss.org/jira/browse/BLACKTIE-264
Tom
-
11. Re: XA Resource Survey
mmusgrov Jan 29, 2010 6:46 AM (in response to lazan)lazan wrote:
Hi Tom.
We are using DB2 with Tuxedo now, and I'm sure we're not going to switch to another database engine.
I'm not sure it's possible for you to use/test against without a licence though.There is DB2 support in trunk which will be available when MR2 releases (which is next week I believe). I have updated the README in the examples/xatmi/txfooapp directory to explain how to run the example with the supported databases (ORACLE and DB2).
We cannot ship DB2 due to licence restrictions so you'll need to download that separately.
-
12. Re: XA Resource Survey
tomjenkinson Feb 3, 2010 1:11 PM (in response to lazan)Hi,
Just to let you know that BlackTie 2.0 MR2 has now released, thanks to some sterling work by the team, this includes support for DB2 XA being driven by BlackTie. Our support for DB2 extends to recovery for the db as well in case of failure.
Hope you like it!
Tom