From derby-dev-return-72722-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Thu Sep 03 06:24:02 2009 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 59923 invoked from network); 3 Sep 2009 06:24:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Sep 2009 06:24:01 -0000 Received: (qmail 83345 invoked by uid 500); 3 Sep 2009 06:24:01 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 83294 invoked by uid 500); 3 Sep 2009 06:24:01 -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 83286 invoked by uid 99); 3 Sep 2009 06:24:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Sep 2009 06:24:01 +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; Thu, 03 Sep 2009 06:23:53 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 0EB0F234C04B for ; Wed, 2 Sep 2009 23:23:33 -0700 (PDT) Message-ID: <129737195.1251959013058.JavaMail.jira@brutus> Date: Wed, 2 Sep 2009 23:23:33 -0700 (PDT) From: "Mark B (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-3676) Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far In-Reply-To: <794244824.1210868515653.JavaMail.jira@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-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mark B updated DERBY-3676: -------------------------- Attachment: humanstringprepared.txt make logic consistent Embedded <-> client > Make the toString() method of Derby PreparedStatements print out SQL text with ? parameters replaced by the values that have been set so far > -------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-3676 > URL: https://issues.apache.org/jira/browse/DERBY-3676 > Project: Derby > Issue Type: Improvement > Components: JDBC > Reporter: Rick Hillegas > Attachments: humanstringprepared.txt, humanstringprepared.txt, humanstringprepared.txt, humanstringprepared.txt, ick.txt, ick.txt > > > This topic came up in the following email thread on the user list: http://www.nabble.com/PreparedStatement.toString%28%29---nice-formatting-td17250811.html#a17250811 Here's what the thread requests: > "In mysql, a toString() on a PreparedStatement will do this, eg "select x > from foo where x.a = ?" will become "select x from foo where x.a = 1" with > the appropriate setValue() call." > At first blush, this seems like it might be a simple project for a newcomer. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.