Hi Adam,

--- Adam <s3057043@...> wrote:

(snip)

> Firebird doesn't use locks the way many other databases use locks.
>
> I am guessing you are using a WAIT transaction.

Yes, I uses default(WAIT) transaction.
In this case, I decide to use NOWAIT transaction to avoid this problem.
# Changing KEEP_ALIVE setting will affect all application under the PC.

Thank you for your advice.

> >
> > In this case, the only solution is restart Firebird?
>
> Not true. The Operating System will eventually tell Firebird the
> connection is broken. By default on Windows and Linux, this takes 2
> hours. After that time, your second query will succeed. Look in
> Firebird.conf for the information about this timeout and how to reduce it.

(snip)

KIMURA, Meiji(FAMILY, Given)
Tokyo, JAPAN