db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: RowLocation lifetime
Date Thu, 10 Nov 2005 01:11:34 GMT
Assuming row is not deleted, the question can only be answered
knowing the isolation level.  Basically the RowLocation can only
be counted on while a lock intent level lock is held on the table.
Intent table locks may be released as soon as a statement is
completed, or may be held to end of transaction depending on
the type of statement and type of isolation level.

The thing that may move an existing row in a heap are the compress
table system procedures.

If a row is deleted then there are other factors.

Rick Hillegas wrote:
> Hello Store experts,
> How long is a RowLocation in a Heap good for? Provided that the row is 
> not deleted, can you count on its RowLocation reliably identifying the 
> row for the duration of a Statement, a Transaction, a Connection? Forever?
> Thanks,
> -Rick

View raw message