Return-Path: Delivered-To: apmail-openjpa-commits-archive@www.apache.org Received: (qmail 4941 invoked from network); 4 Aug 2008 19:45:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Aug 2008 19:45:37 -0000 Received: (qmail 25781 invoked by uid 500); 4 Aug 2008 19:45:36 -0000 Delivered-To: apmail-openjpa-commits-archive@openjpa.apache.org Received: (qmail 25735 invoked by uid 500); 4 Aug 2008 19:45:35 -0000 Mailing-List: contact commits-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 commits@openjpa.apache.org Received: (qmail 25726 invoked by uid 99); 4 Aug 2008 19:45:35 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Aug 2008 12:45:35 -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.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Aug 2008 19:44:47 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id E11A1238898E; Mon, 4 Aug 2008 12:45:14 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r682479 - /openjpa/branches/1.2.x/openjpa-project/src/doc/manual/supported_databases.xml Date: Mon, 04 Aug 2008 19:45:14 -0000 To: commits@openjpa.apache.org From: allee8285@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20080804194514.E11A1238898E@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: allee8285 Date: Mon Aug 4 12:45:14 2008 New Revision: 682479 URL: http://svn.apache.org/viewvc?rev=682479&view=rev Log: OPENJPA-663 - Commit manual changes submitted by Jeremy Bauer. Modified: openjpa/branches/1.2.x/openjpa-project/src/doc/manual/supported_databases.xml Modified: openjpa/branches/1.2.x/openjpa-project/src/doc/manual/supported_databases.xml URL: http://svn.apache.org/viewvc/openjpa/branches/1.2.x/openjpa-project/src/doc/manual/supported_databases.xml?rev=682479&r1=682478&r2=682479&view=diff ============================================================================== --- openjpa/branches/1.2.x/openjpa-project/src/doc/manual/supported_databases.xml (original) +++ openjpa/branches/1.2.x/openjpa-project/src/doc/manual/supported_databases.xml Mon Aug 4 12:45:14 2008 @@ -429,6 +429,20 @@ extending DB2Dictionary. + + +Explicit creation of indexes specified by the OpenJPA @Index annotation will +fail on DB2 for iSeries if the default schema used by the JDBC driver does not +exist. If a default schema is not specified on the connection, the iSeries +will default to the user profile name. If a schema of that name does not +exist, DB2 on iSeries will not create the schema, resulting in a failure when +creating the index. The failure message will look similar to: "[SQL0204] +USERNAME in QSYS type *LIB not found." To work around this issue, specify a +default schema on the JDBC URL or data source property and make sure that +schema exists or create a schema which matches the user profile of the +connection. + +