Re: [eclipselink-users] @Column, length and string truncation

[James Sutherland <jamesssss@xxxxxxxxx>]

I would think you would want an error if your data was being truncated.

JPA does not perform any validation of column sizes, there is a validation
Spec (javax.validation I believe) that has some support for validation, but
I think it would give you the error in Java, not truncate the data.

You may wish to truncate the data in your set methods, or UI, or possibly
through a JPA or EclipseLink event.



Joe Mc. wrote:
> 
> Hi,
> 
> I have annotated a field for example with the following annotation:
> @Column(name="lastMessage", length=255)
> String message;
> 
> Further I insert in this field strings longer as 255 chars.
> The SQL Server throws an exception, cause the string is to long.
> Why does not Eclipselink truncate the string value to the specified length
> (here: 255) before the SQL Insert?
> 
> Does an other (configurable) ways exist?
> 
> Thanks
> 
> McJoe
> 
> Basic data:
> - Eclipselink 1.1.1
> - SQL Server 2005
> - Java 5/6
> 
> 


-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/%40Column%2C-length-and-string-truncation-tp26077771p26078322.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.