Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 81240 invoked from network); 31 Jul 2007 18:59:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 Jul 2007 18:59:18 -0000 Received: (qmail 38268 invoked by uid 500); 31 Jul 2007 18:59:18 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 37967 invoked by uid 500); 31 Jul 2007 18:59:17 -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 37955 invoked by uid 99); 31 Jul 2007 18:59:17 -0000 Received: from Unknown (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 11:59:17 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jul 2007 18:59:16 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 457A37141F5 for ; Tue, 31 Jul 2007 11:58:56 -0700 (PDT) Message-ID: <29439562.1185908336281.JavaMail.jira@brutus> Date: Tue, 31 Jul 2007 11:58:56 -0700 (PDT) From: "Kevin Sutter (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Closed: (OPENJPA-77) Problems in default setting in DB2Dictionary , also missing support for DB2 z/OS platforms 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-77?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Sutter closed OPENJPA-77. ------------------------------- > Problems in default setting in DB2Dictionary , also missing support for DB2 z/OS platforms > ------------------------------------------------------------------------------------------ > > Key: OPENJPA-77 > URL: https://issues.apache.org/jira/browse/OPENJPA-77 > Project: OpenJPA > Issue Type: Bug > Components: jdbc > Reporter: Catalina Wei > Assignee: Kevin Sutter > Fix For: 0.9.7 > > > There are following problems: > 1. the default storeCharsAsNumbers = true, does not work well in DB2. Preferable default setting should be false. > 2. nextSequenceSQL() generates DB2 UDB specific SQLs which fails on DB2 z/OS platforms. > 3. lastGeneratedKeyQuery SQL string is applicable for DB2 UDB only, needs to provide DB2 z/OS specific SQL. > 4. bigintTypeName ="BIGINT" does not work for DB2 z/OS Version 8. > 5. characterColumnSize = 255 for default CHAR or VARCHAR fails on DB2 UDB platforms. DB2 UDB CHARACTER size limit is 254 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.