Hi,

Today I managed to get Jackrabbit 1.3 working with Oracle 9i, and all looked
good.
I then tried doing the same with Jackrabbit 1.4, but get the exception
below.

ORA-01400: cannot insert NULL into ("DICE_DBO"."DEFAULT_NAMES"."ID")

        at
org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.ins
ertString(NGKDbNameIndex.java:71)
        at
org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.string
ToIndex(DbNameIndex.java:101)
        at
org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writ
eBundle(BundleBinding.java:249)
        at
org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceManag
er.storeBundle(Oracle9PersistenceManager.java:118)
        at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersisten
ceManager.putBundle(AbstractBundlePersistenceManager.java:703)
        at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersisten
ceManager.store(AbstractBundlePersistenceManager.java:643)
        at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceMana
ger.store(BundleDbPersistenceManager.java:524)
        at
org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNod
eState(SharedItemStateManager.java:1068)
        at
org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(Shared
ItemStateManager.java:193)
        at
org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(Repo
sitoryImpl.java:1188)
        at
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(
RepositoryImpl.java:1739)
        at
org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(Re
positoryImpl.java:1710)
        at
org.apache.jackrabbit.core.RepositoryImpl.initWorkspace(RepositoryImp
l.java:569)
        at
org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(Repos
itoryImpl.java:408)
        at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:
304)
        at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:
550)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.createRepository(
RepositoryStartupServlet.java:439)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.initRepository(Re
positoryStartupServlet.java:407)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.startup(Repositor
yStartupServlet.java:238)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.init(RepositorySt
artupServlet.java:211)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1139)
        at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:96
6)
        at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3956)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4
230)
        at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:760)
        at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:74
0)
        at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)

        at
org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)

        at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714
)
        at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490
)
        at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:311)
        at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:120)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)

        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:4
48)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:700
)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
22.01.2008 17:14:07 *ERROR* BundleDbPersistenceManager: rollback failed
(BundleDbPersistenceManager.java, line 1244)

To get to this point I deployed the webapp in Tomcat, create a repo called
Jackrabbit with the default settings, then deleted the default workspace
folder, and replaced the FileSystem and PersistenceManager portions of
jackrabbit/repository.xml with the following:

    <FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
       
       
       
       
    </FileSystem>

        <!--
            persistence manager of the workspace:
            class: FQN of class implementing the PersistenceManager
interface
        -->
    <PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceManager">
       
       
       
       
       
       
       
       
    </PersistenceManager>

I'm pretty sure this is user error rather than a bug, can anyone confirm
this? If so, what is the correct procedure for creating an Oracle-backed
repository/workspace?

I also noticed the following warning in the log:

22.01.2008 17:14:07 *WARN * OraclePersistenceManager: Unsupported driver
version
 detected: Oracle JDBC driver v9.2.0.1.0 (OraclePersistenceManager.java,
line 12
1)

Could this be relevant? I don't remember seeing this with v1.3.3

Thanks,

Jim
-- 
View this message in context: 
http://www.nabble.com/Failed-to-create-repository-with-Jackrabbit-1.4-and-Oracle-tp15024570p15024570.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Reply via email to