以前一直用oracle作为首选的数据库,最近一个小软件,打算用sqlserver
服务器上装了sqlserver 2000,2005,2008,3种数据库,多实例,折腾了很久才解决
具体方法是:
删除sqljdbc4.jar包下面的meta-info文件夹的3个定义文件。
最后贴上链接成功的配置语句:
hibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect
hibernate.hbm2ddl.auto=none
hibernate.show_sql=true
hibernate.query.substitutions=true 1, false 0
hibernate.default_batch_fetch_size=16
hibernate.max_fetch_depth=2
hibernate.bytecode.use_reflection_optimizer=true
hibernate.cache.use_second_level_cache=true
hibernate.cache.use_query_cache=true
hibernate.cache.region.factory_class=org.hibernate.cache.EhCacheRegionFactory
net.sf.ehcache.configurationResourceName=/ehcache_hibernate.xml
hibernate.cache.use_structured_entries=true
hibernate.generate_statistics=true
connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
connection.url=jdbc\:sqlserver\://192.168.19.40\\SQL2008;DatabaseName\=BookManage
connection.username=baiyang
connection.password=baiyang1234
proxool.maximum.connection.count=40
proxool.minimum.connection.count=5
proxool.statistics=1m,15m,1h,1d
proxool.simultaneous.build.throttle=30