Re: [Hsqldb-developers] isolation supported

[fredt]

Hi Irum,   You have lots of questions all the thime :).    1) This code has not been released. By the time it does, it will allow only some isolation levels. In its current form it does not support more than one level.   2) The locks are on modified rows not predicates. Don't be too concerned if you read something else in your book -- you may or may not be reading it in the right context.   Fred ----- Original Message ----- From: Irum Godil To: hsql Sent: 31 March 2005 06:08 Subject: [Hsqldb-developers] isolation supported Hi, Thanks, I was able to set up the project and get errors in wrong cases. As I am trying to study the isolation supported, I have 2 questions as follows:   1) In the class jdbcConnection, in the method setTransactionIsolation(level), the implementation allows to set any of the 4 Isolation levels. But, does not the system only support READ_UNCOMMITTED level; or does it support any of the 4 levels?   2) Also, when locking on write, I understand that a specific row being updated by a Transaction is locked right? The lock is not on the predicates right? I am concerned because the book I was reading on Transactions said that all Isolation Levels do write locks on predicates; but from my understanding of the implementation only locks are made on the tuples.   Thanks a lot. Sincerely, Irum Godil. Do you Yahoo!? Yahoo! Small Business - Try our new resources site!