SQL databases won't return any data that was created without the RETURNING
clause. Also, if you read the original post, you'd see the RETURNING
clause gets appended and does just fine when not in batch mode.
But that all said, individual SQL execute() statements are fine for the
near future. I'll worry about performance when we've got a million
customers.
On 3/19/11 2:46 AM, "Oliver Jowett" <oliver(at)opencloud(dot)com> wrote:
>There *is* no RETURNING clause in the application's original query
>(see the code in the OP), that clause is being added by the driver to
>implement Statement.RETURN_GENERATED_KEYS.