topic I cannot run FirstFoundationClient sample of Alfresco SDK in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/i-cannot-run-firstfoundationclient-sample-of-alfresco-sdk/m-p/273615#M226745 <HTML><HEAD></HEAD><BODY><SPAN>I have searched this problem and read other topics about it, but they didn't seem to help me.</SPAN><BR /><SPAN>I use:</SPAN><BR /><BR /><SPAN>Win 7 ultimate 32 bits</SPAN><BR /><SPAN>MySQL server 5.1</SPAN><BR /><SPAN>Alfresco community 4.0-d</SPAN><BR /><SPAN>Alfresco-community- sdk 4.0-d</SPAN><BR /><BR /><SPAN>of course, I have created alfresco database and alfresco user.</SPAN><BR /><SPAN>I configed the alfresco-global.properties like this:</SPAN><BR /><BR /><SPAN>dir.root=C:/Alfresco/alf_data</SPAN><BR /><SPAN>dir.keystore=${dir.root}/keystore</SPAN><BR /><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=alfresco</SPAN><BR /><BR /><SPAN>db.driver=org.gjt.mm.mysql.Driver</SPAN><BR /><SPAN>db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8</SPAN><BR /><BR /><SPAN>alfresco.rmi.services.host=0.0.0.0</SPAN><BR /><BR /><SPAN>And this is what I get&nbsp; <img id="smileysad" class="emoticon emoticon-smileysad" src="https://connect.hyland.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /> Any one can help me? Thank you very much. I'm a student and I studying alfresco for my project. I'm completely new to it.</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'encryptionKeysRegistry' defined in class path resource [alfresco/encryption-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<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:139)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:93)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.BaseApplicationContextHelper.getApplicationContext(BaseApplicationContextHelper.java:67)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:46)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:63)<BR />Caused by: 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<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)<BR />&nbsp;&nbsp;&nbsp;… 17 more<BR />Caused by: 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<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)<BR />&nbsp;&nbsp;&nbsp;… 27 more<BR />Caused by: 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<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)<BR />&nbsp;&nbsp;&nbsp;… 37 more<BR />Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:59)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)<BR />&nbsp;&nbsp;&nbsp;… 44 more</BLOCKQUOTE></BODY></HTML> Sat, 04 Aug 2012 12:01:16 GMT khanhthinh1 2012-08-04T12:01:16Z I cannot run FirstFoundationClient sample of Alfresco SDK https://connect.hyland.com/t5/alfresco-archive/i-cannot-run-firstfoundationclient-sample-of-alfresco-sdk/m-p/273615#M226745 I have searched this problem and read other topics about it, but they didn't seem to help me.I use:Win 7 ultimate 32 bitsMySQL server 5.1Alfresco community 4.0-dAlfresco-community- sdk 4.0-dof course, I have created alfresco database and alfresco user.I configed the alfresco-global.properties like t Sat, 04 Aug 2012 12:01:16 GMT https://connect.hyland.com/t5/alfresco-archive/i-cannot-run-firstfoundationclient-sample-of-alfresco-sdk/m-p/273615#M226745 khanhthinh1 2012-08-04T12:01:16Z Re: I cannot run FirstFoundationClient sample of Alfresco SDK https://connect.hyland.com/t5/alfresco-archive/i-cannot-run-firstfoundationclient-sample-of-alfresco-sdk/m-p/273616#M226746 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>is the MySQL driver JAR available to your project? The error message in the log indicates that something has gone wrong in the automatic determination of the database dialect to use. In a MySQL use case as your configuration indicates, this is usually the result of a database communication problem. Since I assume your connection details (host, port, database and user) are correct, the availability of the driver is the next major suspect.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Mon, 06 Aug 2012 12:25:09 GMT https://connect.hyland.com/t5/alfresco-archive/i-cannot-run-firstfoundationclient-sample-of-alfresco-sdk/m-p/273616#M226746 afaust 2012-08-06T12:25:09Z