BundleDbPersistenceManager for Oracle Database

[Suganthi Manoharan <su...@gmail.com>]

Hi,
I am using Jackrabbit 1.4 API and Oracle 10g.
BundleDbPersistenceManager(Generic Database) works fine for MySql however
does'nt seem to work fine for Oracle Database. For Oracle Database should we
only use OraclePersistenceManager .

Following is the Persistence Manager configuration.

     <PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager">
           <param name="url" value="jdbc:oracle:thin:@localhost:1521:Suganthi"
/>
           <param name="schemaObjectPrefix" value="lp_jcr_" />
           <param name="bundleCacheSize" value="8" />
           <param name="consistencyCheck" value="false" />
           <param name="minBlobSize" value="4096" />
           <param name="driver" value="oracle.jdbc.driver.OracleDriver" />
           <param name="user" value="system" />
           <param name="password" value="password" />
           <param name="schema" value="oracle" />
           <param name="errorHandling" value="false"/>
           <param name="externalBLOBs" value="false"/>
           <param name="consistencyFix" value="false"/>
     </PersistenceManager>

*Following is the error log *


2010-06-04 09:22:23,011 ERROR [main]
org.apache.jackrabbit.core.RepositoryImpl failed to start Repository: Cannot
instantiate persistence manager
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager:
null
javax.jcr.RepositoryException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager:
null: null
at
org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1163)
at
org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:383)
at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:293)
at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:550)
at
org.apache.jackrabbit.core.jndi.BindableRepository.createRepository(BindableRepository.java:174)
at
org.apache.jackrabbit.core.jndi.BindableRepository.init(BindableRepository.java:138)
at
org.apache.jackrabbit.core.jndi.BindableRepository.create(BindableRepository.java:125)
at
org.apache.jackrabbit.core.jndi.BindableRepositoryFactory.createInstance(BindableRepositoryFactory.java:59)
at
org.apache.jackrabbit.core.jndi.BindableRepositoryFactory.getObjectInstance(BindableRepositoryFactory.java:81)
at
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:140)
at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at
org.apache.naming.NamingContextBindingsEnumeration.nextElementInternal(NamingContextBindingsEnumeration.java:113)
at
org.apache.naming.NamingContextBindingsEnumeration.next(NamingContextBindingsEnumeration.java:71)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:137)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:144)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.createMBeans(GlobalResourcesLifecycleListener.java:109)
at
org.apache.catalina.mbeans.GlobalResourcesLifecycleListener.lifecycleEvent(GlobalResourcesLifecycleListener.java:81)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:693)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.lang.NullPointerException
at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.java:870)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1117)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1278)
at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1855)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1820)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.checkSchema(BundleDbPersistenceManager.java:439)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.init(BundleDbPersistenceManager.java:565)
at
org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1159)
... 27 more