Re: WARNING: if you ever want Oracle serializable transactions to be safe

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 18 Jan 2000 20:27:38 -0000
Message-ID: <948227422.11664.0.nnrp-09.9e984b29@news.demon.co.uk>

A truly wonderful feature of this bug is that it doesn't show up when I search metalink (UK mirror) using the key word SERIALIZABLE, or
even when I request bug no. 440317 directly.

Wouldn't it be nice if some of the more serious bugs were put on the system before they were fixed so that we could find out about them before we hit them.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Joseph Weinstein wrote in message <3883BA58.C6DC5080_at_weblogic.com>...
>
>Hi. I have verified with Oracle that there is a longstanding bug in the
Oracle
>DBMS, which may cause transactions with SERIALIZABLE isolation level
>to silently fail. This affects EJBs as well as any other transactional
client.
>
>The bug arises in transactions where a given row is inserted then updated
>within a single transaction. The update may silently fail. This is a common
>EJB scenario.
Received on Tue Jan 18 2000 - 14:27:38 CST