[DERBY-1500] PreparedStatement#setObject(int parameterIndex, Object x) throws SQL Exception when binding Short value in embedded mode

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0, 10.1.3.1
• Fix Version/s: 10.1.3.2, 10.2.1.6
• Component/s: JDBC
• Environment: WindowsXP
• Urgency: Normal
• Assignee: Knut Anders Hatlen
• Reporter: Markus Fuchs
• Created: 12/Jul/06 02:14
• Updated: 21/Jan/11 17:49
• Resolved: 24/Aug/06 06:11

Description

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.

Issue Links

• is related to: DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.