[
https://issues.apache.org/jira/browse/DERBY-4964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12979784#action_12979784
]
Knut Anders Hatlen commented on DERBY-4964:
-------------------------------------------
We have the same problem if Types.BIT is replaced with Types.BOOLEAN.
> Client driver fails to convert string to boolean with setObject(col, str,
> Types.BIT)
> ------------------------------------------------------------------------------------
>
> Key: DERBY-4964
> URL: https://issues.apache.org/jira/browse/DERBY-4964
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.7.1.1
> Reporter: Knut Anders Hatlen
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
