topic Oracle and Alfresco: am I missing something? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/oracle-and-alfresco-am-i-missing-something/m-p/91954#M62825 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm trying to make Alfresco work with an Oracle database but I get this error:</SPAN><BR /><BR /><SPAN>12:36:10,015 WARN&nbsp; [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one</SPAN><BR /><SPAN>12:36:10,343 ERROR [org.alfresco.repo.transaction.TransactionUtil] Error rolling back transaction</SPAN><BR /><SPAN>java.lang.IllegalStateException: No user transaction is active</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:461)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:201)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:551)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)</SPAN><BR /><SPAN>12:36:10,406 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:282)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:356)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:551)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: palabra clave FROM no encontrada donde se esperaba</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 50 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: ORA-00923: palabra clave FROM no encontrada donde se esperaba</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 53 more</SPAN><BR /><SPAN>12:36:10,546 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepcin enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:282)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:356)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:551)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: palabra clave FROM no encontrada donde se esperaba</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 50 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: ORA-00923: palabra clave FROM no encontrada donde se esperaba</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 53 more</SPAN><BR /><SPAN>12:36:10,750 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepcin enviando evento inicializado de contexto a instancia de escuchador de clase org.alfresco.web.app.ContextListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:282)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:356)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:82)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:450)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:551)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: palabra clave FROM no encontrada donde se esperaba</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 50 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: ORA-00923: palabra clave FROM no encontrada donde se esperaba</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 53 more</SPAN><BR /><BR /><BR /><SPAN>_________________________________</SPAN><BR /><BR /><SPAN>What I've done so far is:</SPAN><BR /><BR /><SPAN> - Installed Alfresco (with the 'Oracle database' option).</SPAN><BR /><BR /><SPAN> - Created an 'alfresco' schema and user in the database.</SPAN><BR /><BR /><SPAN> - Removed the 'sample' off the name of the 'custom-connection-pool-context.xml.sample' file </SPAN><BR /><BR /><SPAN> - Did the same thing with:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp; · custom-repository-context.xml.sample</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; · custom-repository.properties.sample</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; · custom-hibernate-dialect.properties.sample</SPAN><BR /><BR /><SPAN> - Edited custom-repository.properties:</SPAN><BR /><BR /><SPAN>db.driver=oracle.jdbc.driver.OracleDriver</SPAN><BR /><SPAN>db.name=alfresco</SPAN><BR /><SPAN>db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@&lt;my_machine_name&gt;:1521:&lt;my_database_sid&gt;</SPAN><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=alfresco</SPAN><BR /><BR /><SPAN> - Edited custom-hibernate.dialect:</SPAN><BR /><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.OracleDialect</SPAN><BR /><BR /><SPAN> - Copied Oracle JDBC driver JAR into \tomcat\common\lib</SPAN><BR /><BR /><SPAN>Using an XP for the Alfresco Server + Oracle database (in remote machine).</SPAN><BR /><BR /><SPAN>What's left?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Mon, 07 May 2007 11:51:32 GMT avro 2007-05-07T11:51:32Z Oracle and Alfresco: am I missing something? https://connect.hyland.com/t5/alfresco-archive/oracle-and-alfresco-am-i-missing-something/m-p/91954#M62825 Hi, I'm trying to make Alfresco work with an Oracle database but I get this error:12:36:10,015 WARN&nbsp; [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one12:36:10,343 ERROR [org.alfresco.repo.transaction.TransactionUtil] Error rolling back transac Mon, 07 May 2007 11:51:32 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-and-alfresco-am-i-missing-something/m-p/91954#M62825 avro 2007-05-07T11:51:32Z Re: Oracle and Alfresco: am I missing something? https://connect.hyland.com/t5/alfresco-archive/oracle-and-alfresco-am-i-missing-something/m-p/91955#M62826 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>You only need these (look at the files themselves):</SPAN><PRE class="language-none line-numbers"><CODE>· custom-repository-context.xml.sample <BR />· custom-repository.properties.sample <BR />· custom-hibernate-dialect.properties.sample <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>The basic issue is that the database connection is not correct.&nbsp; Check the URL and that you have the port open, etc.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Tue, 08 May 2007 14:11:35 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-and-alfresco-am-i-missing-something/m-p/91955#M62826 derek 2007-05-08T14:11:35Z