Geek Answers Handbook

The dialog is not set to sleep

I am using Hibernate 3 and MySQL5.5.

I'm new to hibernation and I get below Exception

Exception in thread "main" org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:106) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:152)

I set the Dialect property in the hibernate.cfg.xml file. I tried many combinations

 <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property> <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property> <property name="DIALECT">org.hibernate.dialect.MySQL5Dialect</property>

What is the actual name of the property? Hibernate.dialect or just a dialect? What are the possible property values?

I add additional information, I used

 <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

as suggested below.

I don't even create code just trying to create a simple configuration:

 Configuration cfg = new Configuration().addClass(Employee.class); sessionFactory = cfg.buildSessionFactory();

Below is the actual configuration file

 <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <property name="connection.url">jdbc:mysql://localhost/test</property> <property name="connection.username">root</property> <property name="connection.password">root1234</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="show_sql">true</property> <property name="format_sql">true</property> <property name="hbm2ddl.auto">create</property> <!-- JDBC connection pool (use the built-in) --> <property name="connection.pool_size">1</property> <property name="current_session_context_class">thread</property> <!-- Mapping files will go here.... --> </session-factory> </hibernate-configuration>

I suspect hibernate.cfg.xml was not found? I placed it in the same package where there is source code for Employee.class. Infact navigating through this file causes the same error, so you can’t actually find it :-( Where to save it? This is a stand-alone test program: - (

+4
source share
6 answers

Either your first or second line should work. The second method, only with a "dialect", is shown in the Hibernate reference . If you still get this error, it suggests that you might have something else. How do you create a SessionFactory? Are you sure you found hibernate.cfg.xml?

Edit: Based on your update, you do not want Hibernate to configure itself from the configuration file. You create your own configuration and use it. You need to choose one or the other. Either do it programmatically , or do it through XML .

+6
source

I also had the same problem Before, my code was:

 private final static SessionFactory factory = new Configuration() .configure().buildSessionFactory();

now i changed it to

 private final static SessionFactory factory = new Configuration() .configure("hibernate.cfg.xml").buildSessionFactory();

And the error is gone. I think by default it only searches for the hibernate.properties file.

+5
source

Property Name hibernate.dialect

 <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

I don't know if there is something like MySQL5Dialect .

See more details.

+2
source

The problem is only configuring.

The configure() method of the configure() class can get the path to the hibernate (hibernate.cfg.xml) configuration file hibernate (hibernate.cfg.xml) .

Just tell him the way. I think the problem will be solved.

0
source

In mi case, I solved this by putting jars libs related to hibernate in WEB-INF \ lib.

0
source

I also encountered the same error - org.hibernate.HibernateException: the dialect was not installed. Set the hibernate.dialect property

I forgot to write cfg = cfg.configure (); when creating an instance for the persistence class. Now its execution is excellent.

 Configuration cfg=new Configuration(); cfg=cfg.configure(); sfactory=cfg.buildSessionFactory();
0
source

More articles:


All Articles