[DERBY-5042] ResultSet.updateBoolean() on new BOOLEAN type throws exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.7.1.1
• Fix Version/s: 10.8.1.2
• Component/s: Network Client
• Environment: OS X 10.6.5, Java 1.6
• Bug behavior facts: Embedded/Client difference
• Assignee: Knut Anders Hatlen
• Reporter: Brett Wooldridge
• Created: 15/Feb/11 02:58
• Updated: 17/Jun/13 09:19
• Resolved: 24/Feb/11 12:54

Description

I am encountering an error trying to update a BOOLEAN type through an
updatable ResultSet. My table looks like this:

CREATE TABLE file_store (
path VARCHAR(255) NOT NULL,
network VARCHAR(32) NOT NULL,
file_blob BLOB,
file_md5 VARCHAR(32),
is_directory BOOLEAN NOT NULL DEFAULT false,
PRIMARY KEY (path, network)
);

My SQL looks like this:

SELECT path, network, is_directory FROM file_store
WHERE path=? AND network=? AND is_directory=true FOR UPDATE OF path, network, is_directory

My Java code looks like this:

...
resultSet.moveToInsertRow();
resultSet.updateString("path", dirPath);
resultSet.updateString("network", network);
resultSet.updateBoolean("is_directory", true);
resultSet.insertRow();

An exception is thrown in the call to updateBoolean() as follows:

java.sql.SQLException: An attempt was made to put a data value of type 'byte' into a data value of type 'BOOLEAN'.

It's a shame, I was looking forward to using the new BOOLEAN type before I roll out the next version of our software. For now I will fallback to SMALLINT. Does/will ALTER TABLE support a change from SMALLINT to BOOLEAN?

Issue Links

• is related to: DERBY-5058 Add support for "boolean" data type in UpdatableResultSetTest