From dev-return-16633-apmail-jackrabbit-dev-archive=jackrabbit.apache.org@jackrabbit.apache.org Wed Feb 06 01:09:29 2008 Return-Path: Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: (qmail 40854 invoked from network); 6 Feb 2008 01:09:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Feb 2008 01:09:29 -0000 Received: (qmail 6506 invoked by uid 500); 6 Feb 2008 01:09:20 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 6475 invoked by uid 500); 6 Feb 2008 01:09:20 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 6466 invoked by uid 99); 6 Feb 2008 01:09:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Feb 2008 17:09:20 -0800 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; Wed, 06 Feb 2008 01:09:00 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 110BA71406F for ; Tue, 5 Feb 2008 17:09:08 -0800 (PST) Message-ID: <22632929.1202260148067.JavaMail.jira@brutus> Date: Tue, 5 Feb 2008 17:09:08 -0800 (PST) From: "Chris Schmidt (JIRA)" To: dev@jackrabbit.apache.org Subject: [jira] Commented: (JCR-1362) DatabaseJournal improperly finds tables in external schemas when used on Oracle In-Reply-To: <5299879.1202260028414.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/JCR-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12565980#action_12565980 ] Chris Schmidt commented on JCR-1362: ------------------------------------ I have an implementation that I can include for this issue, but it also includes tablespace (for Oracle) and filegroup (for SqlServer) support. If those enhancements are OK to include, I will attach the patch. > DatabaseJournal improperly finds tables in external schemas when used on Oracle > ------------------------------------------------------------------------------- > > Key: JCR-1362 > URL: https://issues.apache.org/jira/browse/JCR-1362 > Project: Jackrabbit > Issue Type: Bug > Affects Versions: 1.3.3, 1.4 > Reporter: Chris Schmidt > > The DatabaseJournal currently calls database metadata to determine if the journal table has already been created. It uses the following code to do so: > ResultSet rs = metaData.getTables(null, null, tableName, null); > The Oracle driver sometimes will return the table if it is in another schema on the same database. Other DBMS code within JackRabbit has a specific Oracle version that handles this case. In order for the journal table to be properly created, Oracle databases will need the schema name included in the getTables() call. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.