Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 2089 invoked from network); 8 Dec 2004 15:07:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 8 Dec 2004 15:07:24 -0000 Received: (qmail 89306 invoked by uid 500); 8 Dec 2004 15:07:23 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 89269 invoked by uid 500); 8 Dec 2004 15:07:22 -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: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 89256 invoked by uid 99); 8 Dec 2004 15:07:22 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from Unknown (HELO mgd.gluecode.com) (64.14.202.141) by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 08 Dec 2004 07:07:21 -0800 Received: from [10.6.18.193] (haw-206-126-135-113.vel.net [206.126.135.113]) (authenticated bits=0) by mgd.gluecode.com (8.12.10/8.12.10) with ESMTP id iB8F77CW029889 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 8 Dec 2004 07:07:08 -0800 Message-ID: <41B718A4.9020608@gluecode.com> Date: Wed, 08 Dec 2004 07:07:16 -0800 From: Jeremy Boynes User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: Re: [jira] Updated: (DERBY-89) Support Java Signature in procedure declaration References: <1316776008.1102296082390.JavaMail.apache@nagoya> <41B71649.5000706@debrunners.com> In-Reply-To: <41B71649.5000706@debrunners.com> X-Enigmail-Version: 0.86.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Daniel John Debrunner wrote: > Jeremy Boynes (JIRA) wrote: >>> >>>Patch that supports Java signature in the external name provided they > > Jeremy, any idea what happens with your patch if the incorrect type is > specified for a parameter, e.g. java.lang.String for a SQL INTEGER? > Assuming there is such a method. > If the value passed to CallableStatement.setString() can be converted to a numeric value then it is passed through; if it is not then you get: ERROR 22018: Invalid character string format for type INTEGER. This appears consistent with trying to insert a string value into an integer column. -- Jeremy