24,923
社区成员
发帖
与我相关
我的任务
分享求助！紧急！！
Jsp＋Tomcat＋Sql Server2000
总是不能访问数据库？SQL Server 2000 Driver for JDBC Service 和SQL Server 2000 Driver for JDBC Service Pack 3 和SQL Server 2000 的补丁SP4都已经安装好了,classpath也配好了。（Jsp没什么问题，连接数据库就出错。）
出错如下：
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:565)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:296)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence.
org.apache.jasper.xmlparser.UTF8Reader.invalidByte(UTF8Reader.java:620)
org.apache.jasper.xmlparser.UTF8Reader.read(UTF8Reader.java:491)
org.apache.jasper.xmlparser.XMLEncodingDetector.load(XMLEncodingDetector.java:999)
org.apache.jasper.xmlparser.XMLEncodingDetector.skipString(XMLEncodingDetector.java:965)
org.apache.jasper.xmlparser.XMLEncodingDetector.scanXMLDecl(XMLEncodingDetector.java:1208)
org.apache.jasper.xmlparser.XMLEncodingDetector.getEncoding(XMLEncodingDetector.java:120)
org.apache.jasper.xmlparser.XMLEncodingDetector.getEncoding(XMLEncodingDetector.java:108)
org.apache.jasper.compiler.ParserController.determineSyntaxAndEncoding(ParserController.java:304)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:169)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:100)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:146)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:296)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
...全文
请发表友善的回复…
发表回复
secats 2006-08-06
- 打赏
- 举报
测试代码如下：
<％@ page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html;charset=gb2312" ％>
<html>
<body>
<％ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=byi_new";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select customerid,tel from customers";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) { ％>
您的第一个字段内容为：<％=rs.getString(1)％><br>
您的第二个字段内容为：<％=rs.getString(2)％><br>
<％ } ％>
<％ out.print("数据库操作成功，恭喜你"); ％>
<％ rs.close();
stmt.close();
conn.close();
％>
</body>
</html>
谁能帮帮我！！谢谢大家了！
<％@ page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html;charset=gb2312" ％>
<html>
<body>
<％ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=byi_new";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select customerid,tel from customers";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) { ％>
您的第一个字段内容为：<％=rs.getString(1)％><br>
您的第二个字段内容为：<％=rs.getString(2)％><br>
<％ } ％>
<％ out.print("数据库操作成功，恭喜你"); ％>
<％ rs.close();
stmt.close();
conn.close();
％>
</body>
</html>
谁能帮帮我！！谢谢大家了！
