From users-return-10670-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Tue Feb 17 22:20:02 2009 Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 49959 invoked from network); 17 Feb 2009 22:20:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Feb 2009 22:20:01 -0000 Received: (qmail 80955 invoked by uid 500); 17 Feb 2009 22:20:00 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 80941 invoked by uid 500); 17 Feb 2009 22:20:00 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 80928 invoked by uid 99); 17 Feb 2009 22:20:00 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Feb 2009 14:20:00 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of aklimets@day.com designates 207.126.148.182 as permitted sender) Received: from [207.126.148.182] (HELO eu3sys201aog002.obsmtp.com) (207.126.148.182) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 17 Feb 2009 22:19:51 +0000 Received: from source ([209.85.219.15]) by eu3sys201aob002.postini.com ([207.126.154.11]) with SMTP ID DSNKSZs38w/kJE0fnrwBbu4d6LmrqvDFD0xX@postini.com; Tue, 17 Feb 2009 22:19:31 UTC Received: by ewy8 with SMTP id 8so2301179ewy.5 for ; Tue, 17 Feb 2009 14:19:30 -0800 (PST) MIME-Version: 1.0 Received: by 10.210.12.18 with SMTP id 18mr1049622ebl.180.1234909170700; Tue, 17 Feb 2009 14:19:30 -0800 (PST) In-Reply-To: References: <27564c150902171310v63a5e6a8w73c076e8605b4e0b@mail.gmail.com> Date: Tue, 17 Feb 2009 23:19:30 +0100 Message-ID: Subject: Re: Jackrabbit embedded in Jahia 6 CE generates incorrect SQL for PostgreSQL. From: Alexander Klimetschek To: users@jackrabbit.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org On Tue, Feb 17, 2009 at 11:10 PM, Alexander Klimetschek wrote: > On Tue, Feb 17, 2009 at 10:10 PM, Jan-Helge Bergesen wrote: >> I'm trying to get Jahia 6 CE up and running with PostgreSQL 8.3 on Ubuntu >> 8.10. >> >> [org.apache.jackrabbit.core.fs.db.DatabaseFileSystem] - failed to initialize >> file system >> org.postgresql.util.PSQLException: ERROR: type "varbinary" does not exist > > Seems to be that Jahia includes an old version of Jackrabbit, because > this issue was fixed in Jackrabbit 1.4 already. Here is the old issue: > https://issues.apache.org/jira/browse/JCR-949 Upps, it's not the journal, but the DatabaseFileSystem. Then I suspect that the repository.xml/workspace.xml configuration of your Jackrabbit sets the wrong schema for the DbFileSystem [1]. The schema must be "postgresql": ..... You'll have to change all occurences of the DbFileSystem in repository.xml and all workspace.xml. [1] http://jackrabbit.apache.org/api/1.5/org/apache/jackrabbit/core/fs/db/DbFileSystem.html Regards, Alex -- Alexander Klimetschek alexander.klimetschek@day.com