473,405 Members | 2,210 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

String data right truncation

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)


when i am passing more data in a field , i am getting this problem
...please let me know

May 17 '06 #1
2 6599
The string you give to this field is too long, find out the definition
of the table...
ro*****@yahoo.com wrote:
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)


when i am passing more data in a field , i am getting this problem
..please let me know


May 17 '06 #2
ya string is too long ...but in the table the field length is nearly
three times the String length ...i think the problem is in the odbc
driver ..
so please let me know

May 17 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David Sharp | last post by:
I'm working with some long standing VB/SQL Server applications and for the second time we've suffered from having the parameters to a stored procedure call get silently truncated now that the data...
9
by: Eric Lilja | last post by:
Hello, consider the following two functions: /* function foo() */ void foo() { float y = 0.0f; float sum = 0.0f; for(int i = 0; i < num; ++i) {
10
by: joel.brewster | last post by:
We have a VB6 application using ADO version 2.5 and I am receiving a " CLI0109E String data right truncation. SQLSTATE=22001" error when I execute the rs.UpdateBatch method. I have determined...
1
by: gimme_this_gimme_that | last post by:
When you get the message : String data right truncation. SQLSTATE=22001 What is usually the source of the problem? Might a null value assigned get a PreparedStatement's setString method be...
37
by: Shri | last post by:
hi all, i am writing a code in which i have a char buffer "cwdir" which hold the current working directory by calling the function getcwd(). later i change the directory to "/" as i have to make...
5
by: ywchan | last post by:
I would like to convert a string to a fixed length e.g. if fixed length = 10 'abc' -> ' abc' 'abcdefghijklm' -> 'abcdefghij' Is there any simple function in C# can perform this operation?...
9
by: Sean | last post by:
I am using a datagrid to display some data. I notice when I click in a cell where the data is longer than the cell width, it truncates the end of the data off. For example: The data is: This...
2
by: roha_78 | last post by:
i am using the follwing code to connect to db2 : java.sql.Connection connection = null; java.sql.ResultSet rs = null; ExperimentJDBCHelperBean jdbchelper = new ExperimentJDBCHelperBean();...
0
by: Brenda | last post by:
We are on DB2, AIX fixpak 14 This error happens when running PeopleSoft PeopleCode Application Engine process. I have checked other posts out here and it seems like others who have reported...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.