JDBC and DB2 Char(n) FOR BIT DATA

[john jillella]

Guys,
I have problem calling a Db2 pl/sql procedure which accepts char(n) for bit data.

Please let know suitable cs.setXXX method and corresponding JDBC datatype. An example is appreciated. Thank you

[Scott Selikoff]

Have you tried setString()?

[john jillella]

Scott Selikoff wrote:Have you tried setString()?

Yes, I tried setString but doesn't work. Thanks.

[Scott Selikoff]

How about setBytes or setCharacterStream? I would just go through the ResultSet API and try the ones related to characters/string. Otherwise check the DB2 JDBC documentation and see if nchar is an unsupported type, although I doubt it's not supported.

[john jillella]

Scott Selikoff wrote:How about setBytes or setCharacterStream? I would just go through the ResultSet API and try the ones related to characters/string. Otherwise check the DB2 JDBC documentation and see if nchar is an unsupported type, although I doubt it's not supported.

I tried using setBytes. i'll try again tomorrow. In Db2 database it is shown as a binary value.