From derby-user-return-5455-apmail-db-derby-user-archive=db.apache.org@db.apache.org Sun Oct 29 23:58:14 2006 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 81365 invoked from network); 29 Oct 2006 23:58:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Oct 2006 23:58:13 -0000 Received: (qmail 94871 invoked by uid 500); 29 Oct 2006 23:58:19 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 94515 invoked by uid 500); 29 Oct 2006 23:58:19 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 94503 invoked by uid 99); 29 Oct 2006 23:58:19 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 29 Oct 2006 15:58:19 -0800 X-ASF-Spam-Status: No, hits=3.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of 3rdshiftcoder@verizon.net designates 209.73.179.141 as permitted sender) Received: from [209.73.179.141] (HELO smtp103.vzn.mail.dcn.yahoo.com) (209.73.179.141) by apache.org (qpsmtpd/0.29) with SMTP; Sun, 29 Oct 2006 15:58:06 -0800 Received: (qmail 95228 invoked from network); 29 Oct 2006 23:57:39 -0000 Received: from unknown (HELO BEDROOM) (3rdshiftcoder@verizon.net@71.127.178.66 with login) by smtp103.vzn.mail.dcn.yahoo.com with SMTP; 29 Oct 2006 23:57:38 -0000 From: "Jim McNamara" <3rdshiftcoder@verizon.net> To: Subject: re: dialog hangs on referntial exception Date: Sun, 29 Oct 2006 18:57:02 -0500 Message-ID: <000001c6fbb5$ee869e90$2f01a8c0@BEDROOM> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C6FB8C.05B09690" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C6FB8C.05B09690 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit hi- I figured it out. I was trying to use a variable in my query string. while I was researching the problem I came across in the faq a way to speed up derby. it said use ? for prepared statements. I have done this ? with other methods and use a variable too. I didn't know it would cause that. Now I will know to always use ? on an update operation. thanks very much, jim -----Original Message----- From: Jim McNamara [mailto:3rdshiftcoder@verizon.net] Sent: Sunday, October 29, 2006 4:47 PM To: 'derby-user@db.apache.org' Subject: dialog hangs on referntial exception hi- derby 10.1.3.1 windows is there some loop trying to commit the sql transaction that causes a delay? it cause the dialog to become responsive for a little too long and then returns control eventually and displays my custom error message to the user. can someone please give me a quick tip to avoid this? btw I really like how easy it is to put a column constraint to handle integrity. I once did it with tcl and sqlite and had to use triggers. thanks, jim ------=_NextPart_000_0001_01C6FB8C.05B09690 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

hi<= /span>-

 

I figured it out.  I was trying to use a variable = in my query string.

while I was researching the problem I came across in the faq

a way to speed up derby.  it said use ? for prepared statements.

I have done this ? with other methods and use a variable = too.

I didn’t know it would cause = that.  Now I will know to = always

use = ? on an update operation.

 

thanks very much,

jim

 

-----Original Message-----
From: Jim McNamara [mailto:3rdshiftcoder@verizon.net]
Sent: =
Sunday, October 29, = 2006 4:47 PM
To: = 'derby-user@db.apache.org'
Subject: dialog hangs on referntial exception

 

hi-

 

derby 10.1.3.1 windows

 

is there some loop trying to commit the sql = transaction that causes

a delay?  = it cause the dialog to become responsive for a little = too

long and then returns control eventually and displays = my custom

error message to the = user.

 

can someone please give me a quick tip to avoid = this?

 

btw I really like how easy it is to put a column = constraint

to handle integrity.  I once did it with tcl and sqlite and had to = use

triggers.

 

thanks,

jim

------=_NextPart_000_0001_01C6FB8C.05B09690--