Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 10117 invoked from network); 5 Mar 2007 17:45:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Mar 2007 17:45:19 -0000 Received: (qmail 25755 invoked by uid 500); 5 Mar 2007 17:45:27 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 25725 invoked by uid 500); 5 Mar 2007 17:45:27 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 25716 invoked by uid 99); 5 Mar 2007 17:45:27 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Mar 2007 09:45:27 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [68.142.198.212] (HELO smtp113.sbc.mail.mud.yahoo.com) (68.142.198.212) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 05 Mar 2007 09:45:15 -0800 Received: (qmail 50684 invoked from network); 5 Mar 2007 17:44:53 -0000 Received: from unknown (HELO ?127.0.0.1?) (ddebrunner@sbcglobal.net@75.24.209.64 with plain) by smtp113.sbc.mail.mud.yahoo.com with SMTP; 5 Mar 2007 17:44:52 -0000 X-YMail-OSG: 2lwWPN4VM1n4vnB4tWiAWsrZZyj7FjEiLm2knmWkRIpchfBcyXs6ODpqS50rhcf2pu.XqkexAcGyCPWQaag6Ugp6dUf_VfefsG7FnkCNc7lBlbI_Mwoee_9Xd4Zs5NdDhBCu9od7T5SHhTU- Message-ID: <45EC5711.9030200@apache.org> Date: Mon, 05 Mar 2007 09:44:49 -0800 From: Daniel John Debrunner User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: PreparedStatement.setXXX methods do not set up ContextStack. Is that right and if so, why? References: <45E9B178.3030902@apache.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Mamta Satoor wrote: > Another solution that I have been thinking of is to have the locale > dependents datatypes by aware of their locale so they can use that > locale information in their locale sensitive methods. So, for eg, in the > ij script example that we are discussing, SQLTimestamp in it's > constructor should get the Locale/LocaleFinder/some other effective > object (copying Dan's line literally here) and locale sensitive methods > like setValue can simply find the locale info in it's class itself. > > So, in other words, rather than passing the locale info to the locale > sensitive methods, pass it to the locale sensitive datatype in it's > constructor and use that locale info in all the locale sensitive methods > in that datatype class. I think there are a couple of issues with this approach: - the size in memory of each instance of a value (e.g. SQLTimestamp) will increase. Passing in the value will only increase a single object (e.g. the activation or language connection context). Imagine a query that performs a lot of manipulation of timestamp values. - How to handling reading the value from disk? Would information about the locale need to be stored on disk to allow the object to be recreated correctly? Thus increasing on-disk size? (and upgrade issues?). Dan. Dan.