Subject | Re: [Firebird-Java] DataExpress problem |
---|---|
Author | Mark Rotteveel |
Post date | 2016-10-17T08:02:49Z |
(note that I'm replying to my own message, because I somehow managed to
delete your message this morning)
hard, that is one of the reasons I have deprecated the
org.firebirdsql.pool package in Jaybird 2.2 and removed it in 3.0.
at the same time. At least, it sounds like that is what is happening
right now, and if you can't avoid doing that, it would be better to
upgrade to 2.2.11 because of JDBC-435
(http://tracker.firebirdsql.org/browse/JDBC-435).
--
Mark Rotteveel
delete your message this morning)
> I'm not using Jaybird Pooling but built my own simple based onIn my experience building a connection pool to function correctly is
> BlockingQueue.
hard, that is one of the reasons I have deprecated the
org.firebirdsql.pool package in Jaybird 2.2 and removed it in 3.0.
> The damn DataExpress library make a lot of stuff behind the scenesYou should avoid having the same connection used from multiple threads
> that is out of the control. By inspecting the Database class source
> code I found that by default it creates transactions which does not
> cope well with Jaybird when called from several threads. I disabled
> the transaction on the Database object and the problem went away.
at the same time. At least, it sounds like that is what is happening
right now, and if you can't avoid doing that, it would be better to
upgrade to 2.2.11 because of JDBC-435
(http://tracker.firebirdsql.org/browse/JDBC-435).
> In time we will update to later version of Jaybird and migrate awayMark
> from DataExpress. The problem is that we have several hundreds of
> installations.
--
Mark Rotteveel