Hi i m using Mysql5 .when i m trying run a simple java application with hibernate(Just inserting one record)..its creating the tables( <property name="hibernate.hbm2ddl.auto">update</property> ) but not inserting the records.But the same time when i use Mysql4.0.26 its creating the table and inserting the records also!!! Plz help me out in this...


Thnxin advance

Take a look at your error message. It probably has something to do with "condition".

From Christian:


Hope this helps.

<property name="hbm2ddl.auto">create</property>

Not sure whether you need such (above) property better you comment it and then try.

I assume your tables are already created and you just need to do the insertion.

Sudhir

I m not getting any error messages. when i give <property name="hibernate.hbm2ddl.auto">update</property> then table s getting created.bit no inserting.Strnge thing is its working fine with Mysql4.0.26

This is my code:

Example.java
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();
//Create new instance of Contact and set values in it by reading them from form object
System.out.println("Inserting Record");
Contact contact = new Contact();
contact.setId(123);
contact.setFirstName("shah");
contact.setLastName("shah");
contact.setEmail("deepak_38@yahoo.com");
session.save(contact);
hibernate.cfg.xml
<?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.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql:///hibernate</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password"></property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- Mapping files -->
<mapping resource="contact.hbm.xml"/>

</session-factory>
</hibernate-configuration>

contact.hbm.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="Contact" table="CONTACT">
<id name="id" type="long" 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>

You are missing the session.getTransaction().commit() here.

It was probably working under MySQL 4.0 because you were using MyISAM tables, which do not support transactions.