topic Alfresco and EnterpriseDB in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-and-enterprisedb/m-p/234044#M187174 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I was wondering whether anyone had gotten Alfresco to work on EnterpriseDB.</SPAN><BR /><SPAN>Though EnterpriseDB is basically PostgreSQL, some adjustments need to be made to alfresco-global.properties to make sure it finds the right JDBC driver:</SPAN><BR /><SPAN>db.driver=com.edb.Driver</SPAN><BR /><SPAN>db.name=alfresco</SPAN><BR /><SPAN>db.url=jdbc:edb://localhost:5444/alfresco</SPAN><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=&lt;password&gt;</SPAN><BR /><SPAN>#db.port=5444</SPAN><BR /><SPAN>hibernate.dialog=org.hibernate.dialect.PostgreSQLDialect</SPAN><BR /><SPAN>hibernate.query.substitutions=true TRUE, false FALSE</SPAN><BR /><BR /><SPAN>However, if I try to start Alfresco on JBoss (4.2.3) it flunks out with the following message:</SPAN><BR /><SPAN>20:40:12,124 INFO&nbsp; [STDOUT] 20:40:12,117&nbsp; ERROR [web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerComponent' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean '&amp;indexerAndSearcherFactory' while setting bean property 'storeRedirectorProxyFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'indexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'admLuceneIndexerAndSearcherFactory' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'admLuceneIndexerAndSearcherFactory' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'mlAwareNodeService' while setting bean property 'nodeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mlAwareNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'mtAwareNodeService' while setting bean property 'defaultBinding'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtAwareNodeService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'dbNodeServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeServiceImpl' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'transactionService' while setting bean property 'transactionService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set for database: EnterpriseDB</SPAN><BR /><BR /><SPAN>"Hibernate Dialect must be explicitly set for database: EnterpriseDB"</SPAN><BR /><BR /><SPAN>I've searched quite a bit but I can't really find what to configure in which file.</SPAN><BR /><SPAN>Does anyone know what needs to be altered?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Jeroen</SPAN></BODY></HTML> Thu, 24 Sep 2009 19:34:15 GMT jmk1k 2009-09-24T19:34:15Z Alfresco and EnterpriseDB https://connect.hyland.com/t5/alfresco-archive/alfresco-and-enterprisedb/m-p/234044#M187174 Hi all,I was wondering whether anyone had gotten Alfresco to work on EnterpriseDB.Though EnterpriseDB is basically PostgreSQL, some adjustments need to be made to alfresco-global.properties to make sure it finds the right JDBC driver:db.driver=com.edb.Driverdb.name=alfrescodb.url=jdbc:edb://localhos Thu, 24 Sep 2009 19:34:15 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-enterprisedb/m-p/234044#M187174 jmk1k 2009-09-24T19:34:15Z Re: Alfresco and EnterpriseDB https://connect.hyland.com/t5/alfresco-archive/alfresco-and-enterprisedb/m-p/234045#M187175 <HTML><HEAD></HEAD><BODY><SPAN>Ok, </SPAN><BR /><BR /><SPAN>Should've looked a bit harder <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN><BR /><SPAN>Turns out that the file </SPAN><A href="http://alfresco.war/WEB-INF/classes/alfresco/domain/hibernate-cfg.properties" rel="nofollow noopener noreferrer">alfresco.war/WEB-INF/classes/alfresco/domain/hibernate-cfg.properties</A><SPAN> needs to be adjusted.</SPAN><BR /><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect</SPAN><BR /><BR /><SPAN>That's all there was to it.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Jeroen</SPAN></BODY></HTML> Thu, 24 Sep 2009 21:48:23 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-enterprisedb/m-p/234045#M187175 jmk1k 2009-09-24T21:48:23Z