Look into the SELECT...FOR UPDATE... clause to read your records. The FOR
UPDATE will lock them for you....
Be carefule using this, since if too many records are locked, your RDBMS
may escalate the record locks to table lock
(you may not need a table lock if the records are not that many....).

Agustin



At 03:30 PM 2/5/2003 +0100, Marco Parmeggiani wrote:

>On Wed, 05 Feb 2003 13:13:06 -0000, you wrote:
>
> >> What is the right way to acquire a table lock using jbird?
> >
> >Why do you need this thing? Is there any reason to do this explicitly
> >and not letting Firebird manage conflicts itself?
> >
>
>[sorry if this is a double post but seems that yahoogroups does not like
>very much my (hardly configured through the "password driven" procedure
>of yahoogroups) secondary mail address and silently refuses it]
>
>I need to update a group of records and while i do that no one should
>read or update that group of record. The granularity of the operation
>should not be at record level but at group of records level. So i'm
>trying to acquire a table lock.
>
>
>ciao
>--
>Seti@Home Java Applets
><http://maruko.cjb.net/>http://maruko.cjb.net/
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.