I am changing configuration of hibernate 3.0 from MSSQL to MySQL. This is done but Hibernate is not generating proper queries for MySQL. I have also updated my configuration file with MySql dialect and Mysql jdbc connector. The problem i am facing here is --

I have one table only with PK with one more column(FK of other table). Now while inserting data in that table it is generating query like --

insert in to table_name default values

This query works for MSSql but not with MySQL. Please let me know any solution for this. How the Hibernate will generate right query for MySQL?

What's the version of MySQL you are using? What's the storage engine (MyISAM, InnoDB, ...)? What's the dialect you are using? Can you post the full query that Hibernate is generating (see the "show_sql" option).