Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
Date: Mon, 15 Mar 2010 19:43:07 +0100
Message-ID: <1f5d398f1003151143s35cbced8j4df12331182fe3b@mail.gmail.com>
Subject: how to cascade on update? Not possible?
From: Gabriele Kahlout <gabriele@mysimpatico.com>
To: Derby Discussion <derby-user@db.apache.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello,

I've moved my database from SQLite into Java DB using SQLWrapper.
I expected the references integrity constraint, to cascade on update.
I.e. wColumn in refTable, references expColumn in expTable. Updating
expColumn should update wColumn.
However I get:
java.sql.SQLIntegrityConstraintViolationException: UPDATE on table
'EXPRESSIONS' caused a violation of foreign key constraint
'SQL100315193342610' for key (la testa).  The statement has been
rolled back.

The only reference I found, seems to suggest for UPDATE it's not
possible to cascade. Is that the case?
http://db.apache.org/derby/docs/10.5/ref/

--=20
Regards,
K. Gabriele

--- unchanged since 25/1/10 ---
P.S. Unless a notification (LON), please reply either with an answer
OR with " ACK" appended to this subject within 48 hours. Otherwise, I
might resend.
In(LON, this) =E2=88=A8 In(48h, TimeNow) =E2=88=A8 =E2=88=83x. In(x, MyInbo=
x) =E2=88=A7 IsAnswerTo(x,
this) =E2=88=A8 (In(subject(this), subject(x)) =E2=88=A7 In(ACK, subject(x)=
) =E2=88=A7
=C2=ACIsAnswerTo(x,this)) =E2=87=92 =C2=ACIResend(this).

Also note that correspondence may be received only from specified a
priori senders, or if the subject of this email ends with a code, eg.
-LICHT01X, then also from senders whose reply contains it.
=E2=88=80x. In(x, MyInbox) =E2=87=92 In(senderAddress(x), MySafeSenderList)=
 =E2=88=A8 (=E2=88=83y.
In(y, subject(this) ) =E2=88=A7 In(y,x) =E2=88=A7 isCodeLike(y, -LICHT01X) =
).