Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 23067 invoked from network); 6 Jul 2009 19:27:33 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Jul 2009 19:27:33 -0000 Received: (qmail 5194 invoked by uid 500); 6 Jul 2009 19:27:43 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 5146 invoked by uid 500); 6 Jul 2009 19:27:43 -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 5138 invoked by uid 99); 6 Jul 2009 19:27:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jul 2009 19:27:43 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jul 2009 19:27:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id C7FFE234C004 for ; Mon, 6 Jul 2009 12:27:14 -0700 (PDT) Message-ID: <102162760.1246908434805.JavaMail.jira@brutus> Date: Mon, 6 Jul 2009 12:27:14 -0700 (PDT) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-2408) Coversion from string to time/date/timestamp does not use the locale because context pushing does not happen for PreparedStatement.setXXX methods In-Reply-To: <33125725.1173210924354.JavaMail.root@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-2408: --------------------------------- Urgency: Urgent Triaged for 10.5.2: assigned normal urgency. > Coversion from string to time/date/timestamp does not use the locale because context pushing does not happen for PreparedStatement.setXXX methods > ------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-2408 > URL: https://issues.apache.org/jira/browse/DERBY-2408 > Project: Derby > Issue Type: Bug > Components: JDBC > Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0 > Reporter: Mamta A. Satoor > > In the Derby implementation, the JDBC setXXX methods on PreparedStatement does not push/pop the context manager. This is to prevent the driver from getting performance hit. But some of the setXXX methods like, SQLTimestamp.setValue(String theValue), SQLTime.setValue(String theValue), SQLDate.setValue(String theValue) look at the context manager to find out the locale of the database so they can use that locale to do the appropriate conversion from string to date/time/timestamp. But since there is no context setup done for setXXX methods, locale information can't be established by these methods and they do not use the correct locale. This behavior has been around all Derby releases. > More information on this can be found in following thread http://www.nabble.com/PreparedStatement.setXXX-methods-do-not-set-up-ContextStack.-Is-that-right-and-if-so%2C-why--tf3337937.html#a9283354 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.