Hibernate配置连接SQL SERVER2000

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

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

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

xml 代码

1. <!--sp--&gtxml version='1.0' encoding='utf-8'?>
2. <!--CTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
3. "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
5. <hibernate-configuration>
7. <session-factory>
9. <!-- properties --&gt
10. <!-- define query language constants / function names --&gt
11. <property name="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'property>
12. <!--JNDI Datasource --&gt
13. <!-- property name="hibernate.connection.datasource">java:comp/env/jdbc/docMgrDS
14. <!-- SqlServer--&gt
16. <property name="dialect">net.sf.hibernate.dialect.SQLServerDialectproperty>
17. <!-- net.sf.hibernate.dialect.OracleDialect--&gt
18. <property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driverproperty>
19. <!-- oracle.jdbc.driver.OracleDriver--&gt
20. <property name="hibernate.connection.url">jdbc:jtds:sqlserver://10.64.86.34:1433/eipproperty>
21. <!-- jdbc:oracle:thin:@192.168.3.6:1521:orcl--&gt
22. <property name="hibernate.connection.username">saproperty>
23. <property name="hibernate.connection.password">capinfoproperty>
24. <!-- Hibernate Connection Pool --&gt
25. <property name="connection.pool_size">2property>
26. <property name="statement_cache.size">25property>
28. <!-- property name="connection.provider_class">net.sf.hibernate.connection.DatasourceConnectionProvider
29. <property name="connection.provider_class">net.sf.hibernate.connection.DriverManagerConnectionProviderproperty>
30. <!-- the Transaction API abstracts application code from the underlying JTA or JDBC transactions --&gt
31. <property name="transaction.factory_class">net.sf.hibernate.transaction.JDBCTransactionFactoryproperty>
32. <!-- print all generated SQL to the console --&gt
33. <property name="show_sql">trueproperty>
34. <!-- set the JDBC fetch size --&gt
35. <property name="jdbc.fetch_size">50property>
36. <!-- set the maximum JDBC 2 batch size (a nonzero value enables batching) --&gt
37. <property name="jdbc.batch_size">25property>
38. <!-- enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default) --&gt
39. <property name="hibernate.jdbc.use_scrollable_resultset">falseproperty>
40. <!-- use streams when writing binary types to / from JDBC --&gt
41. <property name="jdbc.use_streams_for_binary">trueproperty>
42. <!-- enable outerjoin fetching (specifying a Dialect will cause Hibernate to use sensible default) --&gt
43. <property name="use_outer_join">trueproperty>
46. <!-- --&gt
47. <property name="max_fetch_depth">1property>
48. <!-- --&gt
49. <property name="cache.provider_class">net.sf.hibernate.cache.HashtableCacheProviderproperty>
50. <!-- --&gt
51. <property name="hibernate.cache.use_query">trueproperty>
53. <!-- Mapping files --&gt
54. <!-- usersys --&gt
55. <mapping resource="com/capinfo/edu/usersys/UserObject.hbm.xml" />
56. session-factory>
58. hibernate-configuration>

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

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/800861/viewspace-922098/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/800861/viewspace-922098/