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. |
- Re: [jira] Commented: (DERBY-1500) PreparedState... Lance J. Andersen
- [jira] Commented: (DERBY-1500) PreparedStat... Knut Anders Hatlen (JIRA)