[DERBY-4964] Client driver fails to convert string to boolean with setObject(col, str, Types.BIT)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.7.1.4, 10.8.1.2
• Component/s: JDBC
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard, Embedded/Client difference
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 10/Jan/11 21:46
• Updated: 29/May/12 08:52
• Resolved: 17/Jan/11 16:53

Description

The following code

PreparedStatement ps = c.prepareStatement("values cast(? as boolean)");
ps.setObject(1, "true", Types.BIT);
ResultSet rs = ps.executeQuery();
rs.next();
System.out.println(rs.getString(1));

executes successfully using the embedded driver, but fails when using the client driver:

Exception in thread "main" java.sql.SQLDataException: Invalid character string format for type INTEGER.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.setObject(Unknown Source)
at Test.main(Test.java:8)
Caused by: org.apache.derby.client.am.SqlException: Invalid character string format for type INTEGER.
at org.apache.derby.client.am.CrossConverters.setObject(Unknown Source)
at org.apache.derby.client.am.CrossConverters.setObject(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.setObjectX(Unknown Source)
... 2 more
Caused by: java.lang.NumberFormatException: For input string: "true"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:449)
at java.lang.Integer.valueOf(Integer.java:554)
... 5 more

This issue was found when running the Java EE CTS with Derby 10.7.1.1.

Issue Links

• is related to: DERBY-5788 BIT support regression and confusing message in 10.8.2.2: org.apache.derby.client.am.SqlException: Invalid character string format for type BOOLEAN