|
From: Nils O. <po...@ho...> - 2015-01-07 14:57:09
|
Hi, I wonder if anyone of you have had experiences setting up the oreka (open source) database in sql server, and installing jdbc driver for MSSQL and changing the hibernate settings appropriate for MSSQL, in the database.hbm.xml file? I have tried this using SQL Server 2012 and jdbc driver 4.1.5504.0, but it does not work: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="hibernate.connection.maxconnections">100</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost/oreka</property> <property name="hibernate.connection.password">mypassword</property> <property name="hibernate.connection.username">myuser</property> <property name="hibernate.hbm2ddl.auto">update</property> <!-- update, create, create-drop --> <property name="hibernate.show_sql">false</property> <property name="hibernate.jdbc.use_scrollable_resultset">true</property> <property name="hibernate.max_fetch_depth">1</property> <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property> </session-factory> </hibernate-configuration> Regards Nils |