Subject | Re: FireBird lock problem |
---|---|
Author | nrajagopal35 |
Post date | 2003-12-03T11:18:20Z |
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:
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 dbcase).
> > 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
>
> > 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