Subject Re: Built in pooling added to jca-jdbc driver
Author cabofalso
I was having the same problem. The culprit turned out to be a
malformed db URL. Make sure the db URL has the following format:
private DatabaseAccess _dbAccess =
new DatabaseAccess(
+ "localhost:c:/db/firebird/ortwin/ortwin.gdb"

This was for an interbase database in a win2k box. The important here
1.- There is no delimiter bewteen FBDriver.FIREBIRD_PROTOCOL and the
host name (i.e. "localhost")
2.- There is a ":" delimiter between the host name ("localhost") and
the file name ("c:/db/firebird/ortwin/ortwin.gdb").

I hope this helps.

--- In IB-Java@y..., "jwcanada" <jwcanada@y...> 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