Hib & MySQL-forced to choose between InnoDB and MyISAM?

hbnusr · **Joined:** Wed Jun 28, 2006 1:03 am **Posts:** 14

I downloaded a fresh Hibernate and unzipped it.
In hibernate-3.1/etc/hibernate.properties, we have:

Code:

## MySQL

#hibernate.dialect org.hibernate.dialect.MySQLDialect
#hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
#hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect
#hibernate.connection.driver_class com.mysql.jdbc.Driver
#hibernate.connection.url jdbc:mysql:///test
#hibernate.connection.username gavin
#hibernate.connection.password

It looks like I have to choose between InnoDB and MyISAM. What if some of my tables are InnoDB and some MyISAM?

Thanks.

pepelnm · **Posted:** Wed Aug 23, 2006 7:04 am

What with hibernate.dialect org.hibernate.dialect.MySQLDialect?

hbnusr · **Joined:** Wed Jun 28, 2006 1:03 am **Posts:** 14

What is actually the significance between those 3 ?
What is the difference ?
What do I get/What does Hibernate give me if I chose those more specific ones ?

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

I believe the differences are in Schema Generation!

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

I believe the differences are in Schema Generation!