I'm having some issues setting up an oracle 9 bundle persistence manager;
Am getting the following exception;
13:55:21,856 WARN OraclePersistenceManager - Unsupported driver version
detected: Oracle JDBC driver v9.2.0.3.0
13:55:24,970 ERROR ConnectionRecoveryManager - could not execute statement,
reason: ORA-00942: table or view does not exist
, state/code: 42000/942
13:55:26,663 ERROR Oracle9PersistenceManager - failed to write bundle:
deadbeef-face-babe-cafe-babecafebabe
java.lang.IllegalStateException: Unable to read index:
java.sql.SQLException: ORA-00942: table or view does not exist
at
org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.getIndex(DbNameIndex.java:173)
at
org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.stringToIndex(DbNameIndex.java:99)
at
org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writeBundle(BundleBinding.java:258)
at
org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceManager.storeBundle(Oracle9PersistenceManager.java:118)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:703)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:643)
Yet, I've configured the oracle9 persistence manager. My assumption is that
the exception is due to the oracle persistence manager closing the
connection.
My repository.xml file is as follows;
<?xml version="1.0" encoding="ISO-8859-1"?>
<Repository>
<DataStore class="org.apache.jackrabbit.core.data.FileDataStore">
<param name="path" value="${rep.home}/repository/datastore"/>
<param name="minRecordLength" value="100"/>
</DataStore>
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/repository"/>
</FileSystem>
<Security appName="Jackrabbit">
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager"/>
<LoginModule
class="com.netenviron.security.jaas.WebappLoginModule">
<param name="anonymousId" value="anonymous"/>
</LoginModule>
</Security>
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"
/>
<Workspace name="${wsp.name}">
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceManager">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url"
value="java:comp/env/jdbc/JcrRepositoryDataSource"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
</PersistenceManager>
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
<param name="autoRepair" value="true"/>
<param name="analyzer"
value="org.apache.lucene.analysis.standard.StandardAnalyzer"/>
<param name="textFilterClasses"
value="org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceManager">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url"
value="java:comp/env/jdbc/JcrRepositoryDataSource"/>
<param name="schemaObjectPrefix" value="version_"/>
</PersistenceManager>
</Versioning>
</Repository>
Can there be a bug somewhere in that the wrong oracle persistence manager is
instantiated?
--
-Tor
