Hi Steve,
Since my last response I have gone back to the drawing board to
re-evaluate and test the proposed change. In brief the change does
inline the sql in the current transaction and uses pessimistic locking.
This is a change to the initial ideas suggested. Reasons for that are
later in t
On 12/08/13 02:51, Steve Ebersole wrote:
> First, you lump sequences and table-based sequence together here, but I
> assure you sequences (real database sequences) are read inline with the
> current transaction. In the case of a real sequence, the database
> already handles the isolation of the
First, you lump sequences and table-based sequence together here, but I
assure you sequences (real database sequences) are read inline with the
current transaction. In the case of a real sequence, the database
already handles the isolation of the generated values outside
transactional context.
On 9 August 2013 19:08, Jeremy Whiting wrote:
> Hi Scott,
> To the database the sequence of statements will be as follows. The
> statements around the read and write of sequence table are an example to
> put the sequence_table work into context.
>
> tx1 BEGIN
> SELECT blah
> SELECT blah
>
Hi Scott,
To the database the sequence of statements will be as follows. The
statements around the read and write of sequence table are an example to
put the sequence_table work into context.
tx1 BEGIN
SELECT blah
SELECT blah
UPDATE blah
SELECT * from sequence_table;
UPDATE sequence_table
On 08/08/2013 11:21 AM, Jeremy Whiting wrote:
> Hi,
>I am looking for feedback on changes to provide the ability for work
> to be completed in a currently running transaction. For example when a
> TableGenerator or SequenceGenerator is being used for generating unique
> ids. The statements that
Hi,
I am looking for feedback on changes to provide the ability for work
to be completed in a currently running transaction. For example when a
TableGenerator or SequenceGenerator is being used for generating unique
ids. The statements that select then update the db are executed in a
separate
