AnsweredAssumed Answered

alfresco 1.4 and MySQL 5.0

Question asked by mabayona on Sep 26, 2006
Latest reply on Sep 26, 2006 by mabayona
Hi,

has anybody got alfresco running with MySQL 5.0.X?

I have installed alfresco 1.4 and MySQL 4.X several times with no problem. But when i try with MySQL5.0.x i get problems . I get no further and even the database is not created. It seems that alfresco does not get connected with MySQL.

The following configuration works OK:

alfresco 1.4
mysql 4.1.x
mysql-connector-java-3.1.12-bin.jar

but if I use MySQL 5.0.24 instead, i get the following errors:

08:55:43,859 ERROR [web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name dictionaryRepositoryBootstrap defined in class path resource [alfresco/core-services-context.xml]: Initialization of bean 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
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
org.hibernate.exception.GenericJDBCException: Cannot open connection
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
   at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
   at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
   at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
   at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520)




Any idea?

Thanks in advance.

Outcomes