| Subject | Re: [Firebird-checkins] CVS: client-java/src/main/org/firebirdsql/gds GDSException.java,1.5,1.6 ISCConstants.java,1.1,1.2 isc_db_handle.java,1.4,1.5 |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2002-12-14T15:45:44Z |
At 11:00 PM 12/13/2002 -0500, David Jencks wrote:
this one, has compiled a request against the "object" - typically a table
or an index. Because requests are linked to the connection, not to a single
transaction, the object will remain locked until all connections that have
referenced it are closed. So, closing the current connection may or may
not be necessary and may or may not be sufficient. It is not a reason to
discard changes made earlier in the transaction.
Regards,
Ann
www.ibphoenix.com
We have answers.
>I've incorporated these except for the isc_object_in_use. Some problem withThe "object in use" message indicates that some connection, not necessarily
>this was the reason I started doing this in the first place. Trying to
>drop a foreign key constraint produced this error, and the only solution
>seemed to be to successfully (via some fixed) close the original connection
>and open a new one.
this one, has compiled a request against the "object" - typically a table
or an index. Because requests are linked to the connection, not to a single
transaction, the object will remain locked until all connections that have
referenced it are closed. So, closing the current connection may or may
not be necessary and may or may not be sufficient. It is not a reason to
discard changes made earlier in the transaction.
Regards,
Ann
www.ibphoenix.com
We have answers.