Bit Varying Prepare Statement

"dmp" <[email protected]> Fri, 20 Apr 2018 10:56:58 -0700
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <0ce153fc1245e5e38bea9c3a9e747739.squirrel@dandymadeproductions.com>
Hello,

Given:

CREATE TABLE hsqltypes (
    data_type_id IDENTITY PRIMARY KEY,
    bit_type BIT DEFAULT NULL,
    bitvarying_type BIT VARYING(5) DEFAULT NULL
)

I'm able to use a Prepare Statement with BIT, but don't
seem to be able to get BIT VARYING(x) to take.

SQLException value cannot be converted to target type.
SQLState 22501 VendorError -3471

INSERT INTO "hsqltypes" ("data_type_id", "bit_type", "bitvarying_type")
VALUES (?, ?, ?)

Tried, setObject(), setInt(), setString(), B'00001' All the same.

prepared_sqlStatement.setString(i++, "00001");

danap.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot