Subject Re: [Firebird-Java] jms and connections problem
Author Roman Rokytskyy
> One thing that puzzles me about your -ds configuration is that you are
> using PooledConnectionDatasource as an XADatasource. I haven't kept up
> with exactly what Roman has implemented, but I would expect a pooled
> datasource not to implement xa.

XAConnection interface extends PooledConnection interface. For me that was
natural to let the implementation of ConnectionPoolDataSource to provide
also XA features. If you have good arguments against it, I will be happy to
listen.

But currently FBConnectionPoolDataSource implements ConnectionPoolDataSource
and XADataSource interfaces and is a factory of FBPooledConnection instances
implementing PooledConnection and XAConnection interfaces. However my only
reason to implement this way was to provide XADataSource implementation,
since XA features are provided directly by JCA code for a long time as David
suggests.

> As a side comment, firebird doesn't implement dirty read, so "read
> uncommitted" is not going to give you what you ask for. I think you
> get "read committed".

Correct. The lowest isolation level is read committed, when you specify
"read uncommitted" isolation level is promoted to "read committed".

Roman