[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] @Column, length and string truncation
|
Yes. length and most of the @Column attributes are only relevant to DDL
generation.
Joe Mc. wrote:
>
> Hm ok,
> than is the "length" declaration only relevant for the DDL SQL statements?
>
> Regards
>
> McJoe
>
>
>
>
> James Sutherland wrote:
>>
>> 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://old.nabble.com/%40Column%2C-length-and-string-truncation-tp26077771p26160152.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.