Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 48844 invoked from network); 21 Mar 2008 00:37:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Mar 2008 00:37:17 -0000 Received: (qmail 65559 invoked by uid 500); 21 Mar 2008 00:37:15 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 65535 invoked by uid 500); 21 Mar 2008 00:37:15 -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 65526 invoked by uid 99); 21 Mar 2008 00:37:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Mar 2008 17:37:15 -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, 21 Mar 2008 00:36:45 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 3C432234C0A6 for ; Thu, 20 Mar 2008 17:35:24 -0700 (PDT) Message-ID: <251304754.1206059724231.JavaMail.jira@brutus> Date: Thu, 20 Mar 2008 17:35:24 -0700 (PDT) From: "Catalina Wei (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-541) Generate SQL92 JOIN syntax for Oracle 9 or later releases MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Generate SQL92 JOIN syntax for Oracle 9 or later releases --------------------------------------------------------- Key: OPENJPA-541 URL: https://issues.apache.org/jira/browse/OPENJPA-541 Project: OpenJPA Issue Type: Improvement Components: sql Affects Versions: 1.0.3, 1.1.0 Reporter: Catalina Wei Assignee: Catalina Wei Oracle 8 JOIN syntax is produced for Oracle 10g reported from a customer. Oracle 9 or later release do support SQL92 JOIN syntax. Should we fix it in OracleDictionary ? The proposed fix is : change the initial setting of joinSyntax = SYNTAX_DATABASE; ==> joinSyntax = SYNTAX_SQL92; I am not sure whether this fix affecting those accessing Oracle thru jdbc:datadirect. Could anyone familiar with datadirect comment on this fix ? Thanks. Catalina -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.