You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2011/01/17 17:53:43 UTC
[jira] Closed: (DERBY-4964) Client driver fails to convert string
to boolean with setObject(col, str, Types.BIT)
[ https://issues.apache.org/jira/browse/DERBY-4964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-4964.
-------------------------------------
Resolution: Fixed
Fix Version/s: 10.7.1.3
Merged to 10.7 and committed revision 1059984.
> 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
> Assignee: Knut Anders Hatlen
> Fix For: 10.7.1.3, 10.8.0.0
>
> Attachments: derby-4964-1a.diff, mapping-test.diff
>
>
> 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.