Topic: 救命啊~~~JSP连接SQL数据库的问题~

  Print this page

1.救命啊~~~JSP连接SQL数据库的问题~ Copy to clipboard
Posted by: naughty009
Posted on: 2005-09-24 20:54

以下是我的JSP:
<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*"%>

<html>

<body>

<%

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";

String user="sa";

String password="";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

%>

<%out.print("数据库操作成功,恭喜你");%>

<%

stmt.close();

conn.close();

%>

</body>

</html>
出现的错误是:

type Exception report

message

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:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.connsql_jsp._jspService(connsql_jsp.java:89)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.connsql_jsp._jspService(connsql_jsp.java:61)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

我将mssqlserver.jar,msbase.jar,msutil.jar都放在我的网站目录的WEB-INF\lib下了,
还是不行啊,只放mssqlserver.jar这个就出现
以下错误:

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

exception

javax.servlet.ServletException: com/microsoft/jdbc/base/BaseDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.connsql_jsp._jspService(connsql_jsp.java:89)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NoClassDefFoundError: com/microsoft/jdbc/base/BaseDriver
java.lang.ClassLoader.defineClass0(Native Method)
java.lang.ClassLoader.defineClass(ClassLoader.java:537)
java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)
org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1634)
org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:860)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1307)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1189)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:148)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:69)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:141)
org.apache.jsp.connsql_jsp._jspService(connsql_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

我只想实现连接成功而已~
请大虾们帮帮手啊~~~~~~~

2.Re:救命啊~~~JSP连接SQL数据库的问题~ [Re: naughty009] Copy to clipboard
Posted by: YuLimin
Posted on: 2005-09-25 22:51

Error establishing socket.

记得把SQL的SP3打上去就可以了。

3.Re:救命啊~~~JSP连接SQL数据库的问题~ [Re: naughty009] Copy to clipboard
Posted by: why
Posted on: 2005-09-26 17:06

Search here http://www.cjsdn.net/post/search
with keywords "Error establishing socket"

4.Re:救命啊~~~JSP连接SQL数据库的问题~ [Re: naughty009] Copy to clipboard
Posted by: naughty009
Posted on: 2005-09-26 20:23

谢谢啦~!这个问题已经解决~~~~~

5.Re:救命啊~~~JSP连接SQL数据库的问题~ [Re: naughty009] Copy to clipboard
Posted by: YuLimin
Posted on: 2005-09-27 12:25

解决的方法是怎么样的,是不是跟我们解决的方法不一样?
如果不一样请写出你的经验,大家一起学习:)

6.Re:救命啊~~~JSP连接SQL数据库的问题~ [Re: naughty009] Copy to clipboard
Posted by: naughty009
Posted on: 2005-09-27 12:47

打上sp3根本没用~~~~重装了系统吖~痛苦啊~~~~~~~再重装sql就行了~~~~唉~!都不知是什么回事啊~!

7.Re:救命啊~~~JSP连接SQL数据库的问题~ [Re: naughty009] Copy to clipboard
Posted by: flyingqifei
Posted on: 2005-09-27 23:05

SP3还是要打的,现在新出了SP4,不是重装系统这么痛苦吧!那也没找着原因呀!以后再碰到岂不……


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923