I figured it out. I was trying to use a variable in my query string.
while I was researching the problem I came across in the faq
a way to speed up derby. it said use ? for prepared statements.
I have done this ? with other methods and use a variable too.
I didn’t know it would cause that. Now I will know to always
use ? on an update operation.
thanks very much,
From: Jim McNamara [mailto:email@example.com]
Subject: dialog hangs on referntial exception
derby 10.1.3.1 windows
is there some loop trying to commit the sql transaction that causes
a delay? it cause the dialog to become responsive for a little too
long and then returns control eventually and displays my custom
error message to the user.
can someone please give me a quick tip to avoid this?
btw I really like how easy it is to put a column constraint
to handle integrity. I once did it with tcl and sqlite and had to use