???我的连接字符串出了什么问题???
shely 2004-10-21 10:59:00 以下是我的代码,环境为Tomcat5+sqlserver2000,
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String User="sa";
String Password="tang";
String url="jdbc:microsoft:sqlserver://OFFICE\TEST1:1433;DatabaseName=jsp_test";
Connection con=java.sql.DriverManager.getConnection(url,User,Password);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
出错提示为:
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
An error occurred at line: 23 in the jsp file: /data_insert.jsp
Generated servlet error:
[javac] Compiling 1 source file
D:\Program Files\Apache\Tomcat 5.0\work\Catalina\localhost\test\org\apache\jsp\data_005finsert_jsp.java:66: illegal escape character
An error occurred at line: 23 in the jsp file: /data_insert.jsp
Generated servlet error:
String url="jdbc:microsoft:sqlserver://OFFICE\TEST1:1433;DatabaseName=jsp_test";
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:127)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:351)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:458)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
是://OFFICE\TEST1:1433这里出了问题吗?我不知道该怎么改。我的数据库服务器是本地。我的机器名是OFFICE。TEST1是我在装sqlserver2000时创建的实例