One comment only: I stopped using hibernate.dialect in "persistence.xml" file and now can switch SQL server by changing of datasource only.
But be warned - Mysql has two dialects (myISAM and Innodb) and Hibernate cannot determine what you can (or want) to use. Some time ago was here some more information about Mysql and Hibernate dialect. | <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /> | Leonell View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3940954#3940954 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3940954 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user