今天做了一个用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'?>
- "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="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.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>
配置成功,进行程序,哦了!