Hello!
I want to configure JBoss jbpm to works with mySQL. In the hibernate.cfg file I put the following:
Code:
<!-- hibernate dialect -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- JDBC connection properties (begin) -->
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpm</property>
<property name="hibernate.connection.username">xxxx</property>
<property name="hibernate.connection.password">xxxxx</property>
<!-- JDBC connection properties (end) -->
<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>
<property name="hibernate.use_sql_comments">true</property>
But in the server log I can see that hibernate uses HSqlDialect, no MySQLDialect. Hibernate creates a new temporal file with HSqlDialect :( . I have look in all the hibernate.cfg files and these are correct. I have look in some jar files to see if they have hibernate.cfg files but I don't find any. Someone knows in what file it's the problem or how can I solucionate?
Thanks