Re: [Firebird] XAResource and TransactionManager with JayBird, LDAP

From: Lee Fesperman (firstsql_at_ix.netcom.com)
Date: 12/15/03

  • Next message: Bjorn Abelli: "Re: PL*SQL stored procedure, oracle objects and Java" 
    Date: Mon, 15 Dec 2003 01:04:24 GMT

    Lukasz Kowalczyk wrote:
    >
    > I need to access (and update) two separate databases within one
    > transaction. One of them is Firebird 1.0, the other is any LDAP
    > database (I know most LDAPs are not transactional, transaction on LDAP
    > side will be emulated).
    >
    > I know I need to implement a transaction manager but in order for this
    > to work I need to retrieve an XAConnection not an ordinary
    > java.sql.Connection from the JDBC driver because I have to invoke
    > Transaction.enlistResource(XAResource).
    >
    > The question is this - how should I use Firebird's JDBC driver
    > (JayBird) to be able to retrieve XAConnection instances?

    If Firebird provides XA through Java, it should have an implementation of
    javax.sql.XADataSource (perhaps, JCA also). XADataSource has getXAConnection() methods. 

    -- 
Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)
  • Next message: Bjorn Abelli: "Re: PL*SQL stored procedure, oracle objects and Java"

    Relevant Pages

    • Re: row vs page locking...
      ... Maybe it's a problem of Interbase marketing - it used to be aimed at dbase / ... concurrency semantics are more tricky to learn than SQL Server. ... Who writes long transaction apps these days?? ... In Interbase / Firebird you can't see other uncommitted records!!! ...
      (microsoft.public.sqlserver.server)
    • [Firebird] XAResource and TransactionManager with JayBird, LDAP
      ... I need to access two separate databases within one ... One of them is Firebird 1.0, the other is any LDAP ... database (I know most LDAPs are not transactional, ... The question is this - how should I use Firebird's JDBC driver ...
      (comp.lang.java.databases)
    • Re: PostgreSQL vs Firebird
      ... > Firebird databases will grow at a huge rate because of the transaction ... > overhead, while this happens in Postgres, they have the vacuum daemon ... Firebird has garbage collector that will do the same, ... The database has grown to 2g right now and it still run at a reasonable ...
      (borland.public.delphi.non-technical)
    • Re: PostgreSQL vs Firebird
      ... > stuck, no matter how hard you try to ensure transactions are commited, ... > Firebird databases will grow at a huge rate because of the transaction ... This is a mute point - if a client crashes, the transaction will be rolled ... > I had one firebird DB grow to 600mb because the automated backup restore ...
      (borland.public.delphi.non-technical)
    • Re: PostgreSQL vs Firebird
      ... This is not true, if a PC crashes while a firebird transaction is open, ... The client does the rollback,not the server and if the client blinks ...
      (borland.public.delphi.non-technical)