Subject Re: FireBird lock problem
Author nrajagopal35
Actually the synchronized block is in the driver's code of
executeUpdate method. This doesn't return while some other query from
other thread want to do one more executeUpdate



--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:
> > While doing a executeUpdate of some query, the Driver locks the db
> > handle in a synchronized block. At the same time say u want to execute
> > some other query, then the second executeQuery waits for the
> > connection's statement locked by the previous one, then it waits for
> > ever because the locked connection by the previous query doesn't
> > return.
>
> Do you run multiple threads? If yes, why your previous query does not
> return? synchronized() block will be left sooner or later unless
> there's endless loop inside (which isn't, since it works in normal
case).
>
> > This happening so frequently. Kindly pour me some light over this.
>
> Please, post your code here, it is hard to suggest something without it.
>
> Roman