Hello

 

I’m using the following DataStore settings. After I start Jackrabbit the second time I get an exception.

     <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">

        <param name="url" value="jdbc:postgresql:repo"/>

        <param name="user" value=".."/>

        <param name="password" value=".."/>

        <param name="databaseType" value="postgresql"/>

        <param name="driver" value="org.postgresql.Driver"/>

        <param name="minRecordLength" value="1024"/>

        <param name="maxConnections" value="3"/>

        <param name="copyWhenReading" value="true"/>

        <param name="tablePrefix" value="rep_"/>

       <param name="schemaObjectPrefix" value=""/>

    </DataStore>

 

org.postgresql.util.PSQLException: ERROR: relation "rep_datastore" already exists

      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)

      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)

      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)

      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)

      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)

      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)

      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:365)

      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:292)

      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:257)

      at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:237)

      at org.apache.jackrabbit.core.data.db.DbDataStore.init(DbDataStore.java:491)

      at org.apache.jackrabbit.core.RepositoryImpl.createDataStore(RepositoryImpl.java:662)

      at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:271)

      at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:557)

 

 

This behavior only occurs if “tablePrefix” is set, if I leave it blank everything works fine.

Should I report a bug?

 

Grüsse aus Beckenried

Flavio Donzé, Software Engineer

 

SCODi 4P

henzler informatik gmbh
Teichstrasse 7

CH-4106 Therwil

Phone +41 (0)41 9110522

Web        www.scodi.ch