Hi EveryOne,
I am newbi in Hibernate :P
I wanna make Mysql table that have InnoDb type and charset utf8 but I don't know where I shoud set the setting.
I see some where said that must set (delimiter=type=InnoDB) but where? (I just have a hibernate.cfg.XMl no any .xml file for hibernate)
i dun want set mysql.ini file that default setting was InnoDB and UTF-8 I wanna put this setting in my hibernate.
TanX in advance

Hi,

If you specify:
org.hibernate.dialect.MySQL5InnoDBDialect
as the hibernate.dialect property then Hibernate should create InnoDb type tables (presuming you are using a late enough version of MySql).

You should probably manually create the database in order to specify the charset.

--
Stephen Souness

Tanx man I use this before but I have Problem by hibernate.dialect.
When I use this property in hibernate.cfg.xml it's make my table InnoDB but cant Insert any Data in my table,
my code work well when i use <<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>> and i can Insert into table but when I use
< <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>> it's create InnoDB table but didn't insert any rows!!!
should I change my code when I use (org.hibernate.dialect.MySQL5InnoDBDialect)?

I also find something strange,
When I Use <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> and my code Create Table (MyISAM type) I can also insert data into table by PhpMyAdmin Or SQLYoq but when I use <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> it's create table InnoDB Type I can't Insert Data by phpmyadmin or SQLYoq (even My code dun Insert Rows), it's said Error Code : 1205
Lock wait timeout exceeded; try restarting transaction

when I use Transaction tx = null;
tx = session.beginTransaction();
tx.commit();
and put my code