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/>