2 Replies Latest reply on Aug 4, 2003 2:03 AM by Noel Rocher

    PostgreSQL XA config (jboss3.2.1)

    Noel Rocher Apprentice

      Hi all,

      Is there someone with a working postgres-xa-ds.xml ?



        • 1. Re: PostgreSQL XA config (jboss3.2.1)
          Shane Newbie

          Don't know if this is of any use to you but we have a working mssql-xa-ds.xml.

          You don't say what problems ~you're~ experiencing but for us it required the installation of additional stored procedures and a DLL file on the SQL Server to get it working. Both of these came with the latest drivers from MS.

          My guess it the PostgreSQL server may also require the same if you haven't already done so.

          Would be interested to know once you do get it working whether you notice a drop in performance. We've notice transactions times taking 3-4 times as long.


          • 2. Re: PostgreSQL XA config (jboss3.2.1)
            Noel Rocher Apprentice


            It seems thet XA drivers doesn't exists for PostgreSQL.


            Read Aaron Mulder's comment in sources of jdbc driver in web cvs (thanks to Jon Barnett).