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
Post date 2014-09-04T19:43:38Z
On 4-9-2014 13:53, doychin@... [firebird-support] wrote:
> They all use READ COMMITTED isolation.

Are you using the default read committed config of Jaybird, or have you
overridden it? Default is
isc_tpb_read_committed,isc_tpb_rec_version,isc_tpb_write,isc_tpb_wait

> It is an application that runs in JBoss App server so I have single
> datasource defined that uses READ COMMITTED.
>
> Blocked statements are insert and update. Selects are not blocked.

Is the background process also running on JBoss and using read committed?

Mark
--
Mark Rotteveel