主页

？？？我的连接字符串出了什么问题？？？

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时创建的实例

...全文

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

shely 2004-10-21

在‘企业管理器’中，我的localhost启动不了。我也不知道什么原因。
怎样可以查看到我的端口是不是1433

回复赞

shely 2004-10-21

我用://OFFICE/TEST1，//OFFICE\\TEST1试过了，也不行。
出错为：
description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.data_005finsert_jsp._jspService(data_005finsert_jsp.java:86)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
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)

回复赞

yunzhiguang 2004-10-21

url="jdbc:microsoft:sqlserver://OFFICE/TEST1:1433;DatabaseName=jsp_test";
应该是这样把.
con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/julin", "root", "");

回复赞