P3
Normally, when autocommit(true) has been set for a Connection an INSERT
statement 'commits' immediately upon completion. This, nobody would argue
with; independent of how it is implemented, this is the effect that any
application developer must see.
The Question/Puzzle is: What happens in the same situation when the INSERT
statement is instructed to produce autogenerated keys? As I think you'll see upon consideration, there are *numerous* possible answers to this question, and it would be beneficial for the Standard to be more explicit as to what users should expect to happen.
###@###.### 2004-02-02
statement 'commits' immediately upon completion. This, nobody would argue
with; independent of how it is implemented, this is the effect that any
application developer must see.
The Question/Puzzle is: What happens in the same situation when the INSERT
statement is instructed to produce autogenerated keys? As I think you'll see upon consideration, there are *numerous* possible answers to this question, and it would be beneficial for the Standard to be more explicit as to what users should expect to happen.
###@###.### 2004-02-02