Hi,
I have retested with the Oracle11Platform -> OK.
Still, I would appreciate if someone could double-check the proposed patch:
https://bugs.eclipse.org/bugs/attachment.cgi?id=190269
Thanks,
Adrian
From: Kevin Yuan [mailto:kevin.yuan@xxxxxxxxxx]
Sent: Donnerstag, 3. März 2011 20:44
To: Goerler, Adrian
Cc: PETER.KROGH@xxxxxxxxxx; O'BRIEN,MICHAEL
Subject: Re: bug 338783 - delete query fails with optimistic lock exception if JDBC batching is enabled on Oracle
Hi Adrian,
In our nightly testing, we hit this problem when we test on Oracle 11.1.0.7 DB, so this issue should at least occurred on org.eclipse.persistence.platform.database.oracle.Oracle11Platform as well. Would you mind to check it on Oracle11Platform?
Thanks,
Kevin
On 03/03/2011 9:01 AM, Goerler, Adrian wrote:
please find attached a proposed patch for this issue. This issue occurred on Oracle when running the WDF test after I had enabled JDBC-batching in the tests. The issue did not occur with the OraclePlatform but I could reproduce it with the Oracle10Platform.
The proposed patch adjust execution of no-prepared (heterogeneous) statement batches on Oracle 10 if (non-native) JDBC batching is enabled.
As my knowledge of the Oracle-platform is very limited, I would appreciate if someone with better knowledge could double-check the patch.