[
https://issues.apache.org/jira/browse/DERBY-4890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12929493#action_12929493
]
Knut Anders Hatlen commented on DERBY-4890:
-------------------------------------------
ParameterMappingTest contains two workarounds for this issue. Search for
comments with this issue number in the source file.
> Different string to boolean conversion on embedded and client
> -------------------------------------------------------------
>
> Key: DERBY-4890
> URL: https://issues.apache.org/jira/browse/DERBY-4890
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.7.1.0
> Reporter: Knut Anders Hatlen
>
> The following code fragment behaves differently on client and embedded:
> PreparedStatement ps = c.prepareStatement("values cast(? as
> boolean)");
> ps.setString(1, "TRUE");
> ResultSet rs = ps.executeQuery();
> rs.next();
> System.out.println(rs.getBoolean(1));
> Embedded prints "true". Client raises an exception:
> Exception in thread "main" java.sql.SQLDataException: An attempt was made to
> get a data value of type 'VARCHAR' from a data value of type 'BOOLEAN'.
> at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:72)
> at
> org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:358)
> at
> org.apache.derby.client.am.PreparedStatement.setString(PreparedStatement.java:884)
> at SetByte.main(SetByte.java:6)
> Caused by: org.apache.derby.client.am.SqlException: An attempt was made to
> get a data value of type 'VARCHAR' from a data value of type 'BOOLEAN'.
> at
> org.apache.derby.client.am.PreparedStatement$PossibleTypes.throw22005Exception(PreparedStatement.java:3069)
> at
> org.apache.derby.client.am.PreparedStatement.setString(PreparedStatement.java:874)
> ... 1 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
