Hibernate: no dialect installed. Set the hibernate.dialect property

Question

I have the following hibernate.cfg.xml :

 <hibernate-configuration> <session-factory> <property name="hibernate.format_sql">true</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.connection.url">jdbc:mysql://localhost/EJB</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password">password</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <property name="hibernate.hbm2ddl.auto">update</property> <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property> <!-- Snip --> 

I am using this line:

 sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory(); 

Then, in another place, I try this:

 SimpleSelect pkSelect = new SimpleSelect(Dialect.getDialect()); 

This results in the following exception:

 org.hibernate.HibernateException: The dialect was not set. Set the property hibernate.dialect. 

Note that the following breakaway from the logs:

 02:26:48,714 INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml 02:26:48,717 INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml 02:26:48,909 DEBUG Configuration:1387 - hibernate.dialect=org.hibernate.dialect.MySQLDialect 

Any ideas what I'm doing wrong?

Answer 1

The javadoc getDialect() says:

Get a dialect instance indicated by the current system properties.

So for this method, you need to set hibernate.dialect to hibernate.dialect in hibernate.properties .

Use SessionFactoryImplementor#getDialect() .