From dev-return-8934-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Fri Aug 08 22:03:46 2008 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 81382 invoked from network); 8 Aug 2008 22:03:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Aug 2008 22:03:46 -0000 Received: (qmail 99301 invoked by uid 500); 8 Aug 2008 22:03:45 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 99273 invoked by uid 500); 8 Aug 2008 22:03:45 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 99261 invoked by uid 99); 8 Aug 2008 22:03:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Aug 2008 15:03:45 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Aug 2008 22:02:46 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 5FCA1234C19E for ; Fri, 8 Aug 2008 15:02:44 -0700 (PDT) Message-ID: <1973999899.1218232964391.JavaMail.jira@brutus> Date: Fri, 8 Aug 2008 15:02:44 -0700 (PDT) From: "Fay Wang (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-686) Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase ----------------------------------------------------------------------------------------- Key: OPENJPA-686 URL: https://issues.apache.org/jira/browse/OPENJPA-686 Project: OpenJPA Issue Type: Improvement Reporter: Fay Wang Priority: Minor Applications performing update/insert data of the BigDecimal java type may fail with OptimisticException if the the data exceeds the scale or precision of the db column on Sybase,. The Sybase behavior is working as documented, as shown in the following link: http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/3524;pt=693/* In Openjpa, it is not possible to specify precision/scale for the column mapped by a BigDecimal type. However, applications can specify the plugin value for the column type mapped by the BigDecimal java type: http://openjpa.apache.org/docs/latest/manual/manual.html#openjpa.jdbc.DBDictionary to avoid this trunction error problem. It is desirable to update the "database restrictions" section of the openjpa manual for this Sybase-specific trunction problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.