From dev-return-8958-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Mon Aug 11 16:25:46 2008 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 54587 invoked from network); 11 Aug 2008 16:25:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Aug 2008 16:25:46 -0000 Received: (qmail 94506 invoked by uid 500); 11 Aug 2008 16:25:45 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 94481 invoked by uid 500); 11 Aug 2008 16:25: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 94470 invoked by uid 99); 11 Aug 2008 16:25:45 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Aug 2008 09:25: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; Mon, 11 Aug 2008 16:24:46 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 859DA234C1A2 for ; Mon, 11 Aug 2008 09:24:44 -0700 (PDT) Message-ID: <1320753401.1218471884546.JavaMail.jira@brutus> Date: Mon, 11 Aug 2008 09:24:44 -0700 (PDT) From: "Albert Lee (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Resolved: (OPENJPA-686) Openjpa manual needs to be updated for database restriction on BigDecimal field on Sybase In-Reply-To: <1973999899.1218232964391.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/OPENJPA-686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Albert Lee resolved OPENJPA-686. -------------------------------- Resolution: Fixed > 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 > Affects Versions: 1.0.3, 1.1.0, 1.2.0 > Reporter: Fay Wang > Assignee: Fay Wang > Priority: Minor > Fix For: 1.2.1, 1.3.0 > > Attachments: openjpa_686.patch > > > 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.