Subject Re: [firebird-support] Insert ot update statements locks a table and all other instances that try to run same statement are lcoked to
Author Mark Rotteveel
On 04 Sep 2014 13:31:14 -0700, "doychin@... [firebird-support]"
<> wrote:
> Yes background process is running to on same application server and uses
> same data source.
> I use EJB 2 and CPM for doing database operations.
> App server is 4.2.3 and jaybird is 2.1.6

How have you determined the problem has to do with locked tables (which
takes some effort in Firebird), and not with the connection (or obtaining
the connection from the datasource)? What is your datasource configuration
and which datasource class do you use?