> -----Original Message----- > From: Jitendra Kharche [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 6:52 AM > To: Derby Discussion > Subject: Java Data Types in Derby > > > 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? [mjs] DERBY IS CLOUDSCAPE. And JavaDB....
> 2. Is there any user interface tool for Derby? > [mjs] User interface? Like Squirrel DB? Built in viewer to Eclipse? Or did you mean GUI development like NetBeans or Eclipse? The short answer is yes to both. > Regards, > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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 > Edition. > > 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 > column. > If you need to store larger amounts of texts, you might have to use CLOB > instead. > > 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, > -- > Kristian > > > > > Regards, > > Jitendra
