AnsweredAssumed Answered

CentOS Alfresco 3.4 - MySQL PostgreSQL errors

Question asked by flotho on Apr 12, 2011
Latest reply on Apr 19, 2011 by gyro.gearless
Hy all of you,

I've installed the official 3.4d installer and get through the process in a text mode and advanced mode.
I have a MySQL and a PostgreSQL server on my VPS.
I checked all my tomcat/shared/classes/alfresco-global.properties
dir.root=/home/alfresco_datas

web.application.context.url=http://myip:8585/alfresco

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.url=jdbc:mysql://localhost/alfresco
Share login page appears but not the alfresco one.

I even try with a postgreSQL connection. I've checked all the posts I've found on the MySQL subject.
Unfortunately, I still have this error :

WARN  [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata    
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure                                                                               

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)                                                              
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) 
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)     
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)                                                       
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)            
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)              
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)        
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)                                                                      
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)                                                                    
        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)                                                               
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1460)                                        
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1398)                                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)                                                        
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)                                                 
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)                                      
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)                                                        
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)                                                 
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)                                      
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)                                                        
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)                                                 
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)                                      
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:557)                                                  
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:842)                                                 
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:416)                                                                         
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)                                                                                   
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)                                                                                     
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)                                                                             
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)                                                                                        
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)   
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)           
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)     
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)             
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)               
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)        
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)       
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)              
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)                  
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)          
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)                                                                                             
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)               
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)                  
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)               
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)              
        at org.apache.catalina.core.StandardService.start(StandardService.java:519)            
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)              
        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)                       
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)                         
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)       
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)                                    
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)                     
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)                      
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.                                                               
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)               
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)                                                                                        
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)                                                                                
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)                     
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)                                
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)           
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)                                     
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)           
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)                 
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)                       
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)                      
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)               
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)                                                                                        
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)                                                                                
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)                     
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)                                
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)                  
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)          
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)                                                                                   
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)                                                                                    
        at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)                                                                                        
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) 
        … 77 more                                                                            
Caused by: java.net.ConnectException: Connection refused                                       
        at java.net.PlainSocketImpl.socketConnect(Native Method)                               
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)                        
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)                 
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)                          
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)                          
        at java.net.Socket.connect(Socket.java:525)                                            
        at java.net.Socket.connect(Socket.java:475)                                            
        at java.net.Socket.<init>(Socket.java:372)                                             
        at java.net.Socket.<init>(Socket.java:215)                                             
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)        
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)                                     
        … 92 more                                                                            
01:23:38,388 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'RepoServerMgmt' defined in class path resource [alfresco/core-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                                                               
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)                                                        
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)                                                 
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)                                      
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:557)                                                  
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:842)                                                 
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:416)                                                                         
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)                                                                                   
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)                                                                                     
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)                                                                             
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)                                                                                        
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)   
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)           
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)     
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)             
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)               
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)        
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)       
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)              
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)                  
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)          
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)                                                                                             
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)               
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)                  
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)               
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)              
        at org.apache.catalina.core.StandardService.start(StandardService.java:519)            
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)              
        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)                       
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)                         
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)       
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)                                    
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)                     
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)                      
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                                                             
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)                                                        
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)                                                 
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)                                      
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)                                                        
        … 40 more                                                                            
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                                                                          
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)                                                        
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)                                                 
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1305)                                      
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)                                             
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)                                                        
        … 50 more                                                                            
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                                                                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1401)                                           
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512)                                              
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)                                                
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)                                                                             
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)                                                          
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)                                                                               
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)                                                                                 
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)                                                        
        … 60 more                                                                            
Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set          
        at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:59)       
        at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)           
        at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)        
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)           
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073)              
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)        
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:855)                                                                      
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:774)                                                                    
        at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)                                                               
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1460)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1398)
        … 67 more
01:23:49,987 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 309 Web Scripts (+0 failed), 319 URLs
01:23:49,988 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed)
01:23:49,989 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed)
01:23:50,403 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 3030.819ms)
01:23:50,487 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:23:50,678 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:23:51,049 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:23:51,053 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
01:23:51,329 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
01:23:51,334 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js

I'm really confused caus' so many people seems to have a similar issue but none of their solutions solved mine.

So, how can I say? HELP ;-)

Outcomes