Subject Re: Built in pooling added to jca-jdbc driver
Author jwcanada

Thank you. As the transaction problems, I could not further test it.
How to start a transaction on a connection?


--- In IB-Java@y..., David Jencks <davidjencks@d...> wrote:
After a good deal of study I find that on my machine the problem was
different formats for database urls for the Driver and the DataSource.

Driver url looks like:


DataSource url looks like:


Due to the internal connection swapping to allow the appearance of xa
transactions, you don't actually open the first connection to the db
you try to start a transaction on a connection. Therefore you get some
extremely confusing messages about transaction problems when really,
couldn't even get to the db.

Thanks for pointing this out!

Let me know if you have other problems with it.

david jencks

On 2002.01.06 15:24:12 -0500 jwcanada wrote:
> David,
> Thank you for writting the database pooling. I am able to compile
> and abtainning the pooled connection. However, when I use it, it
> me the following message as soon as I executeQuery("select MyMemo
> from Mytable":
> java.sql.SQLException: ResourceException:
> javax.resource.ResourceException: couldn't start local transaction:
> javax.transaction.xa.XAException:
> at org.firebirdsql.jdbc.FBStatement.executeQuery
> (
> This error happens even though I setAutocommit false.
> Your help would be greatly appreciated.
> jw