=== SQL Exception 1 === SQLState=HY000 ErrorCode=-210015 [JDBC Progress Driver]:Fail

[Damanindahaus]

hi folks,

i need your help. i get this exception querying to a progress 9.1d db.


=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210015
[JDBC Progress Driver]:Failure getting record lock on a record from table PUB.zimmer.

need some help.

what to do?

regards

 

[Cringer]

Re: === SQL Exception 1 === SQLState=HY000 ErrorCode=-210015 [JDBC Progress Driver]:F

What is your sql statement?

 

[Damanindahaus]

Re: === SQL Exception 1 === SQLState=HY000 ErrorCode=-210015 [JDBC Progress Driver]:F

select * from pub.zimmer

 

[Marian EDU]

Re: === SQL Exception 1 === SQLState=HY000 ErrorCode=-210015 [JDBC Progress Driver]:F

you need to change the transaction isolation-level, someone is holding some records from that table locked in a transaction...

http://www.progresstalk.com/showthr...ot-JDBC-connection.&highlight=isolation+level