jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Flavio Donzé <...@scodi.ch>
Subject Database Datastore "tablePrefix"
Date Wed, 25 Mar 2009 16:20:32 GMT
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<http://www.scodi.ch/>


Mime
View raw message