12 Replies Latest reply on Feb 3, 2010 1:11 PM by tomjenkinson

    XA Resource Survey

    tomjenkinson

      Hi BlackTie users,

      We would appreciate knowing which XA Resources people intend to use BlackTie with. Our current testing provides coverage on Oracle 11g and until recently also included Berkeley DB. Unfortunately Oracle have removed the XA Resource Manager from Berkeley and so we have had to discard our code/notes related to Berkeley now:
      http://forums.oracle.com/forums/thread.jspa?threadID=961909&tstart=0
      http://www.oracle.com/technology/documentation/berkeley-db/db/programmer_reference/changelog_4_8.html#id1655895

      If there are any XA resource managers that you think we could be looking at (free or open source would be best!) please let us know via the forum or on the #blacktie freenode IRC room!

      All the best,
      Tom

        • 1. Re: XA Resource Survey
          lazan

          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

            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

              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

                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

                  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

                    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

                      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

                        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

                          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

                            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

                              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

                                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