<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic alfresco on win xp and oracle in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207394#M160524</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hello&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I installed on win xp Alfresco-Enterprise-3.0.1-Full-Setup.exe&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I want to connect to oracle 10g which in on another machine&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I change the connexion parameters in custom-repository.properties.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;In custom-hibernate-dialect.properties, the line "hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect" seems correct&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I try to connect to the database from a odbc client and it is ok&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;When I lauch "start alfresco server " I have thoses messages :&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;….&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@eb46e9)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; LogAbandoned: false&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; RemoveAbandoned: true&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; RemoveAbandonedTimeout: 30&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@7c9586)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; LogAbandoned: false&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; RemoveAbandoned: true&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; RemoveAbandonedTimeout: 30&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;…&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@165f5a4)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; LogAbandoned: false&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; RemoveAbandoned: true&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp; RemoveAbandonedTimeout: 30&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;14:32:47,738&amp;nbsp; ERROR [web.context.ContextLoader] Context initialization failed&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' defined in class path&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt; resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.Can&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;notCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCE&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;xception: Cannot open connection&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exc&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;eption is org.hibernate.exception.GenericJDBCException: Cannot open connection&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.j&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;ava:350)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.jav&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;a:262)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.jav&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;a:219)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:394)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(Abs&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;tractLuceneIndexerAndSearcherFactory.java:1441)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFact&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;ory.java:1201)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;.java:1171)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.jav&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;a:425)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;287)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:516)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:578)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.reflect.Method.invoke(Method.java:597)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where e&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;xpected&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; … 48 more&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Caused by: java.sql.SQLException: ORA-00923: FROM keyword not found where expected&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:440)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:977)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:483)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1094)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1275)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:328)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:879)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; … 51 more&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28 janv. 2009 14:32:47 org.apache.catalina.core.StandardContext start&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;GRAVE: Error listenerStart&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28 janv. 2009 14:32:47 org.apache.catalina.core.StandardContext start&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;GRAVE: Erreur de d´┐¢marrage du contexte [/alfresco] suite aux erreurs pr´┐¢c´┐¢dentes&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28 janv. 2009 14:32:49 org.apache.catalina.startup.HostConfig deployWAR&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;INFO: D´┐¢ploiement de l'archive share.war de l'application web&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;14:32:52,694&amp;nbsp; INFO&amp;nbsp; [web.site.FrameworkHelper] Successfully Initialized Web Framework&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28 janv. 2009 14:32:52 org.apache.coyote.http11.Http11Protocol start&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;INFO: D´┐¢marrage de Coyote HTTP/1.1 sur http-8080&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28 janv. 2009 14:32:52 org.apache.catalina.startup.Catalina start&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;INFO: Server startup in 78866 ms&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;28 janv. 2009 14:36:46 org.apache.catalina.loader.WebappClassLoader loadClass&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;INFO: Illegal access: this web application instance has been stopped already.&amp;nbsp; Could not load org.apache.commons.pool.impl.GenericKeyedOb&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;jectPool$ObjectTimestampPair.&amp;nbsp; The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attem&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;pt to terminate the thread which caused the illegal access, and has no functional impact.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;java.lang.IllegalStateException&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1273)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.addObjectToPool(GenericObjectPool.java:1117)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1279)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.ensureMinIdle(GenericObjectPool.java:1254)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.access$100(GenericObjectPool.java:179)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool$Evictor.run(GenericObjectPool.java:1346)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.util.TimerThread.mainLoop(Timer.java:512)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.util.TimerThread.run(Timer.java:462)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Exception in thread "Timer-0" java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericKeyedObjectPool$ObjectTimestampPair&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.addObjectToPool(GenericObjectPool.java:1117)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1279)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.ensureMinIdle(GenericObjectPool.java:1254)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool.access$100(GenericObjectPool.java:179)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.commons.pool.impl.GenericObjectPool$Evictor.run(GenericObjectPool.java:1346)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.util.TimerThread.mainLoop(Timer.java:512)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.util.TimerThread.run(Timer.java:462)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Caused by: java.lang.ClassNotFoundException: org.apache.commons.pool.impl.GenericKeyedObjectPool$ObjectTimestampPair&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; … 7 more&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;can you help me?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 28 Jan 2009 13:51:03 GMT</pubDate>
    <dc:creator>rowan</dc:creator>
    <dc:date>2009-01-28T13:51:03Z</dc:date>
    <item>
      <title>alfresco on win xp and oracle</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207394#M160524</link>
      <description>HelloI installed on win xp Alfresco-Enterprise-3.0.1-Full-Setup.exeI want to connect to oracle 10g which in on another machineI change the connexion parameters in custom-repository.properties.In custom-hibernate-dialect.properties, the line "hibernate.dialect=org.alfresco.repo.domain.hibernate.diale</description>
      <pubDate>Wed, 28 Jan 2009 13:51:03 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207394#M160524</guid>
      <dc:creator>rowan</dc:creator>
      <dc:date>2009-01-28T13:51:03Z</dc:date>
    </item>
    <item>
      <title>Re: alfresco on win xp and oracle</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207395#M160525</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I have the same problem, maybe the problem is with hibernate, but i not resolve yet.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;My S.O. is win2003server…. JDK1.6_07…..Alfresco_full_3.0Labs&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 12 Feb 2009 18:33:26 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207395#M160525</guid>
      <dc:creator>sandroh</dc:creator>
      <dc:date>2009-02-12T18:33:26Z</dc:date>
    </item>
    <item>
      <title>Re: alfresco on win xp and oracle</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207396#M160526</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;hi, &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have the same problem, you remember what's you did to solve this problem??? &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;thx, &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;emily&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 19 Feb 2009 13:52:55 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207396#M160526</guid>
      <dc:creator>emily</dc:creator>
      <dc:date>2009-02-19T13:52:55Z</dc:date>
    </item>
    <item>
      <title>Re: alfresco on win xp and oracle</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207397#M160527</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I got perform alfresco with Oracle.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;The problem is user permission for user Alfresco.&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I noted this line of I mistake : &lt;/SPAN&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;Revise the configurations of the user "alfresco". His don't need dba permissions, resource permissions will do.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 05 Mar 2009 19:26:49 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207397#M160527</guid>
      <dc:creator>sandroh</dc:creator>
      <dc:date>2009-03-05T19:26:49Z</dc:date>
    </item>
    <item>
      <title>Re: alfresco on win xp and oracle</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207398#M160528</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi can you please explain what do you mean by "Revise the configurations of the user "alfresco". His don't need dba permissions, resource permissions will do."&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;What config need to change to give user alfresco resource permission ?&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I assumed alfresco here is user of the oralce right ?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 22 Apr 2009 09:57:11 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/alfresco-on-win-xp-and-oracle/m-p/207398#M160528</guid>
      <dc:creator>kiekie</dc:creator>
      <dc:date>2009-04-22T09:57:11Z</dc:date>
    </item>
  </channel>
</rss>

