Is Labs 3 Stable supports Oracle database?

[ramakmeenavilli]

Hi,

Can I know is Alfresco Labs 3 Stable supports Oracle database or not?

If YES then.. I am facing the following error please give necessary stepts to resolve it.

12:42:45,763 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
12:42:47,761 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [D:\Data\Alfresco Lab 3 Stable\alfresco-labs-tomcat-3Stable\tomcat\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [D:\Data\Alfresco Lab 3 Stable\alfresco-labs-tomcat-3Stable\tomcat\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [D:\Data\Alfresco Lab 3 Stable\alfresco-labs-tomcat-3Stable\tomcat\shared\classes\alfresco\extension\custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
   at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)
   at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)
   at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)
   at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
   at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
   at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)
   … 57 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
   at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
   at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
   at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
   at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
   at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)
   … 58 more
Caused by: java.io.IOException: Could not find resource alfresco/activities/org.hibernate.dialect.Oracle9Dialect/ActivityPost.xml
   at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)
   at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)
   at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)
   at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
   … 62 more
12:42:58,551 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework

thanks&regards
Rama

[ramakmeenavilli]

pls. reply….

——
Rama

[junderwood]

This worked for me:


Possible need for error "Could not find resource ActivityPost.xml":
Deleting the following files from the tomcat/shared/classes/alfresco/extension folder will allow you to get around the error message

custom-activities-feed-context.xml
custom-activities-SqlMapConfig.xml

Also ,
Override the following Hibernate property in your custom-hibernate-dialect.properties:
hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9iDialect

[mpecero]

Hello

We have deleted the files that you have commented and we have set hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9iDialect in our custom-hibernate-dialect.properties, but the next error appears when we start Tomcat:

17:23:40,492  ERROR [domain.schema.SchemaBootstrap] Actualización automática de esquema fallida
org.alfresco.error.AlfrescoRuntimeException: El esquema de la escritura no se pudo encontrar en la ubicación classpath:alfresco/dbscripts/upgrade/2.2/${db.script.dialect}/upgrade-from-2.2SP1.sql

The file alfresco/dbscripts/upgrade/2.2/org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9iDialect/upgrade-from-2.2SP1.sql does not exist in Alfresco 3 Stable. It seem that Alfresco Labs 3 does not support Oracle database.

could you help us?
Thank you,
Maxi

[shilpa]

Hello,

Canh someone tell me which is the latest version of Alfresco. Also, when can I expect the next release?

[midhun]

shilpa,
I guess alfresco 3.0  is the latest  stable community  edition
:idea:  Midhun

[shilpa]

Thanks so much. Where can I get the new features added in 3.0. Also, I need to know about its benefits as in how far is it different from the earlier version.

[midhun]

http://blogs.alfresco.com/wp/opentalk/'>
http://blogs.alfresco.com/wp/opentalk/

Hope this will solve all your  questions.Let me know if this information was  usefull

[shilpa]

Yes, it is. Thanks

[lakk99]

Any luck on installing alfresco as oracle backend.I am getting same error.