Atomikos Forum

Hello,

First of all, I have to say that I am extremely happy with Atomikos :)

Suppose I setup the XA over multiple PostgreSQL instances. Is there a way to tell the AtomikosDataSourceBean what to do in case that one of the Db instances dies? For example, C3P0 has a property "breakAfterAcquireFailure" which specifies just that. I have several complex scenarios and in some I would like the Pool to fail along with the affected Db instance and in some other cases I'd prefer the Pool to try to recover i.e. keep retrying to connect. How can I specify this with Atomikos?

I also checked the propeties available through org.postgresql.xa.PGXADataSource and could not find any that would tackle this.

Many thanks in advance,
Best regards,
Giovanni

Hi,

If you set a testQuery then the pool will check liveness and refresh if needed. If you don't set a testQuery then the application will get an error when trying to use the connection.

Is that what you are looking for?

HTH