string data right truncation

[roha_78]

i am using the follwing code to connect to db2 :
java.sql.Connec tion connection = null;
java.sql.Result Set rs = null;

ExperimentJDBCH elperBean jdbchelper =
new ExperimentJDBCH elperBean();

DataSource myDS = ExperimentJDBCH elperBean.getDa taSource();

connection = myDS.getConnect ion();

java.sql.Statem ent stmt = connection.crea teStatement();
and i am getting the following error evne if the table column length is
10 times more than the data sent .if iam sending data like 250 to 280
bytes it is working fine and if iam using more than that i am getting
the follwing error.
please let me know
thanks in advance.

COM.ibm.db2.jdb c.DB2Exception: [IBM][CLI Driver] CLI0109E String data
right truncation. SQLSTATE=22001
at
com.ibm.ejs.con tainer.Containe rManagedBeanO.p ostCreate(Conta inerManagedBean O.java:500)
at
com.ibm.ejs.con tainer.EJSHome. postCreateCommo n(EJSHome.java: 2050)
at com.ibm.ejs.con tainer.EJSHome. postCreate(EJSH ome.java:1953)
at
com.ibm.commerc e.order.objects .EJSCMPOrderPay mentInfoHomeBea n_322c34bb.post CreateWrapper(E JSCMPOrderPayme ntInfoHomeBean_ 322c34bb.java:1 8)
at
com.ibm.commerc e.order.objects .EJSCMPOrderPay mentInfoHomeBea n_322c34bb.crea te(EJSCMPOrderP aymentInfoHomeB ean_322c34bb.ja va:38)
at
com.ibm.commerc e.order.objects .EJSRemoteCMPOr derPaymentInfoH ome_322c34bb.cr eate(EJSRemoteC MPOrderPaymentI nfoHome_322c34b b.java:35)
at
com.ibm.commerc e.order.objects ._OrderPaymentI nfoHome_Stub.cr eate(_OrderPaym entInfoHome_Stu b.java:82)
at
com.ibm.commerc e.order.objects .OrderPaymentIn foAccessBean.<i nit>(OrderPayme ntInfoAccessBea n.java:53)
at
com.ibm.commerc e.order.command s.SetOrderPayme ntInfoCmdImpl.p erformExecute(S etOrderPaymentI nfoCmdImpl.java :97)
at
com.ibm.commerc e.command.ECCom mandTarget.exec uteCommand(ECCo mmandTarget.jav a:133)
at
com.ibm.ws.cach e.command.Comma ndCache.execute Command(Command Cache.java:333)

[Rhino]

<ro*****@yahoo. com> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. .

i am using the follwing code to connect to db2 :
java.sql.Connec tion connection = null;
java.sql.Result Set rs = null;

ExperimentJDBCH elperBean jdbchelper =
new ExperimentJDBCH elperBean();

DataSource myDS = ExperimentJDBCH elperBean.getDa taSource();

connection = myDS.getConnect ion();

java.sql.Statem ent stmt = connection.crea teStatement();
and i am getting the following error evne if the table column length is
10 times more than the data sent .if iam sending data like 250 to 280
bytes it is working fine and if iam using more than that i am getting
the follwing error.
please let me know
thanks in advance.

[snip]

This is at least the second time in the last few days that you have posted
this question. This time you have given us a few lines of code to go with
the stacktrace you provided the first time, which is probably a step
forward. But there is still not nearly enough information about how you are
storing this data for anyone to make a reasonably solid guess about what
might be wrong.

You haven't said what version of DB2 you are using, what platform you are
on, what program is trying to do the insert, what supporting programs are
being used to move the data or any of many other things that might be useful
in diagnosing your problem. I don't recognize the classes that you are
using, such as "SetOrderPaymen tInfoCmdImpl", or even the first part of the
domain name - com.ibm.commerc e.order - so I suspect that you are using some
kind of add-on IBM package that I don't recognize to do some of the work.
That's the code that seems to be throwing the exception but I can't debug
code from only this very skeletal information.

I think you have one of two problems. Either:
- This IBM product that you are using to pass data to DB2 has a bug in it,
in which case I suggest you contact the support organization for that
product, whatever it is.
-OR-
- This is a case of "garbage in, garbage out". In other words, you are
misusing this package somehow (by accident, not maliciously) and giving it
inappropriate data somehow. In that case, you should be able to find this
yourself by debugging your code and seeing where you are going wrong.

I don't think DB2 is the problem here and I don't think we can be of much
help in solving the problem. DB2 is just the component that is detecting the
problem and telling you that you are overflowing the column.

The only help we might be is if someone on this newsgroup can identify what
product contains the classes that are throwing the exception you are
getting. I certainly don't know but someone else may.
Perhaps you should do a Google search (or Google Groups search) on each
class name until you get an idea where this code originates?
--
Rhino

[roha_78]

thank you ,