今天做了一个用hibernate连接sql server2000数据库的程序,遇到了一些问题,在经过一个多小时的调试下终于解决了.将解决问题方法在这里记录一下备以后查阅:

问题出现的原因就是用微软提供的jar包.在hibernate.cfg.xml文件中也是按照该包的配置方法进行配置,结果总是出错,具体的出错信息就是找不到jar包里的方法.于是把错误消息到网上查找,在一个帖子上发现最好不要用微软提供的jar包,用jtds.jar.于是就上网查找jtds.jar的下载网址,找到后下载部署的工程中.

接下来就是按照jtds.jar的文件方式进行配置hibernate.cfg.xml文件了.配置如下:

xml 代码

xml version='1.0' encoding='utf-8'?>
<!--CTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'property>
<!-- property name="hibernate.connection.datasource">java:comp/env/jdbc/docMgrDS
<property name="dialect">net.sf.hibernate.dialect.SQLServerDialectproperty>
<property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driverproperty>
<property name="hibernate.connection.url">jdbc:jtds:sqlserver://10.64.86.34:1433/eipproperty>
<property name="hibernate.connection.username">saproperty>
<property name="hibernate.connection.password">capinfoproperty>
<property name="connection.pool_size">2property>
<property name="statement_cache.size">25property>
<!-- property name="connection.provider_class">net.sf.hibernate.connection.DatasourceConnectionProvider
<property name="connection.provider_class">net.sf.hibernate.connection.DriverManagerConnectionProviderproperty>
<property name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactoryproperty>
<property name="show_sql">trueproperty>
<property name="jdbc.fetch_size">50property>
<property name="jdbc.batch_size">25property>
<property name="hibernate.jdbc.use_scrollable_resultset">falseproperty>
<property name="jdbc.use_streams_for_binary">trueproperty>
<property name="use_outer_join">trueproperty>
<property name="max_fetch_depth">1property>
<property name="cache.provider_class">net.sf.hibernate.cache.HashtableCacheProviderproperty>
<property name="hibernate.cache.use_query">trueproperty>
<mapping resource="com/capinfo/edu/usersys/UserObject.hbm.xml" />
session-factory>
hibernate-configuration>

配置成功,进行程序,哦了!

[@more@]

ITPub博客

Hibernate配置连接SQL SERVER2000

最新文章