jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Meenakshi Khatri <mkhatrij...@gmail.com>
Subject Re: Facing error when running Jackrabbit with Postgres + Jboss
Date Fri, 20 Aug 2010 13:37:44 GMT
Hi Thomas,

Thanks for your reply. I did made those changes, and one of the error
disappeared. [ERROR: type "varbinary" does not exist] But I still get a
warning message:

*WARN  [org.apache.jackrabbit.core.util.db.ConnectionFactory] (main) Failed
to guess validation query for URL jdbc:postgresql://localhost:5432/database*

In my postgres-ds.xml file which is inside jboss/server/default/deploy
folder, My settings are as follows:


> <datasources>
>   <local-tx-datasource>
>     <jndi-name>DefaultDS</jndi-name>
>
> <connection-url>jdbc:postgresql://localhost:5432/database</connection-url>
>     <driver-class>org.postgresql.Driver</driver-class>
>     <user-name>username</user-name>
>     <password>password</password>
> *    <new-connection-sql>select 1</new-connection-sql>
>  <check-valid-connection-sql>select 1</check-valid-connection-sql>*
>  <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
> (optional) -->
>  <metadata>
>  <type-mapping>PostgreSQL 8.0</type-mapping>
>  </metadata>
>   </local-tx-datasource>
> </datasources>

I assume that when we switch from derby to postgres, Jackrabbit's repository
file should automatically create the tables in the database. But, I dont see
any tables in my database. I do see that jackrabbit connects to Postgres
properly


> *WARN  [ConnectionFactory] Failed to guess validation query for URL
> jdbc:postgresql://localhost:5432/factsheet*
> INFO  [NodeTypeRegistry] no custom node type definitions found
> INFO  [DatabasePersistenceManager] Database: PostgreSQL / 8.4.4
> INFO  [DatabasePersistenceManager] Driver: PostgreSQL Native Driver /
> PostgreSQL 8.4 JDBC4 (build 701)
> INFO  [RepositoryImpl] initializing workspace 'default'...
> INFO  [DatabasePersistenceManager] Database: PostgreSQL / 8.4.4
> INFO  [DatabasePersistenceManager] Driver: PostgreSQL Native Driver /
> PostgreSQL 8.4 JDBC4 (build 701)
> INFO  [LocalFileSystem] LocalFileSystem initialized at path
> \jackrabbit\workspaces\default\blobs
> INFO  [SearchIndex] Index initialized: /jackrabbit/repository/index
> Version: 3
> INFO  [SearchIndex] Index initialized: \jackrabbit\workspaces\default/index
> Version: 3
> INFO  [RepositoryImpl] workspace 'default' initialized
> INFO  [RepositoryImpl] Repository started
> INFO  [TransientRepository] Transient repository initialized
> INFO  [RepositoryImpl] initializing workspace 'security'...
> INFO  [DatabasePersistenceManager] Database: PostgreSQL / 8.4.4
> INFO  [DatabasePersistenceManager] Driver: PostgreSQL Native Driver /
> PostgreSQL 8.4 JDBC4 (build 701)
> INFO  [LocalFileSystem] LocalFileSystem initialized at path
> \jackrabbit\workspaces\security\blobs
> INFO  [SearchIndex] Index initialized:
> \jackrabbit\workspaces\security/index Version: 3
> INFO  [RepositoryImpl] workspace 'security' initialized
>

I think that my <param name="schemaObjectPrefix" value="public" /> field is
not defined properly.

Could you please help me on this?

Thanks & Regards,
Meenakshi

On Thu, Aug 19, 2010 at 10:19 AM, Thomas Müller <thomas.mueller@day.com>wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message