topic problem connection oracle XE in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-connection-oracle-xe/m-p/210436#M163566 <HTML><HEAD></HEAD><BODY><SPAN>hi,&nbsp; </SPAN><BR /><BR /><SPAN>I have just installed alfresco Labs 3 (complet installation) on Windows server 2003, and I meet problems to (I think) oracle connection.</SPAN><BR /><SPAN>I followed the changes suggested on </SPAN><A href="http://wiki.alfresco.com/wiki/Database_Configuration" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Database_Configuration</A><SPAN>. </SPAN><BR /><BR /><SPAN>I copied file JDBC oracle driver towards C:\Alfresco\tomcat\common\lib</SPAN><BR /><SPAN>then removed the extensions .sample of the files custom-hibernate-dialect.properties.sample, custom-repository.properties.sample, custom-repository-context.xml.sample</SPAN><BR /><BR /><SPAN>moreover, my files custom-repository.properties contains the following lines without comments:</SPAN><BR /><BR /><SPAN>dir.root=/srv/alfresco/alf_data</SPAN><BR /><SPAN>db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>db.pool.initial=5</SPAN><BR /><SPAN>db.pool.max=50</SPAN><BR /><SPAN>db.name=XE</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:@em5:1521:XE</SPAN><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=alfresco</SPAN><BR /><BR /><SPAN>custum-hibernate-dialect.properties contains : </SPAN><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.Oracle9Dialect</SPAN><BR /><BR /><BR /><SPAN>everything works well, but while launching alf_start.bat, I obtain the following log (in French):</SPAN><BR /><BR /><SPAN>11:47:07,500 INFO&nbsp; [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]</SPAN><BR /><SPAN>11:47:22,765 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method 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>Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:380)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1439)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:448)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:552)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: mot-clé FROM absent à l'emplacement prévu</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)</SPAN><BR /><SPAN>&nbsp;&nbsp; … 48 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: ORA-00923: mot-clé FROM absent à l'emplacement prévu</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp; … 51 more</SPAN><BR /><SPAN>11:47:22,765 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.springframework.web.context.ContextLoaderListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method 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>Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:380)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1439)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:448)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:552)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: mot-clé FROM absent à l'emplacement prévu</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)</SPAN><BR /><SPAN>&nbsp;&nbsp; … 48 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: ORA-00923: mot-clé FROM absent à l'emplacement prévu</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp; … 51 more</SPAN><BR /><SPAN>11:47:22,765 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception lors de l'envoi de l'évènement contexte initialisé (context initialized) à l'instance de classe d'écoute (listener) org.alfresco.web.app.ContextListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method 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>Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:380)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1439)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:448)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:552)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)</SPAN><BR /><SPAN>Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: mot-clé FROM absent à l'emplacement prévu</SPAN><BR /><SPAN>)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)</SPAN><BR /><SPAN>&nbsp;&nbsp; … 48 more</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: ORA-00923: mot-clé FROM absent à l'emplacement prévu</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)</SPAN><BR /><SPAN>&nbsp;&nbsp; at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)</SPAN><BR /><SPAN>&nbsp;&nbsp; … 51 more</SPAN><BR /><SPAN>11:47:26,796 INFO&nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 21 Web Scripts (+0 failed), 23 URLs</SPAN><BR /><SPAN>11:47:26,796 INFO&nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 235.58134ms)</SPAN><BR /><SPAN>11:47:27,968 INFO&nbsp; [org.alfresco.web.scripts.DeclarativeRegistry] Registered 134 Web Scripts (+0 failed), 136 URLs</SPAN><BR /><SPAN>11:47:27,968 INFO&nbsp; [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 1157.5267ms)</SPAN><BR /><SPAN>11:47:28,046 INFO&nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework</SPAN><BR /><SPAN>11:48:02,281 INFO&nbsp; [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework</SPAN><BR /><BR /><BR /><BR /><SPAN>since 4 days, I don't arrive to solve my problem. I sought on alfresco forums, but I don't find solutions. </SPAN><BR /><SPAN>if somebody could help me, I would be very grateful to him…</SPAN><BR /><BR /><SPAN>thx a lot</SPAN><BR /><BR /><BR /><SPAN>emily</SPAN></BODY></HTML> Thu, 19 Feb 2009 14:28:14 GMT emily 2009-02-19T14:28:14Z problem connection oracle XE https://connect.hyland.com/t5/alfresco-archive/problem-connection-oracle-xe/m-p/210436#M163566 hi,&nbsp; I have just installed alfresco Labs 3 (complet installation) on Windows server 2003, and I meet problems to (I think) oracle connection.I followed the changes suggested on http://wiki.alfresco.com/wiki/Database_Configuration. I copied file JDBC oracle driver towards C:\Alfresco\tomcat\common\li Thu, 19 Feb 2009 14:28:14 GMT https://connect.hyland.com/t5/alfresco-archive/problem-connection-oracle-xe/m-p/210436#M163566 emily 2009-02-19T14:28:14Z Re: problem connection oracle XE https://connect.hyland.com/t5/alfresco-archive/problem-connection-oracle-xe/m-p/210437#M163567 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>You appear to have an active </SPAN><STRONG>validationQuery</STRONG><SPAN> running on your connection pool.</SPAN><BLOCKQUOTE class="jive-quote">at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)</BLOCKQUOTE><SPAN>Please check if you have an overriding </SPAN><STRONG>dataSource</STRONG><SPAN> bean in any of your extension configurations and that the validation query&nbsp; is correct for Oracle (</SPAN><STRONG>select 1 from dual</STRONG><SPAN>).</SPAN><BR /><SPAN>Regards</SPAN></BODY></HTML> Wed, 25 Feb 2009 14:42:52 GMT https://connect.hyland.com/t5/alfresco-archive/problem-connection-oracle-xe/m-p/210437#M163567 derek 2009-02-25T14:42:52Z