Hi,
I found out this particular issue withi hib3.0 when using it with mysql5.0
Whenever i try to write(insert) some data it never writes , but reading from the tables works fine.
The same hib 3.0 works fine with mysql4.0.
Now that might seem to be mysql problem.

However interesting part being that a normal jdbc call to mysql 5.0 works fines without any issues.
Also if u try to write using a connection from the Session class within the hib 3.0 and write a normal Statement and a query , it also won't write.
Any suggestion???

What does "won't write" mean?

I am assuming you are not committing transactions, but there is not *nearly* enough information here to really tell for sure.

Hi,
What did i mean by "write" is infact insert of data into the table.
Given below is the part of the code.
It is very simple code as i was just testing out hib 3.0 with mysql5.0
No exceptions are generated .


Session session = null;

try{

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();

Contact contact = new Contact();
contact.setId(4);
contact.setFirstName("test");
session.save(contact);

}catch(Exception e){

System.out.println(e.toString());
}finally{

try {
session.flush();
session.close();
} catch (HibernateException e1) {

System.out.println(e1.toString());
}

This part of code works fine withi mysql 4.0, no issues at all.

Thanks

As Steve said, you're not committing your transactions.
In MySQL 4 it probably worked, because of using a table type like MyISAM which does not support transactions. I don't know which is the default table type for MySQL 5, maybe it's InnoDB which supports transactions. So, in that case, you need to commit your transaction.



Best regards
Sven

It's a common error, always commit your transactions!
Ah! if you want to "forget" the task of commit transactions and only put save() or delete() to your classes, uses the HibernateTemplate() of the Spring Framework to control the lifecycle of your entities. More details of this in http://www.springframework.org

Good luck!

Hi,
Yup that suggestion worked.
Thanks Steve and Sven for the solution.
And also thanks Daniel for that extra info
:)
Have a nice day