topic HibernateException: Hibernate Dialect must be explicitly set in Alfresco Archive

HibernateException: Hibernate Dialect must be explicitly set

targa2000 — Tue, 19 Jan 2010 14:29:35 GMT

I'm having a problem with the Alfresco EE 3.2 trial installation. Followed the installation instructions, but when I try start the Alfresco with the alf_start.bat script, tomcat starts but then displays errors:any suggestions?19.01.2010 14:57:26 org.apache.catalina.core.ApplicationContext logINFO:

Re: HibernateException: Hibernate Dialect must be explicitly set

mrogers — Tue, 19 Jan 2010 14:45:52 GMT

What have you put into your alfresco-global.properties ?

Re: HibernateException: Hibernate Dialect must be explicitly set

targa2000 — Tue, 19 Jan 2010 15:02:45 GMT

I hadn't altered it. It is the default from the installation.

#
# Sample custom content and index data location
#————-
dir.root=C:/Alfresco/alf_data

#
# Sample database connection properties
#————-
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=3306

#
# External locations
#————-
ooo.exe=C:/Alfresco/OpenOffice.org/program/soffice
ooo.user=C:/Alfresco/alf_data/oouser
img.root=C:/Alfresco/ImageMagick
swf.exe=C:/Alfresco/bin/pdf2swf

#
# Initial admin password
#————-
alfresco_user_store.adminpassword=11a01c4a0f2f228796c93fa0ca1a634d

#
# MySQL connection
#————-
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}

Re: HibernateException: Hibernate Dialect must be explicitly set

tommorris — Tue, 19 Jan 2010 16:29:22 GMT

I'm using 3.2.0 enterprise.

In this file:
tomcat\webapps\alfresco\WEB-INF\classes\alfresco\domain\hibernate-cfg.properties
(Which is referenced by the bean 'hibernateConfigProperties' inside tomcat\webapps\alfresco\WEB-INF\classes\alfresco\hibernate-context.xml)

I noticed the comment:


# The Hibernate Dialect:
#    As of V3.1, the dialect is automatically detected.
#    It is still possible to set the dialect explicitly, for example:
#       hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
‍‍‍‍‍‍

Interesting.

I would check that you don't have two copies of 'alfresco-global.properties' (one is probably in 'tomcat\shared\classes' whilst another may be in 'tomcat\webapps\alfresco\WEB-INF\classes'). Also check for any old empty 'hibernate.dialect' references to the dialect, either in 'repository.properties' or 'custom-repository.properties'.

Also, if you're using MySQL (which your properties suggest you are), also check that the connector jar file (mysql-connector-java-5.*.*-bin.jar) is available for the webapp (e.g. it lives in "tomcat\lib" or "tomcat\webapps\alfresco\WEB-INF\lib\mysql-connector-java-5.1.10-bin.jar").

Tom
http://www.ixxus.com

Re: HibernateException: Hibernate Dialect must be explicitly set

targa2000 — Tue, 19 Jan 2010 16:41:00 GMT

Thank you very much for the replies! I think I have found my error.

I followed the installation instructions and from said instructions had the impression that we needed to install a separate Mysql database which I did. The instructions also suggested putting the mysql bin in the path and starting it as a service.

http://storage.pardot.com/50281_Alfresco_Enterprise_Edition_Detailed_Install_and_Configure_Guide.pdf

This I did. I then installed alfresco and attempted to start and ran across the above error.

Using an external database installation, the user needs to complete the 'Configuring Databases' section of the instructions which is further down than the 'Running Alfresco' section. But this I hadn't done yet.

The easy resolution to my problem was to turn off the mysql service of the external mysql I installed and take it out of the path. Then just run the Alfresco start script and Alfie will start its own mysql database itself. This is the easiest, best solution.

Re: HibernateException: Hibernate Dialect must be explicitly set

targa2000 — Tue, 19 Jan 2010 16:42:00 GMT

yes, I also didn't appear to have a connector file in my library either.