<%@ page language="java" import="java.util.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %><%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
out.println(basePath);
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  
  <body>
    This is my JSP page. <br>     <%         
 Context ctx=null;
   Connection cnn=null;
   java.sql.Statement stmt=null;
   ResultSet rs=null;
   try
   {
    ctx=new InitialContext();
    if(ctx==null)
     throw new Exception("initialize  the Context  failed");
 out.println("abc1"+"<br>");
    DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/ghyghost");
 out.println("abc2"+"<br>");
    out.println(ds);
  out.println("abc3"+"<br>");  
    if(ds==null)
    {     throw new Exception("datasource  is  null");
    }
  out.println("abc4"+"<br>"); 
     try{
   out.println("abc5"+"<br>");   
        cnn=ds.getConnection();   
   out.println("abc6"+"<br>");
stmt = cnn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("select * from jobs");while (rs.next())
{
out.println(rs.getObject("job_id").toString());
}
        out.println("<br> connection:"+cnn);
    }catch(Exception e){
        e.printStackTrace();
    }   }
   finally
   {
    if(rs!=null)
     rs.close();
    if(stmt!=null)
     stmt.close();
    if(cnn!=null)
     cnn.close();
    if(ctx!=null)
     ctx.close();
   }   
    %>
  </body>
</html>
现在问题是:
   out.println("abc6"+"<br>");这句不输出了,说明上一句有错误啊,帮忙,是什么错误,
我连接的是MSSQL2000的PUBS数据库,帮忙。TOMCAT的服务器

解决方案 »

  1.   

    是不是ds是null?
    你从控制台应该可以看到异常的信息啊
    还有,
    你得把配置JNDI的XML发出来看看
      

  2.   

    <?xml version="1.0" encoding="UTF-8"?>
    <web-app version="2.4" 
    xmlns="http://java.sun.com/xml/ns/j2ee" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">    <resource-ref>
            <res-ref-name>jdbc/ghyghost</res-ref-name>
            <res-type>javax.sql.DataSource</res-type>
            <res-auth>Container</res-auth>
        </resource-ref>
    </web-app>
    web.xml里面的全部内容使用ECLIPSE布属
      

  3.   

    2005-12-18 22:15:15 org.apache.coyote.http11.Http11Protocol init
    信息: Initializing Coyote HTTP/1.1 on http-8080
    2005-12-18 22:15:16 org.apache.catalina.startup.Catalina load
    信息: Initialization processed in 2031 ms
    2005-12-18 22:15:16 org.apache.catalina.core.StandardService start
    信息: Starting service Catalina
    2005-12-18 22:15:16 org.apache.catalina.core.StandardEngine start
    信息: Starting Servlet Engine: Apache Tomcat/5.0.28
    2005-12-18 22:15:16 org.apache.catalina.core.StandardHost start
    信息: XML validation disabled
    2005-12-18 22:15:16 org.apache.catalina.core.StandardHost getDeployer
    信息: Create Host deployer for direct deployment ( non-jmx ) 
    2005-12-18 22:15:16 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\balancer.xml
    2005-12-18 22:15:18 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\admin.xml
    2005-12-18 22:15:18 org.apache.struts.util.PropertyMessageResources <init>
    信息: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
    2005-12-18 22:15:18 org.apache.struts.util.PropertyMessageResources <init>
    信息: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
    2005-12-18 22:15:19 org.apache.struts.util.PropertyMessageResources <init>
    信息: Initializing, config='org.apache.webapp.admin.ApplicationResources', returnNull=true
    2005-12-18 22:15:22 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\manager.xml
    2005-12-18 22:15:23 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\webdav.xml
    2005-12-18 22:15:23 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\servlets-examples.xml
    2005-12-18 22:15:23 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\jsp-examples.xml
    2005-12-18 22:15:24 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\tomcat-docs.xml
    2005-12-18 22:15:24 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\ROOT.xml
    2005-12-18 22:15:24 org.apache.catalina.core.StandardHostDeployer install
    信息: Processing Context configuration file URL file:G:\Tomcat\conf\Catalina\localhost\ghyjsp.xml
    2005-12-18 22:15:25 org.apache.coyote.http11.Http11Protocol start
    信息: Starting Coyote HTTP/1.1 on http-8080
    2005-12-18 22:15:25 org.apache.jk.common.ChannelSocket init
    信息: JK2: ajp13 listening on /0.0.0.0:8009
    2005-12-18 22:15:25 org.apache.jk.server.JkMain start
    信息: Jk running ID=0 time=0/78  config=G:\Tomcat\conf\jk2.properties
    2005-12-18 22:15:25 org.apache.catalina.startup.Catalina start
    信息: Server startup in 9813 ms
    org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    at org.apache.jsp.ghy_jsp._jspService(ghy_jsp.java:105)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Thread.java:534)
    Caused by: java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:243)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
    ... 32 more
    错误信息是没有找到JDBC但我JDBC有啊,,放到相当目录中了。。怎么回事帮忙
    我连接的是MSSQL 2000中的PUBS数据库,
      

  4.   

    可能两个原因:
    1 你忽略了另外一个配置文件 ,Tomcat中在conf/Server.xml中配置
    2 你没有使用SQLServer的JDBC驱动;或者是你工程里有,但是lib文件没有伴随你的部署自动copy到web-inf的lib下