Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <30875431.49011289007881957.JavaMail.jira@thor>
Date: Fri, 5 Nov 2010 21:44:41 -0400 (EDT)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-4890) Different string to boolean conversion
 on embedded and client
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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.