Getting exception when updating the table.

[Chinnu55]

Hi,

I am using db2 database, when I am trying to update a table from java code
i.e. using preparedStatement

PreparedStatement prepStatement = conn.prepareStatement(updateValue);
prepStatement.executeUpdate();

updateValue is String which contians update sql query like "
update WEB.USER set HR_CODE = 'Rationale Acct Mgr, kind of testing the lenght of value to update the DB2 database table' where ID = '1234' "

even though the field length is 100 i.e. VARCHAR(100) in database. And length of the HR_CODE value 'Rationale Acct Mgr, kind of testing the lenght of value to update the DB2 database table' to update is 89 characters

Getting exception:
com.ibm.db2.jcc.a.SqlException: Value "Rationale Acct Mgr, kind of testing the lenght of value to " is too long.
at com.ibm.db2.jcc.c.ig.d(ig.java(Compiled Code))
at com.ibm.db2.jcc.a.kb.l(kb.java(Compiled Code))
at com.ibm.db2.jcc.a.kb.a(kb.java(Compiled Code))
at com.ibm.db2.jcc.a.w.a(w.java(Inlined Compiled Code))
at com.ibm.db2.jcc.a.ec.b(ec.java(Compiled Code))
at com.ibm.db2.jcc.c.jg.db(jg.java(Inlined Compiled Code))
at com.ibm.db2.jcc.c.jg.d(jg.java(Compiled Code))
at com.ibm.db2.jcc.c.jg.Y(jg.java(Compiled Code))
at com.ibm.db2.jcc.c.jg.executeUpdate(jg.java(Compile d Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. pmiExecuteUpdate(WSJdbcPreparedStatement.java(Comp iled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. executeUpdate(WSJdbcPreparedStatement.java(Compile d Code))

[masijade]

Varchar 100 bytes? or characters? I don't know about DB2, but, at least with oracle, that designation makes a difference when using a unicode character set (or another encoding that using multibyte characters), and per default it is bytes, in which case that String is 178 bytes long (if not, as in Oracle, 356 bytes long), but the field would only allow 100.