Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: domain of jhberges@gmail.com designates
 209.85.134.185 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=URFZ8PMY2dzZuG4v7pCNIxeNutk8K3IiB2MDcMjvIZo6y5/XYdgkGbElcTOG2iTwP1
         1gG2KGZT352bQazb06H1dNTEq0GPtxEL2HzOhrsivcdjCdu/plKX8IDshH+6/1BXLP9W
         sZzdGRYxLzq5boPupUZCOpcCOyuyaX8XosIWE=
MIME-Version: 1.0
Date: Tue, 17 Feb 2009 22:10:00 +0100
Message-ID: <27564c150902171310v63a5e6a8w73c076e8605b4e0b@mail.gmail.com>
Subject: Jackrabbit embedded in Jahia 6 CE generates incorrect SQL for
	PostgreSQL.
From: Jan-Helge Bergesen <jhberges@gmail.com>
To: users@jackrabbit.apache.org
Content-Type: multipart/alternative; boundary=001636920027eafa2c046323b925

--001636920027eafa2c046323b925
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi there.

I'm trying to get Jahia 6 CE up and running with PostgreSQL 8.3 on Ubuntu
8.10.

Jahia has a config wizard, which does a fair attempt at setting things up --
however it does come a bit short in relation to Jackrabbit.

So, I'm almost good, however the jackrabbit instance fails with the
following message:
2009-02-17 21:55:20,359: ERROR
[org.apache.jackrabbit.core.fs.db.DatabaseFileSystem] - failed to initialize
file system
org.postgresql.util.PSQLException: ERROR: type "varbinary" does not exist
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
        at
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
        at
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(DatabaseFileSystem.java:1180)

I'm not sure if it's possible to enable debug to view the SQL, but using
Wireshark I see that the generated SQL is:

Query: create table JR_FSG_FSENTRY (FSENTRY_PATH varchar not null,
FSENTRY_NAME varchar not null, FSENTRY_DATA varbinary null, FSENTRY_LASTMOD
bigint not null, FSENTRY_LENGTH bigint not null)

I'm not sure where I should start looking for faults, and I wasn't able to
find any previous useful postings regarding this error so any help would be
appreciated.

TIA.
// JHB
http://linkedin.com/janhelgebergesen
Sent from: Bergen Hordaland Norway.

--001636920027eafa2c046323b925--