[Building Sakai] sakai trunk with oracle
Mustansar Mehmood
mustansar at rice.edu
Wed Sep 23 11:39:52 PDT 2009
Hi,
I am trying to setup sakai trunk instance for some development. I
am using Oracle as a the Database server. When I try to start the
instance with auto ddl true I get long list of errors and server doesn't
start. The error that repeats the most is
"nested exception is java.sql.SQLException: ORA-01031: insufficient
privileges"
Any pointers to get past this error?
I have pasted part of the catalina.out Thanks!
2009-09-23 13:35:23,121 ERROR main
org.sakaiproject.util.NoisierDefaultListableBeanFactory - Failed to
preinstantiate the singleton named
org.sakaiproject.emailtemplateservice.service.EmailTemplateService.
Destroying all Spring beans.
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name
'org.sakaiproject.emailtemplateservice.service.EmailTemplateService'
defined in file
[/home/sakai27/appServer/apache-tomcat-5.5.28/components/emailtemplateservice-pack/WEB-INF/components.xml]:
Cannot resolve reference to bean
'org.sakaiproject.entitybroker.DeveloperHelperService' while setting
bean property 'developerHelperService'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'org.sakaiproject.entitybroker.DeveloperHelperService'
defined in file
[/home/sakai27/appServer/apache-tomcat-5.5.28/components/entitybroker-pack/WEB-INF/components.xml]:
Cannot resolve reference to bean
'org.sakaiproject.entitybroker.EntityBroker' while setting bean property
'entityBroker'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'org.sakaiproject.entitybroker.EntityBroker' defined in
file
[/home/sakai27/appServer/apache-tomcat-5.5.28/components/entitybroker-pack/WEB-INF/components.xml]:
Cannot resolve reference to bean
'org.sakaiproject.entitybroker.impl.EntityMetaPropertiesService' while
setting bean property 'propertiesProvider'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name
'org.sakaiproject.entitybroker.impl.EntityMetaPropertiesService' defined
in file
[/home/sakai27/appServer/apache-tomcat-5.5.28/components/entitybroker-pack/WEB-INF/components.xml]:
Cannot resolve reference to bean
'org.sakaiproject.entitybroker.dao.EntityBrokerDao' while setting bean
property 'dao'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'org.sakaiproject.entitybroker.dao.EntityBrokerDao'
defined in file
[/home/sakai27/appServer/apache-tomcat-5.5.28/components/entitybroker-pack/WEB-INF/spring-jdbc.xml]:
Cannot resolve reference to bean
'org.sakaiproject.entitybroker.dao.impl.EntityBrokerDaoTarget' while
setting bean property 'target'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name
'org.sakaiproject.entitybroker.dao.impl.EntityBrokerDaoTarget' defined
in file
[/home/sakai27/appServer/apache-tomcat-5.5.28/components/entitybroker-pack/WEB-INF/spring-jdbc.xml]:
Invocation of init method failed; nested exception is
org.springframework.beans.factory.BeanInitializationException:
Initialization of DAO failed; nested exception is
java.lang.IllegalArgumentException: Failed while executing ddl:
StatementCallback; bad SQL grammar [create trigger bef_ins_ENTITYTAGAPPS
before insert on ENTITY_TAG_APPLICATIONS for each row begin select
seq_ID_ENTITY_TAG_APPLICATIONS.nextval into :new.id from dual; end];
nested exception is java.sql.SQLException: ORA-01031: insufficient
privileges
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at
org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:114)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at
org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:73)
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at
org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:147)
at
org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:68)
at
org.sakaiproject.component.impl.ContextLoader.loadParentContext(ContextLoader.java:107)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:195)
at
org.sakaiproject.component.impl.ContextLoader.initWebApplicationContext(ContextLoader.java:64)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at
org.sakaiproject.util.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:56)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3795)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4252)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1150)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.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:448)
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(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
--
Mustansar Mehmood
Educational System Developer& Integrator
Infromation Technology
6100 Main St MS 119
Houston Texas 77005
Phone:(713)348-2523
Fax :(713)348 6099
email:mustansar at rice.edu
I have yet to see any problem, however complicated, which, when,you looked at it in the right way, did not become still more complicated.
-- Poul Anderson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090923/ca0ba650/attachment.html
More information about the sakai-dev
mailing list