string data right truncation

[roha_78]

i am using the follwing code to connect to db2 :
java.sql.Connection connection = null;
java.sql.ResultSet rs = null;

ExperimentJDBCHelperBean jdbchelper =
new ExperimentJDBCHelperBean();

DataSource myDS = ExperimentJDBCHelperBean.getDataSource();

connection = myDS.getConnection();

java.sql.Statement stmt = connection.createStatement();
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.jdbc.DB2Exception: [IBM][CLI Driver] CLI0109E String data
right truncation. SQLSTATE=22001
at
com.ibm.ejs.container.ContainerManagedBeanO.postCr eate(ContainerManagedBeanO.java:500)
at
com.ibm.ejs.container.EJSHome.postCreateCommon(EJS Home.java:2050)
at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.j ava:1953)
at
com.ibm.commerce.order.objects.EJSCMPOrderPaymentI nfoHomeBean_322c34bb.postCreateWrapper(EJSCMPOrder PaymentInfoHomeBean_322c34bb.java:18)
at
com.ibm.commerce.order.objects.EJSCMPOrderPaymentI nfoHomeBean_322c34bb.create(EJSCMPOrderPaymentInfo HomeBean_322c34bb.java:38)
at
com.ibm.commerce.order.objects.EJSRemoteCMPOrderPa ymentInfoHome_322c34bb.create(EJSRemoteCMPOrderPay mentInfoHome_322c34bb.java:35)
at
com.ibm.commerce.order.objects._OrderPaymentInfoHo me_Stub.create(_OrderPaymentInfoHome_Stub.java:82)
at
com.ibm.commerce.order.objects.OrderPaymentInfoAcc essBean.<init>(OrderPaymentInfoAccessBean.java:53)
at
com.ibm.commerce.order.commands.SetOrderPaymentInf oCmdImpl.performExecute(SetOrderPaymentInfoCmdImpl .java:97)
at
com.ibm.commerce.command.ECCommandTarget.executeCo mmand(ECCommandTarget.java:133)
at
com.ibm.ws.cache.command.CommandCache.executeComma nd(CommandCache.java:333)

[Rhino]

<ro*****@yahoo.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...

i am using the follwing code to connect to db2 :
java.sql.Connection connection = null;
java.sql.ResultSet rs = null;

ExperimentJDBCHelperBean jdbchelper =
new ExperimentJDBCHelperBean();

DataSource myDS = ExperimentJDBCHelperBean.getDataSource();

connection = myDS.getConnection();

java.sql.Statement stmt = connection.createStatement();
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 "SetOrderPaymentInfoCmdImpl", or even the first part of the
domain name - com.ibm.commerce.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 ,