db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-1500) PreparedStatement#setObject(int parameterIndex, Object x) throws SQL Exception when binding Short value in embedded mode
Date Wed, 02 Aug 2006 19:57:36 GMT
I updated the JDBC 4 spec data conversion tables for Short and Byte so I 
would add support for  them when u can

-lance

Markus Fuchs (JIRA) wrote:
>     [ http://issues.apache.org/jira/browse/DERBY-1500?page=comments#action_12424627 ]

>             
> Markus Fuchs commented on DERBY-1500:
> -------------------------------------
>
> This behavior is apparantly implemented by many major database vendors, e.g. Oracle,
SQLServer, Sybase, and the Derby network server. Because it's undefined by the JDBC spec doesn't
mean that it *must* not be provided for user convenience. 
>
>   
>> PreparedStatement#setObject(int parameterIndex, Object x) throws SQL Exception when
binding Short value in embedded mode
>> ------------------------------------------------------------------------------------------------------------------------
>>
>>                 Key: DERBY-1500
>>                 URL: http://issues.apache.org/jira/browse/DERBY-1500
>>             Project: Derby
>>          Issue Type: Bug
>>          Components: JDBC
>>    Affects Versions: 10.1.1.0, 10.1.3.1
>>         Environment: WindowsXP
>>            Reporter: Markus Fuchs
>>         Attachments: ShortTest.java
>>
>>
>> When trying to insert a row into the table 
>> SHORT_TEST( ID int, SHORT_VAL smallint)
>> an exception is thrown, if the object value given to PreparedStatement#setObject(int
parameterIndex, Object x) is of type Short. The exception thrown is:
>> --- SQLException ---
>> SQLState:  22005
>> Message:  An attempt was made to get a data value of type 'SMALLINT' from a data
value of type 'java.lang.Short'.
>> ErrorCode:  20000
>> SQL Exception: An attempt was made to get a data value of type 'SMALLINT' from a
data value of type 'java.lang.Short'.
>> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>> 	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
>> 	at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
>> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(Unknown
Source)
>> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setObject(Unknown Source)
>> Tested on Derby 10.1.1.0 and 10.1.3.1. The same test runs fine in network mode.
>>     
>
>   

Mime
View raw message