From: | bst <bst_co(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Bit string type in PreparedStatement |
Date: | 2005-04-14 15:45:07 |
Message-ID: | 20050414154508.66799.qmail@web50407.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I have a table with a bit string field
CREATE TABLE test (a BIT(8));
When I get the type of this filed from Java
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("SELECT a FROM
test");
ResultSetMetaData rsmd = rs.getMetaData();
int type = rsmd.getColumnType(1);
String name = rsmd.getColumnTypeName(1);
I get
type=-7 that is equal to java.sql.Types.BIT
name=bit
Now I'd like to set the field in a PreparedStatement
PreparedStatement update =
connection.prepareStatement("UPDATE test SET a=?");
update.setObject(1, "B10101010", java.sql.Types.BIT);
update.executeUpdate();
and I get
org.postgresql.util.PSQLException: ERROR: column "a"
is of type bit but expression is of type boolean
How can I set bit string field in PreparedStatement?
Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Kristina Magwood | 2005-04-14 20:37:52 | process large tables |
Previous Message | Kris Jurka | 2005-04-14 09:19:02 | Re: Data type for array of byte |