Dialect class not found

[kranthi chamarthi]

Hi Everyone,
I am new to hibernate and i am trying to learn it. I have gone through some tutorials and did a sample application. Now when i run the Program i am getting the following error
org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.MYSQLDialect
I unzipped the hibernate3.jar and found MYSQLDialect.class in correct location.
Can anyone suggest me how to solve this error.
Thanks
Kranthi Kumar

[Paul Sturrock]

Assuming you have hibernate3.jar in your classpath everything should be fine. Is this a stand alone Java app?

[kranthi chamarthi]

Yeah this is a stand alone application.

[kranthi chamarthi]

I did set hibernate3.jar in class path still no progress. I am getting the same error.

[Paul Sturrock]

Have you spelled the dialect correctly?

[kranthi chamarthi]

Following is the hibernate.cfg.xml

<?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="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/blogs</property>
<property name="connection.username">root</property>
<property name="connection.password">mysql</property>
<property name="connection.pool_size">1</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MYSQLDialect</property>
<property name="hbm2ddl.auto">create</property>
<mapping resource="blog.hbm.xml"/>
</session-factory>
</hibernate-configuration>

Following is the Class containing the main method

import org.hibernate.Session;
import org.hibernate.cfg.*;
import org.hibernate.*;
public class BlogManager {
public static void main(String args[])
{
try
{
SessionFactory sf=new Configuration().configure().buildSessionFactory();
Session sess=sf.openSession();
Transaction tx=sess.beginTransaction();
BlogForm bf=new BlogForm();
bf.setTitle("My First Blog");
bf.setPost("This is my first Blog");
sess.save(bf);
sess.close();
tx.commit();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}

Following is the mapping xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="BlogForm" table="ENTRIES">
<id name="id" column="ID">
<generator class="assigned"/>
</id>
<property name="title" column="TITILE"/>
<property name="post" column="POST"/>
</class>
</hibernate-mapping>

[Paul Sturrock]

I'd check again, have you spelled org.hibernate.dialect.MySQLDialect correctly?
[ October 14, 2008: Message edited by: Paul Sturrock ]

[Vijay Gadde]

It seems like your doing mistake in Direct URL itself here is what I was using in my application

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

Hope it will solve your problem then
Thanks,Vijay Gadde

[vipin jain]

hello kranthi kumar,

in yyour code your are using MYSQLDialect : Here Y is caps , it must be require small letter i.e. MySQLDialect

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

[kranthi chamarthi]

My problem is solved. As you people said it is the problem with MySQLDialect. Thank you very much.