Apology for the very late reply - some how this completely skipped our
radar.
FWIW, it is a known issue with missing trigger in Oracle auto-DB creation
(due to table name prefix being too long), so you need to create by it
yourself (or use a shorter prefix):
create trigger DEFAULT_t1
before insert on DEFAULT_NAMES
for each row begin
select DEFAULT_seq_names_id.nextval into :new.id from dual;
end;
http://issues.apache.org/jira/browse/JCR-936 has more details on this.
HTH,
Yoav
On Thu, Jan 28, 2010 at 7:24 PM, GreggCarrier <[email protected]>wrote:
>
> Artifactory 2.1.3
> Oracle 10.2.0.4
> running as a war in Tomcat 6
> RHEL 4
>
> I configured repo.xml with my JDBC settings, set the ARTIFACTORY_HOME, and
> started it up. I'm pretty sure all is well there because Artifactory did
> connect to my empty db and create tables and some rows. But then it hit an
> error trying to insert null. Stack trace below. Anyone have any ideas what
> the problem is here?
>
> Thanks for any help.
>
> Gregg
>
> 2010-01-28 08:49:38,802 [main] [ERROR]
> (o.a.j.c.p.b.u.ConnectionRecoveryManager:453) - could not execute
> statement,
> reason: ORA-01400: cannot insert NULL into
> ("ARTIFACTORY"."DEFAULT_NAMES"."ID")
> , state/code: 23000/1400
> 2010-01-28 08:49:43,741 [main] [ERROR]
> (o.a.j.c.p.b.BundleDbPersistenceManager:1250) - failed to write bundle:
> cafebabe-cafe-babe-cafe-babecafebabe
> java.lang.IllegalStateException: Unable to insert index for string: root
> at
>
> org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:63)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.stringToIndex(DbNameIndex.java:98)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writeBundle(BundleBinding.java:272)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1242)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:736)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:676)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:540)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:568)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.state.SharedItemStateManager.createRootNodeState(SharedItemStateManager.java:1326)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.state.SharedItemStateManager.<init>(SharedItemStateManager.java:204)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.RepositoryImpl.createItemStateManager(RepositoryImpl.java:1353)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:1948)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1919)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:489)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:330)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:627)
> [jackrabbit-core-jfrog-1.6.0.jar:1.6.0]
> at
>
> org.artifactory.jcr.JcrRepoInitStrategy.createJcrRepository(JcrRepoInitStrategy.java:103)
> [artifactory-core-2.1.3.jar:na]
> at
>
> org.artifactory.jcr.JcrServiceImpl.initJcrRepository(JcrServiceImpl.java:718)
> [artifactory-core-2.1.3.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> [na:1.6.0_10-rc2]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> [na:1.6.0_10-rc2]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> [na:1.6.0_10-rc2]
> at java.lang.reflect.Method.invoke(Unknown Source) [na:1.6.0_10-rc2]
> at
>
> org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:297)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:250)
> [spring-beans-2.5.6.jar:2.5.6] at
>
> org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:144)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:350)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1331)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> [spring-beans-2.5.6.jar:2.5.6]
> at java.security.AccessController.doPrivileged(Native Method)
> [na:1.6.0_10-rc2]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:412)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessAfterInstantiation(AutowiredAnnotationBeanPostProcessor.java:240)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> [spring-beans-2.5.6.jar:2.5.6]
> at java.security.AccessController.doPrivileged(Native Method)
> [na:1.6.0_10-rc2]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:412)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessAfterInstantiation(AutowiredAnnotationBeanPostProcessor.java:240)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> [spring-beans-2.5.6.jar:2.5.6]
> at java.security.AccessController.doPrivileged(Native Method)
> [na:1.6.0_10-rc2]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:412)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessAfterInstantiation(AutowiredAnnotationBeanPostProcessor.java:240)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> [spring-beans-2.5.6.jar:2.5.6]
> at java.security.AccessController.doPrivileged(Native Method)
> [na:1.6.0_10-rc2]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:412)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessAfterInstantiation(AutowiredAnnotationBeanPostProcessor.java:240)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
> [spring-beans-2.5.6.jar:2.5.6]
> at java.security.AccessController.doPrivileged(Native Method)
> [na:1.6.0_10-rc2]
> at
>
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
> [spring-beans-2.5.6.jar:2.5.6]
> at
>
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
> [spring-context-2.5.6.jar:2.5.6]
> at
>
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
> [spring-context-2.5.6.jar:2.5.6]
> at
>
> org.artifactory.spring.ArtifactoryApplicationContext.refresh(ArtifactoryApplicationContext.java:194)
> [artifactory-core-2.1.3.jar:na]
> at
>
> org.artifactory.spring.ArtifactoryApplicationContext.<init>(ArtifactoryApplicationContext.java:101)
> [artifactory-core-2.1.3.jar:na]
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method) [na:1.6.0_10-rc2]
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> Source) [na:1.6.0_10-rc2]
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
> Source) [na:1.6.0_10-rc2]
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> [na:1.6.0_10-rc2]
> at
>
> org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.configure(ArtifactoryContextConfigListener.java:110)
> [artifactory-web-application-2.1.3.jar:na]
> at
>
> org.artifactory.webapp.servlet.ArtifactoryContextConfigListener.contextInitialized(ArtifactoryContextConfigListener.java:57)
> [artifactory-web-application-2.1.3.jar:na]
> at
>
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
> [catalina.jar:na]
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
> [catalina.jar:na]
> at
>
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> [catalina.jar:na]
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> [catalina.jar:na]
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> [catalina.jar:na]
>
> --
> View this message in context:
> http://old.nabble.com/problem-starting-Artifactory-with-Oracle-tp27358552p27358552.html
> Sent from the Artifactory-Users mailing list archive at Nabble.com.
>
>
>
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the
> business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Artifactory-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/artifactory-users
>
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Artifactory-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/artifactory-users
