日期:2014-05-18  浏览次数:20662 次

JSP连接SQL数据库,求救!!!
小弟初学JSP,遇到JSP连接SQL数据库的问题,请教各位大哥! 万分感谢!

使用的是Winows 2003 标准服务器版的操作系统,SQL Server 2000, JDK 1.5 , Tomcat 6.0(无须安装,zip的,解压配置好环境后就可以使用)

连接时出现的错误如下:

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: Unable to compile class for JSP
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:574)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause 

java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence.
org.apache.jasper.xmlparser.UTF8Reader.invalidByte(UTF8Reader.java:621)
org.apache.jasper.xmlparser.UTF8Reader.read(UTF8Reader.java:492)
org.apache.jasper.xmlparser.XMLEncodingDetector.load(XMLEncodingDetector.java:1012)
org.apache.jasper.xmlparser.XMLEncodingDetector.skipString(XMLEncodingDetector.java:978)
org.apache.jasper.xmlparser.XMLEncodingDetector.scanXMLDecl(XMLEncodingDetector.java:1221)
org.apache.jasper.xmlparser.XMLEncodingDetector.getEncoding(XMLEncodingDetector.java:123)
org.apache.jasper.xmlparser.XMLEncodingDetector.getEncoding(XMLEncodingDetector.java:111)
org.apache.jasper.compiler.ParserController.determineSyntaxAndEncoding(ParserController.java:309)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:173)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:167)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:306)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.


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



请问各位大哥,从这些错误信息中能看出是什么地方的问题吗? 谢谢 谢谢 万分感谢!



------解决方案--------------------
分析一下此类情况~
1.JDK是否配置成功 做下测试
2.TOMCAT是否配置成功 做下测试
3.SQL SERVER 是否已经打到 SP3 查看版本号
以上条件如果都满足,你就可以把范围缩小到你连接SQL的方法有问题上了
然后把你连接SQL的方法贴出来,再分析一下吧!
------解决方案--------------------
java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence. 
看这个
------解决方案--------------------
你的主要原因是这个:
java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence. 
你的JSP页面中有UTF-8不识别的编码,看一下,是不那里写了特殊字符了!
我的异常网推荐解决方案:The server encoun