java项目开发实力自学手册____蜀玉网络购物商城
发表在JavaWeb图书答疑 2009-06-09
是否精华
版块置顶:
我是个新手,在自学,请GGMM指点指点.我是按下面要求做的,但还是有点错误,不知道怎么做?

(1)我的系统不是windows 2000 server,但我安装SQL Server 2000的SP4补丁。
(2)在安装SQL server 2000时,采用的是混合验证模式,并且登录用户为sa,空密码。
(3)SQL Server 2000数据库驱动包拷贝到程序的lib文件夹中。
(4)正确附加数据库


具体错误如下:
       客户端错误:
HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968)
org.apache.jsp.index_jsp._jspService(index_jsp.java:141)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

java.lang.NullPointerException
com.dao.LinkDao.selectLink(LinkDao.java:117)
org.apache.jsp.topOne_jsp._jspService(topOne_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968)
org.apache.jsp.index_jsp._jspService(index_jsp.java:141)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
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.



       服务器端错误:
2009-6-9 9:41:09 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\java\jdk1.6.0_10\bin;D:\java\apache-tomcat-6.0.18\bin
2009-6-9 9:41:09 org.apache.coyote.http11.Http11Protocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2009-6-9 9:41:09 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2231 ms
2009-6-9 9:41:10 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2009-6-9 9:41:10 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.18
2009-6-9 9:41:11 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2009-6-9 9:41:11 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
log4j:WARN No appenders could be found for logger (org.apache.struts.util.PropertyMessageResources).
log4j:WARN Please initialize the log4j system properly.
2009-6-9 9:41:14 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2009-6-9 9:41:14 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2009-6-9 9:41:14 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/109  config=null
2009-6-9 9:41:14 org.apache.catalina.startup.Catalina start
信息: Server startup in 5166 ms
数据库加载失败
2009-6-9 9:41:45 org.apache.catalina.core.ApplicationDispatcher invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at com.dao.LinkDao.selectLink(LinkDao.java:117)
at org.apache.jsp.topOne_jsp._jspService(topOne_jsp.java:70)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:141)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
2009-6-9 9:41:45 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at com.dao.LinkDao.selectLink(LinkDao.java:117)
at org.apache.jsp.topOne_jsp._jspService(topOne_jsp.java:70)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:968)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:141)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)


我不知道怎么数据库还是加载不上,我装了驱动也加载了数据库了呀,不知道是不是因为我用的软件都是网上搜来的安装SQL时出了两个错误,具体什么错误我没抓下来,但还是安装成功了,后来安装sp4补丁也没问题,我见其他网友也有和我类似问题应该不是我刚才说的问题吧.谢谢指教!
分享到:
精彩评论 3
无语_mrkj
学分:3155 LV11
2009-06-09
沙发
从这个错误信息中看,还是数据库没有连接成功。
您可以进行以下操作看一下SP4补丁是否安装成功:
选择“开始”/“运行”命令,在弹出的对话框中输入cmd,进入到DOS窗口,然后在命令提示符下输入netstat -an命令并回车,看看有没有类似下面的信息,如果没有,则表示SP4没有安装成功。
 TCP    127.0.0.1:1433      LISTENING
那么请确认以下内容:
在安装SQL Server 2000的SP4补丁时,默认执行的是解压缩操作,在解压完成后,还需要要解压缩的位置找到setup.bat文件,运行该文件进行正式安装。并且在安装前,要保存SQL Server的企业管理器中的没有被置疑的数据库。
说明:被置疑的数据库就是数据库名称后面没标记(置疑)二字的数据库。
a25356235
学分:0 LV1
2009-06-10
板凳
谢谢1楼的GG或JJ我输入netstat -an结果如下
Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:25             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:80             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:443            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1025           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING
  TCP    117.42.33.154:1107     222.186.11.19:80       CLOSE_WAIT
  TCP    117.42.33.154:1394     222.161.162.14:4234    SYN_SENT
  TCP    127.0.0.1:1143         127.0.0.1:1144         ESTABLISHED
  TCP    127.0.0.1:1144         127.0.0.1:1143         ESTABLISHED
  TCP    127.0.0.1:5152         0.0.0.0:0              LISTENING
  TCP    127.0.0.1:5152         127.0.0.1:1355         CLOSE_WAIT
  TCP    192.168.0.11:139       0.0.0.0:0              LISTENING
  TCP    192.168.0.11:1389      192.168.0.11:445       TIME_WAIT
  TCP    192.168.0.11:1392      192.168.0.11:445       TIME_WAIT
  TCP    192.168.0.11:1393      192.168.0.11:445       TIME_WAIT
  UDP    0.0.0.0:445            *:*
  UDP    0.0.0.0:500            *:*
  UDP    0.0.0.0:1063           *:*
  UDP    0.0.0.0:1064           *:*
  UDP    0.0.0.0:1065           *:*
  UDP    0.0.0.0:1066           *:*
  UDP    0.0.0.0:1090           *:*
  UDP    0.0.0.0:1091           *:*
  UDP    0.0.0.0:1092           *:*
  UDP    0.0.0.0:1093           *:*
  UDP    0.0.0.0:1108           *:*
  UDP    0.0.0.0:1109           *:*
  UDP    0.0.0.0:1110           *:*
  UDP    0.0.0.0:1111           *:*
  UDP    0.0.0.0:1112           *:*
  UDP    0.0.0.0:1113           *:*
  UDP    0.0.0.0:1114           *:*
  UDP    0.0.0.0:1115           *:*
  UDP    0.0.0.0:1128           *:*
  UDP    0.0.0.0:1129           *:*
  UDP    0.0.0.0:1130           *:*
  UDP    0.0.0.0:1131           *:*
  UDP    0.0.0.0:1434           *:*
  UDP    0.0.0.0:3456           *:*
  UDP    0.0.0.0:4500           *:*
  UDP    0.0.0.0:55979          *:*
  UDP    117.42.33.154:123      *:*
  UDP    117.42.33.154:1900     *:*
  UDP    127.0.0.1:123          *:*
  UDP    127.0.0.1:1047         *:*
  UDP    127.0.0.1:1050         *:*
  UDP    127.0.0.1:1068         *:*
  UDP    127.0.0.1:1095         *:*
  UDP    127.0.0.1:1900         *:*
  UDP    192.168.0.11:123       *:*
  UDP    192.168.0.11:137       *:*
  UDP    192.168.0.11:138       *:*
  UDP    192.168.0.11:1900      *:*

有TCP 127.0.0.1:1433但不是LISTENING
我在查询分析器里执行:select serverproperty('productlevel')
结果是sp4版本应该对,我这人真笨,我本来要重新装过,在做一次,可是这次连运行都不能运行了有错误。
Description Resource Path Location Type
File cannot be resolved to a type goodsDealPicture.jsp marketplace/WebRoot line 22 JSP Problem
File cannot be resolved to a type linkDeal.jsp marketplace/WebRoot/background/link line 30 JSP Problem
File cannot be resolved to a type linkDealPicture.jsp marketplace/WebRoot line 25 JSP Problem
The import com.jspsmart cannot be resolved goodsDealPicture.jsp marketplace/WebRoot line 3 JSP Problem
The import com.jspsmart cannot be resolved linkDeal.jsp marketplace/WebRoot/background/link line 3 JSP Problem
The import com.jspsmart cannot be resolved linkDealPicture.jsp marketplace/WebRoot line 3 JSP Problem
Undefined type: com.jspsmart.upload.SmartUpload goodsDealPicture.jsp marketplace/WebRoot line 5 JSP Problem
Undefined type: com.jspsmart.upload.SmartUpload goodsSuccess.jsp marketplace/WebRoot/background/goods line 5 JSP Problem
Undefined type: com.jspsmart.upload.SmartUpload linkDeal.jsp marketplace/WebRoot/background/link line 4 JSP Problem
Undefined type: com.jspsmart.upload.SmartUpload linkDealPicture.jsp marketplace/WebRoot line 5 JSP Problem
Undefined type: com.jspsmart.upload.SmartUpload linkSuccess.jsp marketplace/WebRoot/background/link line 5 JSP Problem
Undefined type: com.jspsmart.upload.SmartUpload smallTypeSuccess.jsp marketplace/WebRoot/background/smallType line 5 JSP Problem
up cannot be resolved goodsDealPicture.jsp marketplace/WebRoot line 15 JSP Problem
up cannot be resolved goodsDealPicture.jsp marketplace/WebRoot line 16 JSP Problem
up cannot be resolved goodsDealPicture.jsp marketplace/WebRoot line 17 JSP Problem
up cannot be resolved goodsDealPicture.jsp marketplace/WebRoot line 18 JSP Problem
up cannot be resolved goodsDealPicture.jsp marketplace/WebRoot line 22 JSP Problem
up cannot be resolved linkDeal.jsp marketplace/WebRoot/background/link line 16 JSP Problem
up cannot be resolved linkDeal.jsp marketplace/WebRoot/background/link line 17 JSP Problem
up cannot be resolved linkDeal.jsp marketplace/WebRoot/background/link line 18 JSP Problem
up cannot be resolved linkDeal.jsp marketplace/WebRoot/background/link line 19 JSP Problem
up cannot be resolved linkDeal.jsp marketplace/WebRoot/background/link line 30 JSP Problem
up cannot be resolved linkDealPicture.jsp marketplace/WebRoot line 18 JSP Problem
up cannot be resolved linkDealPicture.jsp marketplace/WebRoot line 19 JSP Problem
up cannot be resolved linkDealPicture.jsp marketplace/WebRoot line 20 JSP Problem
up cannot be resolved linkDealPicture.jsp marketplace/WebRoot line 21 JSP Problem
up cannot be resolved linkDealPicture.jsp marketplace/WebRoot line 25 JSP Problem
因该是jspSmartUpload引人错了,我忘了上次怎么引入的啦,这次我是把Struts,SQLServer_Driver,jspSmartUpload都建成
User Library引进的,不知道这样引有什么不对,我的包都是下的本网站的Java项目开发实例自学手册类库。

给你添麻烦啦,谢谢!
a25356235
学分:0 LV1
2009-06-10
地板
不好意思,我应该把SQLServer_Driver复制到web\lib,我把引入的SQLServer_Driver包删掉后把它下面的jar复制到lib下结果还是那些错误。
首页上一页 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经营性网站备案信息 营业执照