Hallo,
how can I use PreparedStatement to insert or update columns of type
bit(n), varbit, ...?
I have never figoured out the right way. In former versions of the
JDBC-Driver I used setString() as shown below or constructed the whole
query string and used Statement.
String sql =
"...
WHERE f1.verkehrstage & B? <> 0::bit(384)
...";
PreparedStatement pstmt_select1 = con.prepareStatement(sql);
BigInteger mybits = ...
// padding bits 0 on the left up to 384 (type bit(384))
String querybits = mybits.or(this.bit384).toString(2).substring(1);
pstmt_select1.setString(1, querybits);
...
ResultSet rs = pstmt_select1.executeQuery();
This does not work in versions 8.x.
Thank you
