Subject Unable to initialize default LockSQL error
Author Riho-Rene Ellermaa
I get this error in my IBO4 query. Never seen it before.

SELECT id,(select account from account a where a.id=for_pay.accid) as
accountno
, ACCID
, STATUS
, BINFO
, BTAX
, IBANK
, IACCOUNT
, CREF
, CBANK
, BBANKNAME
, IBANKNAME
, CBANKNAME
FROM account
join for_pay on account.id=for_pay.accid
where uid=:UID and install=:INST
for update

Pessimistic locking is checked (it was automatically on). I have
automatically defined UpdateSQL sentences for for_pay table.
Any reasons?


Riho-Rene Ellermaa
senior programmer
Hansabank