Subject | Re: [Firebird-Java] DataExpress problem JayBird 3 Beta |
---|---|
Author | |
Post date | 2016-12-22T15:32:39Z |
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
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