openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fay Wang (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-745) Sybase by default silently truncates a string which is longer than the column length without raising an exception
Date Tue, 14 Oct 2008 15:57:44 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Fay Wang updated OPENJPA-745:
-----------------------------

    Description: By default, Sybase silently truncates a string which is longer than the column
length without raising an exception. To override this behavior, string_rtruncation must be
set on. In order to be consistent with other databases (which raise exceptions when a string
length is longer than the column length), we will set string_rtruncation on by default for
Sybase. For an application that wants to keep Sybase silent truncation behavior, a DBDictionary
property "setStringRightTruncationOn" is introduced. When it is set to false in the persistence.xml,
the string will be silently truncated during insert/update.   (was: By default, Sybase silently
truncates a string which is longer than the column length without raising an exception. To
override this behavior, string_rtruncation must be set on. In order to be consistent with
other databases, we will set string_rtruncation on as a default. If the application wants
to keep Sybase silent truncation behavior, it has to set this property to false. A DBDictionary
property "setStringRightTruncationOn" is instroduced so that application can set it to false
in the persistence.xml. )

> Sybase by default silently truncates a string which is longer than the column length
without raising an exception 
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-745
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-745
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Fay Wang
>            Priority: Minor
>             Fix For: 1.2.1, 1.3.0
>
>
> By default, Sybase silently truncates a string which is longer than the column length
without raising an exception. To override this behavior, string_rtruncation must be set on.
In order to be consistent with other databases (which raise exceptions when a string length
is longer than the column length), we will set string_rtruncation on by default for Sybase.
For an application that wants to keep Sybase silent truncation behavior, a DBDictionary property
"setStringRightTruncationOn" is introduced. When it is set to false in the persistence.xml,
the string will be silently truncated during insert/update. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message