From derby-user-return-13781-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu Jul 21 15:31:44 2011 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 18F3760F0 for ; Thu, 21 Jul 2011 15:31:44 +0000 (UTC) Received: (qmail 3917 invoked by uid 500); 21 Jul 2011 15:31:43 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 3860 invoked by uid 500); 21 Jul 2011 15:31:43 -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 3853 invoked by uid 99); 21 Jul 2011 15:31:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jul 2011 15:31:42 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.138.91.45] (HELO nm20-vm0.bullet.mail.ne1.yahoo.com) (98.138.91.45) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 21 Jul 2011 15:31:33 +0000 Received: from [98.138.90.52] by nm20.bullet.mail.ne1.yahoo.com with NNFMP; 21 Jul 2011 15:31:12 -0000 Received: from [98.138.87.8] by tm5.bullet.mail.ne1.yahoo.com with NNFMP; 21 Jul 2011 15:31:12 -0000 Received: from [127.0.0.1] by omp1008.mail.ne1.yahoo.com with NNFMP; 21 Jul 2011 15:31:12 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 437387.8645.bm@omp1008.mail.ne1.yahoo.com Received: (qmail 25472 invoked by uid 60001); 21 Jul 2011 15:31:12 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1311262272; bh=yXRaW7WZqW6A4Jg66GTTU+rAfw3URT02ECmPT8I4TAs=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=2l6bNLW9FiophWf53sYiJQH4Fc05l8IKJfbHI+Wb39Fqh7nh3ja0Mf28B0yVNXAu+8bq5bllz7devBnyw0AeO6oqFIvDwMMILgxQqK/ntGifJwvNytjG79A9vYPqiTxfkmz+kFpwuWabkLitrARmrYkfImInZsvMTHdEpGkvUpw= DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=vxnHobOedDUY3Nitz/DsH/2JURDYos66YZs6Z09Gcm3AO6J6B1gUGMvPUb7JbPbWDKLlV+SgaE5DVErId0p+RZY+BCDbcrIr9KtLZMUsT2tx0rfcMjPVw0d0N0XQE+daEidAK8bIdd3KBVeJkH1iKI8s2DuUKOnekCrybmNT3Bs=; X-YMail-OSG: PZvI4fUVM1nOFZRfi7iJI2mgwctreEEvLA5ACJ1CBmmsnSE bOlUWO34i_A6oqUoU4IlE43GKS9egwmOdLFv3HhkDvsM6NzAGVrwxX4UVN3c bcmJH.SwkWPifgfpkiUINBa.AjsiVY1LfVdJcTprMdL4_E_Uen4jMkQiNFjL 9sWDtx4DmvB5HCvxHf0vqqBoGzL8HgYRg.qUSyT7yRrkNna.EDQ772WotdQ8 19cojVq8u8rD8sFvkx5axnxzN1ZzPXRYPoIys9mlbgo_bhZnQxPXp.1VXVP. 71Ml6GKCswWbm.7H1kTTjupPx883Q4AL3fR2YuMhGKQIx4p2DEAyjkfZUJM5 xCjn9CNm2xSLPLAuVCnN8sp9QvHQcKkjEx7G6cUdC_FFM3krQKwgNt07mDZC JQDqWVt0ka8Or4pc- Received: from [98.138.83.202] by web125402.mail.ne1.yahoo.com via HTTP; Thu, 21 Jul 2011 08:31:11 PDT X-Mailer: YahooMailWebService/0.8.112.307740 References: <1311129765.48826.YahooMailNeo@web125418.mail.ne1.yahoo.com><1311197852.35165.YahooMailNeo@web125402.mail.ne1.yahoo.com> <587F755518F04BABA595879723F0DE84@PROXIFLEX> <1311260553.5902.YahooMailNeo@web125404.mail.ne1.yahoo.com> Message-ID: <1311262271.24638.YahooMailNeo@web125402.mail.ne1.yahoo.com> Date: Thu, 21 Jul 2011 08:31:11 -0700 (PDT) From: Tomcat Programmer Reply-To: Tomcat Programmer Subject: Re: nulls in prepared statement To: Derby Discussion , Tomcat Programmer In-Reply-To: <1311260553.5902.YahooMailNeo@web125404.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-339724331-1311262271=:24638" --0-339724331-1311262271=:24638 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0A=0A> =A0=0A> Well may be you won't have less ugly code, but at =0Aleast = it will be hidden ;-)=0A> =A0=0A> I think the easiest way it to use you own= =0APreparedStatement class. So you can do=A0=0A> any special treatment or = workaround in a centralized and unique place.=0A>=0A=0AHi JYL this is a ver= y insightful and interesting solution, which I would not have thought of. = =A0Is this as simple as creating my own class with the derby version as its= superclass and then just overriding the method? =A0That seems too easy .. = is there any catches or pitfalls you can give me a heads up on? =A0Thanks a= gain for your help!=A0=0A=0AAdding one specific thought: =A0if I extend the= class, how do I get my version to be instantiated? (this is a web applicat= ion and so it will be picking up driver registration and so forth from JNDI= .)=A0 --0-339724331-1311262271=:24638 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

<= /div>
=0A
>  
=0A
> Well may be you won't have les= s ugly code, but at =0Aleast it will be hidden ;-)
=0A
>  
=0A
> I think the ea= siest way it to use you own =0APreparedStatement class. So you can do =
> any special treatment or workaround in= a centralized and unique place.
=0A
&= gt;
=0A

<= /font>
Hi JY= L this is a very insightful and interesting solution, which I would not hav= e thought of.  Is this as simple as creating my own class with the der= by version as its superclass and then just overriding the method?  Tha= t seems too easy .. is there any catches or pitfalls you can give me a head= s up on?  Thanks again for your help! 

Adding one specific tho= ught:  if I extend the class, how do I get my version to be instantiat= ed? (this is a web application and so it will be picking up driver registration and so forth from JNDI.) = ;
<= font size=3D"2" face=3D"Verdana">


--0-339724331-1311262271=:24638--