My understanding of firebird is that it's a fraction of the entire interbase
product missing many important features and tools. (though it has XA
support?)
On another note, I agree that Postgres is the only other open source
database with XA support. I spent a bunch of time poking around open source
databases and even my current favorite Sap DB doesn't do XA.
I am pretty sure that Postgres has a JDBC 2.0 XA enabled driver, but I don't
think it's stable enough to be in the standard distribution.
Cheers
-----Original Message-----
From: David Jencks
To: [EMAIL PROTECTED]
Sent: 6/27/01 8:05 PM
Subject: Re: Isolation Levels was RE: [JBoss-dev] CVS update:
jboss/src/main/org/jboss/ejb/plugins/jaws/jdbc JDBCCommand.java
Hi,
Thank you for the quote.
<quote snipped>
> By the way, does anyone know what is the best free
> database that supports XA (w/jdbc driver)? (I love
> postgres, but the jdbc driver doesn't have XA support
> (among other things), I don't even know if postgres
> the database has it). Is interbase (the free and
> gratis version) it?
>
Interbase has supported 2pc since the 80's, in fact may have been the
first
db to support it (they also invented blobs, original meaning as in "blob
that ate cincinnatti", binary large object was a marketers invention).
The
semantics are a little different from what xa likes, but this can be
worked
around.
Interclient from borland or firebird does not support xa, and suffers
from
ridiculous architecture. It is not worth trying to add xa to it, imho.
I am working on a pure java jca/jdbc-like resource adapter for firebird
dialect 3 databases that does support xa. According to my unit tests,
the
xa stuff works fine except for recovery ( not yet implemented) and
queries
seem to work fine. I'm about to see if I can package it up as a rar and
use it with jboss.
david jencks
> Hope this helps to the discussion on Isolation levels,
>
>
> Thanks, CC
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-development
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
