偶是这样配置的,,高手来帮偶看看,有什么错...
使用的是Tomcat 5.0..在D:\Tomcat 5.0\webapps\scm下(scm是这个项目名称)
1.一个scm.xml,,内容如下:
<Context docBase="/scm" path="/scm" workDir="work\Catalina\localhost\scm" debug="10">  <Resource type="javax.sql.DataSource"  auth="Container"  name="jdbc/sql"/>  
  
    <ResourceParams name="jdbc/sql">      
      <parameter>
        <name>password</name>
        <value>sa</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:oracle:thin:@10.147.20.14:1521:mis</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>oracle.jdbc.driver.OracleDriver</value>
      </parameter>
      <parameter>
        <name>username</name>
        <value>gzxt</value>
      </parameter>
    </ResourceParams>
   </Context>
2.:\Tomcat 5.0\conf\server.xml这个配置文件里.加入下面这句话:
<ResourceLink name="jdbc/sql" type="javax.sql.DataSource" global="jdbc/sql"/>
3.用JBuilder在com.db包路劲中,写一个java文件..名为DbConnection::(只写点关键的,其他都略去)
String strDriver = "oracle.jdbc.driver.OracleDriver";
    String strUrl =
        "jdbc:oracle:thin:@10.147.20.14:1521:mis";
    String strUser = "gzxt";
    String strPwd = "gzxt";    public DbConnection()
    {
        if(ds == null)
        {
            try
            {
                initCtx=new InitialContext();
     if(initCtx==null)
      throw new Exception("initialize  the Context  failed");
     ds=(DataSource)initCtx.lookup("java:comp/env/jdbc/sql");
                    System.out.println(ds.toString());            }
            catch (Exception ex)
            {
                ex.printStackTrace();
                initCtx = null;
            }
        }
    }    private synchronized Connection getConnection()
    {
        try
        {
         System.out.println("Start getConnection=" + conn );
            if(conn == null || conn.isClosed())
                conn = ds.getConnection();
          System.out.println("Got Connection=" + conn );
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
            return null;
        }
        return conn;
    }
   public synchronized ResultSet executeQuery(String sql){.......}
将这个java文件编译通过,取出DbConnection.class文件,放在D:\Tomcat 5.0\webapps\scm\WEB-INF\classes\com\db下...
4:然后在testconn.jsp业面中测试连接:(只写点关键的,其他都略去)
<%@page import="com.db.DbConnection"%>
<body>
<%
   DbConnection db = new DbConnection();
   ResultSet rs = db.executeQuery("select * from gzxt.zgkl");
    try{
      while (rs.next()) {
        out.println(rs.getString("ZGXM"));
        rs.close();
        break;
      }
    }
    catch (Exception e) {
      System.out.println(e);
    }
%>
</body>
5.语法上都米问题的.但就是提示数据库米连接上:
HTTP Status 500 -
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
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)root cause java.lang.NullPointerException
....................(省略6行出错代码)
note The full stack trace of the root cause is available in the Tomcat logs.
请高手帮偶看看为什么.....
谢谢了!