jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Müller <thomas.muel...@day.com>
Subject Re: Facing error when running Jackrabbit with Postgres + Jboss
Date Thu, 19 Aug 2010 08:19:32 GMT
Hi,

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

Regards,
Thomas

On Wed, Aug 18, 2010 at 5:54 PM, Meenakshi Khatri <mkhatrijava@gmail.com> wrote:
> 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, Jboss
> is able to set the Postgres JNDI name properly.
>
> I was searching thru the mailing list of Jackrabbit but I hardly came across
> 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.
>
>
>>  INFO  [org.apache.jackrabbit.core.RepositoryImpl] (main) Starting
>> repository...
>> *WARN  [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) Failed
>> to execute SQL (stacktrace on DEBUG log level)
>> org.postgresql.util.PSQLException: ERROR: type "varbinary" does not exist*
>>   Position: 98
>>  at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>>  at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
>>  at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>>  at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
>>  at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
>>  at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
>>  at
>> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
>>  at
>> 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>
>>  <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
>>   <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>  </FileSystem>
>>
>>  <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
>>   <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>   <param name="databaseType" value="postgresql"/>
>>  </DataStore>
>>
>>   <SecurityManager
>> class="org.apache.jackrabbit.core.security.simple.SimpleSecurityManager"
>> workspaceName="security">
>>   </SecurityManager>
>>
>>   <AccessManager
>> class="org.apache.jackrabbit.core.security.simple.SimpleAccessManager">
>>    <!-- <param name="config" value="${rep.home}/access.xml"/> -->
>>   </AccessManager>
>>
>>   <LoginModule
>> class="org.apache.jackrabbit.core.security.simple.SimpleLoginModule">
>>    <param name="anonymousId" value="anonymous"/>
>>    <param name="adminId" value="admin"/>
>>   </LoginModule>
>>  </Security>
>>
>>  <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>
>>  <Workspace name="${wsp.name}">
>>   <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
>>    <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>   </FileSystem>
>>
>   <PersistenceManager
>> class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
>>    <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>    <param name="schema" value="postgresql"/>
>>    <param name="schemaObjectPrefix" value="public" />
>>    <param name="externalBLOBs" value="false"/>
>>   </PersistenceManager>
>>
>>   <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
>>    <param name="path" value="${wsp.home}/index"/>
>>    <param name="supportHighlighting" value="true"/>
>>   </SearchIndex>
>>  </Workspace>
>>
>>  <Versioning rootPath="${rep.home}/version">
>>   <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
>>    <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>   </FileSystem>
>>
>>   <PersistenceManager
>> class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
>>    <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>    <param name="schema" value="postgresql"/>
>>    <param name="schemaObjectPrefix" value="public" />
>>    <param name="externalBLOBs" value="false"/>
>>   </PersistenceManager>
>>
>>  </Versioning>
>>
>>  <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
>>   <param name="path" value="${rep.home}/repository/index"/>
>>   <param name="supportHighlighting" value="true"/>
>>  </SearchIndex>
>> </Repository>
>>
>
> Also, I read somewhere in one of the mailing list that I need to change even
> workspace.xml file so my workspace.xml file inside /workspace/default folder
> and /workspace/security folder looks like this
>
>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <Workspace name="default">
>>
>>  <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
>>    <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>  </FileSystem>
>>
>>   <PersistenceManager
>> class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
>>     <param name="driver" value="org.postgresql.Driver"/>
>>   <param name="url" value="jdbc:postgresql://localhost:5432/database"/>
>>   <param name="user" value="username"/>
>>   <param name="password" value="password"/>
>>     <param name="schema" value="postgresql"/>
>>   </PersistenceManager>
>>
>>         <SearchIndex
>> class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
>>             <param name="path" value="${wsp.home}/index"/>
>>             <param name="extractorPoolSize" value="2"/>
>>             <param name="supportHighlighting" value="true"/>
>>         </SearchIndex>
>>     </Workspace>
>>
>
> Can someone please help me and guide me on how to solve this problem? What
> am I missing ?
>
> Thanks in advace,
>
> Meenakshi
>

Mime
View raw message