Subject | FireBird lock problem |
---|---|
Author | nrajagopal35 |
Post date | 2003-12-03T05:48:37Z |
Dear Friends,
I am new to this group. I am using FireBird 1.0.3 for my application
written in Java. I am using JCA jdbc driver FirebirdSQL-1.0.1.zip.
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.
This happening so frequently. Kindly pour me some light over this.
Regards,
Rajagopal N
I am new to this group. I am using FireBird 1.0.3 for my application
written in Java. I am using JCA jdbc driver FirebirdSQL-1.0.1.zip.
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.
This happening so frequently. Kindly pour me some light over this.
Regards,
Rajagopal N