HibernateException

[madhu Karunatham]

Hi

I am trying to a simple application in hibernate.
I have created the following classes with the two hibernate mapping files
and iam inserting one record into the contact table

public class Contact {
  private String firstName;
  private String lastName;
  private String email;
  private int id;
 
  /**
   * @return Email
   */
  public String getEmail() {
    return email;
  }
 
  /**
   * @return First Name
   */
  public String getFirstName() {
    return firstName;
  }
 
  /** 
   * @return Last name
   */
  public String getLastName() {
    return lastName;
  }
 
  /**
   * @param string Sets the Email
   */
  public void setEmail(String string) {
    email = string;
  }
 
  /**
   * @param string Sets the First Name
   */
  public void setFirstName(String string) {
    firstName = string;
  }
 
  /**
   * @param string sets the Last Name
   */
  public void setLastName(String string) {
    lastName = string;
  }
 
  /**
   * @return ID Returns ID
   */
  public int getId() {
    return id;
  }
 
  /**
   * @param l Sets the ID
   */
  public void setId(int l) {
    id = l;
  }
 
 
}

 
 
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.HibernateException;
 
public class FirstExample {
public static void main(String[] args) {
 
 try{
      Configuration cfg1=new Configuration().addClass(Contact.class);
      System.out.println("comes here"+cfg1);
      SessionFactory sessionFactory=cfg1.buildSessionFactory();
      System.out.println("comes here"+sessionFactory);
      Session session =sessionFactory.openSession();
      System.out.println("Inserting Record");
      Contact contact = new Contact();
      contact.setId(3);
      contact.setFirstName("Deepak");
      contact.setLastName("Kumar");
      contact.setEmail("[e-mail]");
      session.save(contact);
      System.out.println("Done");
      session.flush();
      session.close();
    }catch(HibernateException e){
      e.printStackTrace();
    }    
  }
} 

 
<?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="Contact" table="CONTACT">
   <id name="id" type="int" column="ID" >
   <generator class="assigned"/>
  </id>
  <property name="firstName">
     <column name="FIRSTNAME" />
  </property>
  <property name="lastName">
    <column name="LASTNAME"/>
  </property>
  <property name="email">
    <column name="EMAIL"/>
  </property>
 </class>
</hibernate-mapping>
 
 
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
<session-factory>
      <property name="hibernate.connection.driver_class">com.ibm.db2.jdbc.app.DB2Driver</property>
      <property name="hibernate.connection.url">jdbc  :mrgreen:  b2:MWCDPDB2</property>
      <property name="hibernate.connection.username">db2admin</property>
      <property name="hibernate.connection.password">vimal</property>
      <property name="hibernate.connection.pool_size">10</property>
      <property name="show_sql">true</property>
      <property name="dialect">org.hibernate.dialect.DB2Dialect</property>
      <property name="hibernate.hbm2ddl.auto">update</property>
      <!-- Mapping files -->
      <mapping resource="Contact.hbm.xml"/>
</session-factory>
</hibernate-configuration>

and also i added all the required jar files to the classpath
but it showing an exception

here is the exception


org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
at org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:378)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:110)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at FirstExample.main(FirstExample.java:12)



could you pls any body helpme out.

thanks
madhu

[ Edited to use code tags - Paul Sturrock ]
[ November 15, 2006: Message edited by: Paul Sturrock ]

[Halcon Guatemala]

Hi madhu, welcome to Hibernate world...
It seems a very easy solution:
your hibernate.cfg.xml file must include the

<property name="dialect">
</property>

to specify the dialect used for your database.
You can get a complete reference by this file in Hibernate reference
I hope this helps
[ November 15, 2006: Message edited by: Halcon Guatemala ]

[madhu Karunatham]

Originally posted by Halcon Guatemala:
Hi madhu, welcome to Hibernate world...
It seems a very easy solution:
your hibernate.cfg.xml file must include the

<property name="dialect">
</property>

to specify the dialect used for your database.
You can get a complete reference by this file in Hibernate reference
I hope this helps

[ November 15, 2006: Message edited by: Halcon Guatemala ]

I already set the <property name="property"> for ibm db2 database
still it is giving the same exception

the error is showing at sessionfactory=cfg.buildFactory();

[Halcon Guatemala]

Hi again...
are you getting the same trace error? could you show us?
Thanks