Bit string type in PreparedStatement

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

Responses

Browse pgsql-jdbc by date

  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