db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <de...@segel.com>
Subject RE: Java Data Types in Derby
Date Mon, 24 Jul 2006 14:44:19 GMT


> -----Original Message-----
> From: Jitendra Kharche [mailto:Jitendra.Kharche@geometricsoftware.com]
> 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: 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
> 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




Mime
View raw message