db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jitendra Kharche" <Jitendra.Khar...@geometricsoftware.com>
Subject Java Data Types in Derby
Date Mon, 24 Jul 2006 11:51:45 GMT
Thanks Kristian.
I checked. The column size is smaller than the data being inserted.

I have two questions
1. Does Derby support java data types like cloudscape?
2. Is there any user interface tool for Derby?
Jitendra Kharche
Geometric Software Solutions Co. Ltd.
Work: +91-20-2290 6351
This e-mail communication and any attachments are privileged and
confidential and intended only for the use of the recipients named
above. If you are not the intended recipient, please do not review,
disclose, disseminate, distribute or copy this e-mail and attachments.
If you have received this communication in error, please notify the
sender immediately by email or telephone at+91-20-22906351.

-----Original Message-----
From: Kristian.Waagan@Sun.COM [mailto:Kristian.Waagan@Sun.COM] 
Sent: Monday, July 24, 2006 4:56 PM
To: Derby Discussion
Subject: Re: ERROR 22001

Jitendra Kharche wrote:
> Hi,
> I am using Derby that is embedded in Websphere App Server Community
> I get the following error
> ERROR 22001: A truncation error was encountered trying to shrink 
> VARCHAR Can anybody explain about this and how can i remove it.

Hello Jitendra,

To me it looks like the data that is inserted into Derby is too large
(ie. the string is too long). The maximum size of VARCHAR in Derby is
32672 characters. It might also be that the column is defined to have a
smaller maximum length.

As for truncation, only trailing whitespace can be truncated.

You could check the length of your data and the maximum length of the
column it is inserted into.
If the data is too long, you can increase the size of your VARCHAR
If you need to store larger amounts of texts, you might have to use CLOB

You also have LONG VARCHAR. It is the same as VARCHAR, but you don't
need to specify a maximum length when you create the table. It can hold
  a maximum of 32700 characters.


> Regards,
> Jitendra

View raw message