Atomikos Forum

Hi
I'm a newbie in trensaction mngt, and I'm evaluating your technology. I have one question about your connection pooling mechanism. Is it possible to plug another pool underneath without losing the transaction management ?
I was under the impression that transaction mngt could be added on top of any datasource impl, so that I could use let's say DBCP to pool - why must I use your pool instead ?
Thanks
      /jog

Hi,

First, you need XA awareness for real transaction support.

Second, there are nasty details such as the fact that a pooled connection must not be reused or closed BEFORE any pending transactions are done using it - and such usage includes two-phase commit (done out-of-band by the transaction manager).

This and other details make it hard (but not impossible) to use other pools. Personally, I don't know any third-party pool that is compatible, although in theory it IS possible.

That being said, what is your problem with our pools?

HTH
Guy

Sorry for the delay - I thought I would get an email notification on replies.

My problem is the following: I need to use a TM with an Oracle connection pool. Your pool is fine, but doesn't provide failover or loadbalancing on top of JDBC, which is necessary. The oracle thindriver supports some sort of failover, but it seems unreliable. WebLogic for ex provides failover and loadbalancing on top of this driver, creating JDBC connections to multiple oracle instances.

So I was wondering if I could simply implement my own JDBC pool, that would have that kind of features on top of the driver, and simply plug it into your code.

From your answer, I guess the simplest way of getting this would be to modify your pool to properly loadbalance connections - right ?

      /jog