Subject Re: [Firebird-Java] DataExpress problem JayBird 3 Beta
Author
Hi,

Let me first clarify that I never share a single connection between threads.
I have a pool with Database object that is used for each thread. Each Database instance create a new jdbc connection.

Here I try to explain what setPool Does:

//Take a Database object from pool
Database db = dbPool.getConn();

//Get Database object from QueryDataSet to be executed
Database qdsDb = queryDataSet.getQuery().getDatabase();

//Put jdbc connection to the DataBase object belonging to QueryDataSet from pool Database object.
//here Database calls getAutocommit() which can throw throw exception
qdsDb.setJdbcConnection(db.getJdbcConnection());

execute queryDataSet

return Database to pool.

I have noted that the version 2.12 and Beta 2 is actually more stable, so you did some improvement.

Hugo