tomcat 连接 ms sqlserver2000的问题

那三个包已经有了 classpath也改过了 java程序能够连上数据库了可是jsp不行是不是还得配置连接池啊

要把MS SQL SERVER的JDBC驱动的三个文件放到,WEB目录下的的WEB-INF\LIB目录中

D:\Tomcat 5.0\webapps\myjsp\WEB-INF\lib；D:\Tomcat 5.0\webapps\ROOT\WEB-INF\lib
我都放过了文件放在myjsp中的挪root中也试过的

网上有很多的例子,我以前也是不行,需要把JDBC的三个JAR文件拷贝到TOMCAT的相应目录下,和JSDK的相应目录下,并在系统环境变量中对三个文件进行配置,还有要注意数据库的用户配置,这点也很关键.并且要给配置的用户已相应的权限,这样才行.用户要使,可以使用SQL SERVER用户或者WINDOWS用户都可以进行登录的,才行.

jsdk相应目录是D:\jdk1.5\jre\lib\ext 吗
copy过了； sql安装的时候选择混合式登陆：混合模式(Window身份验证和SQL Server身份验证(M)) 楼上说的应该就是这个吧！

<%　Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";　   　
　　　//pubs　为你的数据库的
    String user="sa";　
　　　String password="sa";
　　　Connection conn=　DriverManager.getConnection(url,user,password);
　　　Statement  stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
　　　String sql="select　job_id,job_desc　from　jobs";
　　　ResultSet rs=stmt.executeQuery(sql);
　　　while(rs.next())　{　%>
　　　　您的第一个字段内容为：<%=rs.getString(1)%><br/>
　　　　您的第二个字段内容为：<%=rs.getString(2)%><br/>
　　
　　　　
<%
}　
rs.close();
　　　stmt.close();
　　　conn.close();
　　%>
晕，还有人抄都抄不对...

http://blog.sina.com.cn/myblog/article/article_show.php?nid=44b8fb7701000002

import="java.lang.*,　java.io.*,　java.sql.*,　java.util.*"　中间的空格去掉试试

http://www.haow168.com/plug-ins/ad/get.asp?get=3124
在这里有关于这个问题的详细解答.

重新写过了错误变成了这个
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 12 in the jsp file: /1111.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\myjsp\org\apache\jsp\_1111_jsp.java:63: ';' expected
Statement stmt=sqlConn.createStatement();
^
1 error org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
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.那个Statment在DreamWerver下面没有变颜色是啥问题啊

那个Statment在DreamWerver下面没有变颜色是啥问题啊
这个是DreamWerver的问题

写的有错改一下密码用一下这个<%@ page import="java.lang.*,java.io.*,java.sql.*,java.util.*" contentType="text/html;charset=gb2312" %>
<% request.setCharacterEncoding("GB2312") ; %><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);String sql="select job_id,job_desc from jobs"; 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>

';' expected
Statement stmt=sqlConn.createStatement();
^
1 error
这里不是提示少了一个分号吗???

分号补上去了HTTP Status 404 - /1111.jsp--------------------------------------------------------------------------------type Status reportmessage /1111.jspdescription The requested resource (/1111.jsp) is not available.
--------------------------------------------------------------------------------Apache Tomcat/5.0.28这个啥意思啊呵呵

路径有错吧
好像说找不到 111.jsp

对是我弄错了   汗一个
现在是
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 26 in the jsp file: /1111.jsp
Generated servlet error:
D:\Tomcat 5.0\work\Catalina\localhost\myjsp\org\apache\jsp\_1111_jsp.java:86: cannot find symbol
symbol  : variable conn
location: class org.apache.jsp._1111_jsp
conn.close();
        ^
1 error org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
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.

继续更新了这次是HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 2 is out of range.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp._1111_jsp._jspService(_1111_jsp.java:99)
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]Column index 2 is out of range.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
org.apache.jsp._1111_jsp._jspService(_1111_jsp.java:74)
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.

调试易

tomcat 连接 ms sqlserver2000的问题

解决方案 »