Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Sun, 20 Feb 2011 21:36:38 +0000 (UTC)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <73516366.4881.1298237798681.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1462402942.4828.1298235518597.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] Updated: (DERBY-5063) Embedded driver allows updateBytes()
 on BOOLEAN column
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-5063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen updated DERBY-5063:
--------------------------------------

    Attachment: derby-5063-1a.diff

Removing the setValue(byte[]) override in the SQLBoolean class (see attached patch derby-5063-1a.diff) makes embedded raise the same error as the client.

> Embedded driver allows updateBytes() on BOOLEAN column
> ------------------------------------------------------
>
>                 Key: DERBY-5063
>                 URL: https://issues.apache.org/jira/browse/DERBY-5063
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.7.1.1
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>         Attachments: derby-5063-1a.diff
>
>
> The following code inserts the value TRUE into the table T on the embedded driver:
>         Statement s = c.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
>         s.execute("create table t(b boolean)");
>         ResultSet rs = s.executeQuery("select b from t");
>         rs.moveToInsertRow();
>         rs.updateBytes(1, "this is a test".getBytes());
>         rs.insertRow();
> The client driver fails:
> java.sql.SQLException: An attempt was made to put a data value of type 'byte[]' into a data value of type 'BOOLEAN'.
> I believe the client driver is correct, and embedded should be changed to match it.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira