[OPENJPA-745] Sybase by default silently truncates a string which is longer than the column length without raising an exception

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.1, 1.3.0
• Assignee: Unassigned
• Reporter: Fay Wang
• Created: 13/Oct/08 22:36
• Updated: 09/Mar/10 18:32
• Resolved: 22/Oct/08 23:34

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.

Issue Links

• relates to: OPENJPA-750 OptimisticLockException is thrown when numeric truncation occurs on Sybase