新手Hibernate配置SQLServer2000数据库的问题

[漫游太空]

初次在hibernate.cfg.xml中配置连接SQLServer2000，已安装好SQLServer2000 sp3补丁，配置参数如下：

<hibernate-configuration>
<session-factory>
<property name="myeclipse.connection.profile">msdriver</property>
<property name="connection.driver_class">
com.microsoft.jdbc.sqlserver.SQLServerDriver
</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.url">
jdbc:microsoft:sqlserver://localhost:1433;selectMethod=cursor;
DatabaseName=kdb;
</property>
<property name="dialect">
org.hibernate.dialect.SQLServerDialect
</property>

<mapping resource="app/User.hbm.xml" />
</session-factory>

</hibernate-configuration>

运行后出现以下错误：

exception

org.hibernate.exception.JDBCConnectionException: Cannot open connection
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
app.testServlet.doGet(testServlet.java:36)
app.testServlet.doPost(testServlet.java:52)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
app.testServlet.doGet(testServlet.java:36)
app.testServlet.doPost(testServlet.java:52)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

找了很久都不知道是什么错误？请高手指点一下

[老紫竹]

1 装 SP4
2 到精华区看文章 http://topic.csdn.net/u/20080405/06/e72fb958-5b30-4d7e-a59c-df00d96d29f6.html

[漫游太空]

多谢楼上指点，问题已解决，装了sp4之后就可以了