[jboss-user] [EJB 3.0] - Re: How do I set hibernate.dialect property outside of persi
robertxlongo@gmail.com
do-not-reply at jboss.com
Fri Aug 29 10:08:10 EDT 2008
It seems that it is not necessary to set this "hibernate.dialect" property. The correct dialect is chosen by the framework at run-time. For example, if I have a mysql-ds.xml file with the following contents:
| <datasources>
| <local-tx-datasource>
| <jndi-name>MyDS</jndi-name>
| <connection-url>jdbc:mysql://localhost:3306/mydb</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| ...
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| </local-tx-datasource>
| </datasources>
|
... then I receive the following output in the console:
| [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
| [InjectedDataSourceConnectionProvider] Using provided datasource
| [SettingsFactory] RDBMS: MySQL, version: 5.0.51b-community-nt
| [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
| [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
|
Note that, if you don't include the database driver in deploy/lib, JBoss will throw an exception reporting that the hibernate dialect must be set. We made this mistake and the exception lead us to believe that we had to set the "hibernate.dialect" property.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4173337#4173337
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4173337
More information about the jboss-user
mailing list