javax.servlet.ServletException: net.sf.hibernate.JDBCException: Cannot open connection ？？？？

Question

我在csdn中下载了    JSP数据库系统开发案例精选（人力资源管理系统）
1、附加了personManage 数据库  查看了里面的用户名有admin 和密码admin
2、修改了hibernate.cfg.xml文件
name="hibernate.connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PersonManage;user=sa;password=123456;</property>  <property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>  <property name="hibernate.connection.username">sa</property>  <property name="hibernate.connection.password"/>123456</property>  但是登录的时候提示javax.servlet.ServletException: net.sf.hibernate.JDBCException: Cannot open connection 不知道哪位高人提示一下 还有哪里没改到的？？？
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: net.sf.hibernate.JDBCException: Cannot open connection
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
com.bOS.Action.ActionServlet.process(ActionServlet.java:21)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause net.sf.hibernate.JDBCException: Cannot open connection
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:281)
net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2195)
com.bOS.bPRO_PersonManage.service.UsersDao.logonUsers(UsersDao.java:78)
com.bOS.bPRO_PersonManage.action.UsersAction.logon(UsersAction.java:111)
com.bOS.bPRO_PersonManage.action.UsersAction.execute(UsersAction.java:41)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
com.bOS.Action.ActionServlet.process(ActionServlet.java:21)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:95)
net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3264)
net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3244)
net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2195)
com.bOS.bPRO_PersonManage.service.UsersDao.logonUsers(UsersDao.java:78)
com.bOS.bPRO_PersonManage.action.UsersAction.logon(UsersAction.java:111)
com.bOS.bPRO_PersonManage.action.UsersAction.execute(UsersAction.java:41)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
com.bOS.Action.ActionServlet.process(ActionServlet.java:21)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.

Answer 1

name="hibernate.connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PersonManage;user=sa;password=123456; </property> ??????????????????你怎么配置了两次数据库用户名和密码?

Answer 2

是啊  ！  我解压缩后的hibernate.cfg.xml文件中
name="hibernate.connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PersonManage;user=sa;password=123456; </property> <property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver </property> <property name="hibernate.connection.username">sa </property> <property name="hibernate.connection.password"/>123456 </property> 原来红色部分都是空的  我加上我自己的sql的sa密码  难道有错？还是要怎么改？  请明示！

Answer 3

你把下面的改改，去掉用户名和密码
<property name="hibernate.connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PersonManage;user=sa;password=123456; 
</property>

Answer 4

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。确认你的sa密码是123456，密码正确么？还要看看 数据库的登陆模式 ，数据库/右键/属性   一定要设置为混合登陆模式

Answer 5

搞定  原来需要修改两个地方的hibernate.cfg.xml

Answer 6

不是要修改两个地方的,你如果编译过后,就行了,不用改两次,服务器最后还是找CLASS文件夹下面的那些配置文件...

Answer 7

我最近才下的这个JSP应用——JSP数据库系统开发案例精选（人力资源管理系统），也遇到了类似问题，然后照着修改了两个hibernate.cfg.xml文件，可还是出现net.sf.hibernate.JDBCException: Cannot open connection这个问题，麻烦那个高手解答下，急急急啊~~多谢啦