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