Re: [cinjug-users] Request for help: Intermittent bug in Struts app

[Troy Davis <troy@xxxxxxxxxxxxxxxxxx>]

Thank you for replying, but there's no evidence of any other statements 
failing, just the insertion of the article order data. I also turned on 
query logging on the server and inspected the logs the last three times 
this happened, there was no insert statements for the order data after 
each bug report. However, there were plenty of similar transactions 
before and after that happened successfully, including the insertion of 
ordering data.

The other thing that confuses me is that it's not reproducible. It 
happens much less often than 1 in 10 times, probably 1 in 50 or 1 in 
100.

Thank You,
Troy

On Dec 29, 2004, at 3:58 PM, Jason Kretzer wrote:
> Have you tried executing a 'Commit' to the database
> before and after the insert?  I know DB2 has this
> problem even when autocommit is set to true.
>
> -Jason