HyperSQL (HSQLDB) explicit shared (read) lock syntax
Mihalcea Vlad <[email protected]> Fri, 30 Jan 2015 08:02:38 +0000 (UTC)
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <[email protected]> |
Hi, According to HSQLDB documentation, there are two select-for-updating directives: - FOR UPDATE - FOR READ ONLY "If the SQL qualifier, FOR UPDATE is used, then all the updatable columns of the result set become updatable. If a cursor is declared with FOR READ ONLY, then it is not updatable. In HSQLDB, if FOR READ ONLY or FOR UPDATE is not used then all the updatable columns of the result set become updatable. This relaxes the SQL standard rule that in this case limits updatability to only simply updatable SELECT statements (where all columns are updatable)." If the FOR UPDATE takes an exclusive (write) lock, does the FOR READ ONLY directive take a shared (read) lock instead? Vlad Mihalcea ------------------------------------------------------------------------------ Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user