Return-Path: 
 <users-return-15890-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 22649 invoked from network); 19 Aug 2010 08:20:13 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 19 Aug 2010 08:20:13 -0000
Received: (qmail 80330 invoked by uid 500); 19 Aug 2010 08:20:13 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 80062 invoked by uid 500); 19 Aug 2010 08:20:10 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 80053 invoked by uid 99); 19 Aug 2010 08:20:09 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Aug 2010 08:20:09 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of tmueller@day.com designates
 207.126.148.85 as permitted sender)
Received: from [207.126.148.85] (HELO psmtp.com) (207.126.148.85)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 19 Aug 2010 08:20:02 +0000
Received: from source ([209.85.216.42]) by eu3sys201aob102.postini.com
 ([207.126.154.11]) with SMTP
	ID DSNKTGzpG9p2uCkxdes1dzn3BLTAhFwlfENc@postini.com;
 Thu, 19 Aug 2010 08:19:41 UTC
Received: by qwb8 with SMTP id 8so1541155qwb.29
        for <users@jackrabbit.apache.org>;
 Thu, 19 Aug 2010 01:19:38 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.224.19.200 with SMTP id c8mr6308722qab.70.1282205972508; Thu,
 19 Aug 2010 01:19:32 -0700 (PDT)
Received: by 10.229.22.21 with HTTP; Thu, 19 Aug 2010 01:19:32 -0700 (PDT)
In-Reply-To: <AANLkTi=sdQXUtNdeyp1=Ga6P-uYDfxS02gW7FpU4baPU@mail.gmail.com>
References: <AANLkTi=sdQXUtNdeyp1=Ga6P-uYDfxS02gW7FpU4baPU@mail.gmail.com>
Date: Thu, 19 Aug 2010 10:19:32 +0200
Message-ID: <AANLkTikqKj=kiF1SgUzVWeP=xmZmzyGXeO5OcmwmO0O2@mail.gmail.com>
Subject: Re: Facing error when running Jackrabbit with Postgres + Jboss
From: =?ISO-8859-1?Q?Thomas_M=FCller?= <thomas.mueller@day.com>
To: users@jackrabbit.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

In the FileSystem entry, you need add:
<param name=3D"schema" value=3D"postgresql"/>

Regards,
Thomas

On Wed, Aug 18, 2010 at 5:54 PM, Meenakshi Khatri <mkhatrijava@gmail.com> w=
rote:
> Hello everyone,
>
> I am a beginner with Jackrabbit and am currently replacing Derby with
> Postgres 8.4
>
> I was initially facing errors with Jboss but after making the change, Jbo=
ss
> is able to set the Postgres JNDI name properly.
>
> I was searching thru the mailing list of Jackrabbit but I hardly came acr=
oss
> any dicsussion which might help me solve this problem.
>
> I have made the necessary changes in my repository.xml file but I get the
> following error when I run my application with Jboss.
>
>
>> =A0INFO =A0[org.apache.jackrabbit.core.RepositoryImpl] (main) Starting
>> repository...
>> *WARN =A0[org.apache.jackrabbit.core.util.db.ConnectionFactory] (main)
>> Failed to guess validation query for URL
>> jdbc:postgresql://localhost:5432/database*
>
> * ERROR [org.apache.jackrabbit.core.util.db.ConnectionHelper] (main) Fail=
ed
>> to execute SQL (stacktrace on DEBUG log level)
>> org.postgresql.util.PSQLException: ERROR: type "varbinary" does not exis=
t*
>> =A0 Position: 98
>> =A0at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu=
torImpl.java:2062)
>> =A0at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp=
l.java:1795)
>> =A0at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:=
257)
>> =A0at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme=
nt.java:479)
>> =A0at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb=
c2Statement.java:353)
>> =A0at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme=
nt.java:345)
>> =A0at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.=
java:264)
>> =A0at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.=
java:264)
>
> .....
>
> I have made the following changes in the repository.xml file to replace
> Derby with Postgres.
>
>> <Repository>
>> =A0<FileSystem class=3D"org.apache.jackrabbit.core.fs.db.DbFileSystem">
>> =A0 <param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0</FileSystem>
>>
>> =A0<DataStore class=3D"org.apache.jackrabbit.core.data.db.DbDataStore">
>> =A0 <param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0 <param name=3D"databaseType" value=3D"postgresql"/>
>> =A0</DataStore>
>>
>> =A0 <SecurityManager
>> class=3D"org.apache.jackrabbit.core.security.simple.SimpleSecurityManage=
r"
>> workspaceName=3D"security">
>> =A0 </SecurityManager>
>>
>> =A0 <AccessManager
>> class=3D"org.apache.jackrabbit.core.security.simple.SimpleAccessManager"=
>
>> =A0 =A0<!-- <param name=3D"config" value=3D"${rep.home}/access.xml"/> --=
>
>> =A0 </AccessManager>
>>
>> =A0 <LoginModule
>> class=3D"org.apache.jackrabbit.core.security.simple.SimpleLoginModule">
>> =A0 =A0<param name=3D"anonymousId" value=3D"anonymous"/>
>> =A0 =A0<param name=3D"adminId" value=3D"admin"/>
>> =A0 </LoginModule>
>> =A0</Security>
>>
>> =A0<Workspaces rootPath=3D"${rep.home}/workspaces" defaultWorkspace=3D"d=
efault"/>
>> =A0<Workspace name=3D"${wsp.name}">
>> =A0 <FileSystem class=3D"org.apache.jackrabbit.core.fs.db.DbFileSystem">
>> =A0 =A0<param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0 </FileSystem>
>>
> =A0 <PersistenceManager
>> class=3D"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceMa=
nager">
>> =A0 =A0<param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0 =A0<param name=3D"schema" value=3D"postgresql"/>
>> =A0 =A0<param name=3D"schemaObjectPrefix" value=3D"public" />
>> =A0 =A0<param name=3D"externalBLOBs" value=3D"false"/>
>> =A0 </PersistenceManager>
>>
>> =A0 <SearchIndex class=3D"org.apache.jackrabbit.core.query.lucene.Search=
Index">
>> =A0 =A0<param name=3D"path" value=3D"${wsp.home}/index"/>
>> =A0 =A0<param name=3D"supportHighlighting" value=3D"true"/>
>> =A0 </SearchIndex>
>> =A0</Workspace>
>>
>> =A0<Versioning rootPath=3D"${rep.home}/version">
>> =A0 <FileSystem class=3D"org.apache.jackrabbit.core.fs.db.DbFileSystem">
>> =A0 =A0<param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0 </FileSystem>
>>
>> =A0 <PersistenceManager
>> class=3D"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceMa=
nager">
>> =A0 =A0<param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0 =A0<param name=3D"schema" value=3D"postgresql"/>
>> =A0 =A0<param name=3D"schemaObjectPrefix" value=3D"public" />
>> =A0 =A0<param name=3D"externalBLOBs" value=3D"false"/>
>> =A0 </PersistenceManager>
>>
>> =A0</Versioning>
>>
>> =A0<SearchIndex class=3D"org.apache.jackrabbit.core.query.lucene.SearchI=
ndex">
>> =A0 <param name=3D"path" value=3D"${rep.home}/repository/index"/>
>> =A0 <param name=3D"supportHighlighting" value=3D"true"/>
>> =A0</SearchIndex>
>> </Repository>
>>
>
> Also, I read somewhere in one of the mailing list that I need to change e=
ven
> workspace.xml file so my workspace.xml file inside /workspace/default fol=
der
> and /workspace/security folder looks like this
>
>
>> <?xml version=3D"1.0" encoding=3D"UTF-8"?>
>> <Workspace name=3D"default">
>>
>> =A0<FileSystem class=3D"org.apache.jackrabbit.core.fs.db.DbFileSystem">
>> =A0 =A0<param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0</FileSystem>
>>
>> =A0 <PersistenceManager
>> class=3D"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceMa=
nager">
>> =A0 =A0 <param name=3D"driver" value=3D"org.postgresql.Driver"/>
>> =A0 <param name=3D"url" value=3D"jdbc:postgresql://localhost:5432/databa=
se"/>
>> =A0 <param name=3D"user" value=3D"username"/>
>> =A0 <param name=3D"password" value=3D"password"/>
>> =A0 =A0 <param name=3D"schema" value=3D"postgresql"/>
>> =A0 </PersistenceManager>
>>
>> =A0 =A0 =A0 =A0 <SearchIndex
>> class=3D"org.apache.jackrabbit.core.query.lucene.SearchIndex">
>> =A0 =A0 =A0 =A0 =A0 =A0 <param name=3D"path" value=3D"${wsp.home}/index"=
/>
>> =A0 =A0 =A0 =A0 =A0 =A0 <param name=3D"extractorPoolSize" value=3D"2"/>
>> =A0 =A0 =A0 =A0 =A0 =A0 <param name=3D"supportHighlighting" value=3D"tru=
e"/>
>> =A0 =A0 =A0 =A0 </SearchIndex>
>> =A0 =A0 </Workspace>
>>
>
> Can someone please help me and guide me on how to solve this problem? Wha=
t
> am I missing ?
>
> Thanks in advace,
>
> Meenakshi
>