"3rdshiftcoder" <go@away.com> writes:

> hi-
>
> i put a unique index on a derby table.
> it causes an sql error to be thrown .
> A lock could not be obtained within the time requested
> the gui acts unresponsive like it is trying...trying...trying
> and then gives up and becomes repsonsive again.
>
> i dont understand why my code hangs here.
> i am using a prepared statement with an
> insert statement and executeUpdate().
>
> any reason or hints why this is happening would be really cool.
> what i am (trying) to do is hook my jface swt listviewer
> control to the db. i try to trap the error and make it so
> if the value in the listviewer is already present, do not
> add it to the listviewer a second time because of the unique index.

If you have the time, it would be really good of you could report this
problem to derby-user@db.apache.org
Not many derby people follow this newsgroup, I'm afraid.

What you describe sounds like a bug, but it is hard to say without
seeing actual code and stack traces.

--
dt