Deploying Alfresco 1.2 on Oracle App Server 10g

[ecarballo]

Does anyone have details on how to install alfresco 1.2  on Oracle 10g App server (OC4J)?

[gavinc]

If you take the WAR file from the Tomcat bundle it should be deployable on any appserver. The only thing you will need is to add the MySQL/Oracle JDBC driver to the appropriate location for the appserver to pick it up.

Someone has gotten a previous version of Alfresco to work with Oracle app server successfully: http://www.alfresco.org/forums/viewtopic.php?t=245

Let us know how you get on.

[ecarballo]

I get the following error in Oracle Enterprise Manager when attempting to deploy the war file:

Failed to deploy web application "alfresco". Failed to deploy web application "alfresco". . The evaluate phase failed. The Adapter used in the evaluate may have thrown an exception.
Resolution:
Please call Oracle support.
Base Exception:
java.lang.UnsupportedClassVersionError
org/alfresco/web/app/ContextListener (Unsupported major.minor version 49.0). org/alfresco/web/app/ContextListener (Unsupported major.minor version 49.0)

[ecarballo]

Disregard error in previous reply as I think it has to do with invalid JDK for the OC4J I was attempting to deploy on.  I have downloaded a standalone version of the latest oc4j which uses JDK 5 and applied  changes as per previous posts regarding hibernate dialect and database connection parameters.  On deploying the war file, i see some Alfresco tables are successfully created.  However, I got the following errors.  Please advice.


—————————-ERROR 1——————————————
Could not retrieve remote events: Error deserializing return-value: org.springframework.beans.factory.BeanCreationException; nested exception is: java.lang.ClassNotFoundException: org.springframework.beans.factory.BeanCreationException

Supplemental Text



java.rmi.UnmarshalException: Error deserializing return-value: org.springframework.beans.factory.BeanCreationException; nested exception is: java.lang.ClassNotFoundException: org.springframework.beans.factory.BeanCreationException at com.evermind.server.rmi.RMICall.EXCEPTION_ORIGINATES_FROM_THE_REMOTE_SERVER(RMICall.java:110) at com.evermind.server.rmi.RMICall.throwRecordedException(RMICall.java:128) at com.evermind.server.rmi.RMIClientConnection.obtainRemoteMethodResponse(RMIClientConnection.java:472) at com.evermind.server.rmi.RMIClientConnection.invokeMethod(RMIClientConnection.java:416) at com.evermind.server.rmi.RemoteInvocationHandler.invoke(RemoteInvocationHandler.java:63) at com.evermind.server.rmi.RecoverableRemoteInvocationHandler.invoke(RecoverableRemoteInvocationHandler.java:28) at com.evermind.server.ejb.StatefulSessionRemoteInvocationHandler.invoke(StatefulSessionRemoteInvocationHandler.java:31) at __Proxy2.getEvents(Unknown Source) at oracle.oc4j.admin.jmx.client.MBeanServerEjbRemoteSynchronizer.getEvents(MBeanServerEjbRemoteSynchronizer.java:530) at oracle.oc4j.admin.jmx.client.CoreRemoteMBeanServer.getEvents(CoreRemoteMBeanServer.java:311) at oracle.oc4j.admin.jmx.client.EventManager.run(EventManager.java:199) at oracle.oc4j.admin.jmx.client.ThreadPool$ConfigurableThreadImpl.run(ThreadPool.java:295) Caused by: java.lang.ClassNotFoundException: org.springframework.beans.factory.BeanCreationException at com.evermind.server.rmi.RMIClassLoader.findClass(RMIClassLoader.java:54) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at com.evermind.io.ClassLoaderObjectInputStream.resolveClass(ClassLoaderObjectInputStream.java:33) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1538) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1460) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1693) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:468) at javax.management.Notification.readObject(Notification.java:350) 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:585) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:919) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1813) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1628) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1293) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:339) at com.evermind.server.rmi.RMIProtocol$Version.unmarshallParameterDirectly(RMIProtocol.java:402) at com.evermind.server.rmi.RMIProtocol$Version_1_0.unmarshallParameter(RMIProtocol.java:471) at com.evermind.server.rmi.RMIProtocol.readObject(RMIProtocol.java:80) at com.evermind.server.rmi.RMIProtocol.readValue(RMIProtocol.java:161) at com.evermind.server.rmi.RMIClientConnection.handleMethodInvocationResponse(RMIClientConnection.java:794) at com.evermind.server.rmi.RMIClientConnection.handleOrmiCommandResponse(RMIClientConnection.java:242) at com.evermind.server.rmi.RMIClientConnection.dispatchResponse(RMIClientConnection.java:197) at com.evermind.server.rmi.RMIClientConnection.processReceivedCommand(RMIClientConnection.java:179) at com.evermind.server.rmi.RMIConnection.handleCommand(RMIConnection.java:154) at com.evermind.server.rmi.RMIConnection.listenForOrmiCommands(RMIConnection.java:126) at com.evermind.server.rmi.RMIConnection.run(RMIConnection.java:105) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:814) at java.lang.Thread.run(Thread.java:595) 


————————–ERRROR 2—————————————–
Message Text



org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userBootstrap' defined in class path resource [alfresco/bootstrap-context.xml]: Can't resolve reference to bean 'transactionComponent' while setting property 'transactionService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionComponent' defined in class path resource [alfresco/core-services-context.xml]: Can't resolve reference to bean 'transactionManager' while setting property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Can't resolve reference to bean 'sessionFactory' while setting property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount

Supplemental Text



oracle.oc4j.admin.internal.DeployerException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userBootstrap' defined in class path resource [alfresco/bootstrap-context.xml]: Can't resolve reference to bean 'transactionComponent' while setting property 'transactionService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionComponent' defined in class path resource [alfresco/core-services-context.xml]: Can't resolve reference to bean 'transactionManager' while setting property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Can't resolve reference to bean 'sessionFactory' while setting property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount at oracle.oc4j.admin.internal.DeployerBase.execute(DeployerBase.java:126) at oracle.oc4j.admin.jmx.server.mbeans.deploy.OC4JDeployerRunnable.doRun(OC4JDeployerRunnable.java:52) at oracle.oc4j.admin.jmx.server.mbeans.deploy.DeployerRunnable.run(DeployerRunnable.java:81) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:819) at java.lang.Thread.run(Thread.java:595) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userBootstrap' defined in class path resource [alfresco/bootstrap-context.xml]: Can't resolve reference to bean 'transactionComponent' while setting property 'transactionService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionComponent' defined in class path resource [alfresco/core-services-context.xml]: Can't resolve reference to bean 'transactionManager' while setting property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Can't resolve reference to bean 'sessionFactory' while setting property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:180) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:203) at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:614) at org.springframework.context.support.AbstractApplicationContext.registerListeners(AbstractApplicationContext.java:496) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:317) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1015) at com.evermind.server.http.HttpApplication.(HttpApplication.java:649) at com.evermind.server.ApplicationStateRunning.getHttpApplication(ApplicationStateRunning.java:428) at com.evermind.server.Application.getHttpApplication(Application.java:512) at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1975) at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.(HttpSite.java:1894) at com.evermind.server.http.HttpSite.addHttpApplication(HttpSite.java:1591) at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:206) at oracle.oc4j.admin.internal.WebApplicationBinder.bindWebApp(WebApplicationBinder.java:96) at oracle.oc4j.admin.internal.ApplicationDeployer.bindWebApp(ApplicationDeployer.java:541) at oracle.oc4j.admin.internal.ApplicationDeployer.doDeploy(ApplicationDeployer.java:197) at oracle.oc4j.admin.internal.DeployerBase.execute(DeployerBase.java:93) … 4 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionComponent' defined in class path resource [alfresco/core-services-context.xml]: Can't resolve reference to bean 'transactionManager' while setting property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Can't resolve reference to bean 'sessionFactory' while setting property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:180) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176) … 30 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Can't resolve reference to bean 'sessionFactory' while setting property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:180) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176) … 37 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Initialization of bean failed; nested exception is org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:370) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176) … 44 more Caused by: org.hibernate.HibernateException: Errors in named queries: node.GetChangedNodeStatuses, patch.GetAppliedPatchesByDate, patch.GetAllAppliedPatches, node.GetContentDataStrings, node.GetNextChangeTxnIds, store.GetAllStores, node.patch.GetNodesWithPersistedSerializableProperties, node.GetNodeAssoc, node.GetNodeAssocSources, permission.patch.UpdatePermissionEntryTypeName, node.GetNodeAssocTargets, permission.patch.UpdatePermissionName, permission.GetPermissionsForRecipient, node.GetChangedNodeStatusesCount at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:338) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:800) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:726) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363) … 47 more 

[gavinc]

Have you changed the hibernate dialect to Oracle and updated the JDBC driver etc.

This post may help with this: http://www.alfresco.org/forums/viewtopic.php?t=798

[ecarballo]

Gavinc,

Yes, I already did those two things.

[gavinc]

I noticed you have the following line in the stack trace you posted:

java.lang.ClassNotFoundException: org.springframework.beans.factory.BeanCreationException

Is it possible that you have another Spring JAR in your classpath i.e. does Oracle app server ship with Spring?

[ecarballo]

It is possible.  I'll check into it and get back to you.  Thanks.