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