David,

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

jw

--- 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:

jdbc:firebirdsql:localhost/3050:/usr/local/firebird/dev/client-
java/db/fbmctest.\
gdb

DataSource url looks like:

localhost/3050:/usr/local/firebird/dev/client-java/db/fbmctest.gdb

Due to the internal connection swapping to allow the appearance of xa
transactions, you don't actually open the first connection to the db
until
you try to start a transaction on a connection. Therefore you get some
extremely confusing messages about transaction problems when really,
you
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
it
> and abtainning the pooled connection. However, when I use it, it
gave
> 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
> (FBStatement.java:110)
>
> This error happens even though I setAutocommit false.
>
> Your help would be greatly appreciated.
>
> jw