《JSP数据库系统开发案例精选》 第六章 人力资源管理系统 运行出错问题
发表在JavaWeb图书答疑 2009-05-21
是否精华
版块置顶:
我按照视频中的做法把数据库配置好了。出现了登陆界面,输入帐号密码后出现如下错误:
HTTP Status 500 - 

--------------------------------------------------------------------------------

type Exception report

message 

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]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)
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.

分享到:
精彩评论 3
无语_mrkj
学分:3155 LV11
2009-05-22
沙发
请安装SQL Server 2000的SP4补下。
注意:在安装SQL Server 2000的SP4补丁时,默认执行的是解压缩操作,在解压完成后,还需要要解压缩的位置找到setup.bat文件,运行该文件进行正式安装。并且在安装前,要保存SQL Server的企业管理器中的没有被置疑的数据库。
说明:被置疑的数据库就是数据库名称后面没标记(置疑)二字的数据库。
坏孩子的天空
学分:0 LV1
2009-05-22
板凳
解决了!呵呵!衷心感谢老师的帮助 ~~~感激涕零!!!
无语_mrkj
学分:3155 LV11
2009-05-23
地板
不客气,结贴!
首页上一页 1 下一页尾页 3 条记录 1/1页
手机同步功能介绍
友情提示:以下图书配套资源能够实现手机同步功能
明日微信公众号
明日之星 明日之星编程特训营
客服热线(每日9:00-17:00)
400 675 1066
mingrisoft@mingrisoft.com
吉林省明日科技有限公司Copyright ©2007-2022,mingrisoft.com, All Rights Reserved长春市北湖科技开发区盛北大街3333号长春北湖科技园项目一期A10号楼四、五层
吉ICP备10002740号-2吉公网安备22010202000132经营性网站备案信息 营业执照