db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Boynes <jboy...@gluecode.com>
Subject Re: [jira] Updated: (DERBY-89) Support Java Signature in procedure declaration
Date Wed, 08 Dec 2004 15:07:16 GMT
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

Mime
View raw message