用jsp 在tomcat5上访问oracle10g？

我的XML文件内容
<ResourceParams name="jdbc/tipmis_ods">
    <parameter>
      <name>validationQuery</name>
      <value>select * from t_salequantity</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>trade_view</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.232.1.203)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ods)))</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>4</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>5000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>usr_trade</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
  </ResourceParams>
JSP这么写的
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="tipmis.module.GFunction.DivElementBO"%> 
<%@ page import="java.util.Date"%> 
<%@ page import="com.sict.util.DateTime"%> 
<%@ page import="javax.naming.InitialContext"%> 
<%@ page import="javax.naming.Context"%> 
<%@ page import="javax.sql.DataSource"%> 
<%@ page import="java.sql.Connection"%> <%   Context ctx = new InitialContext();      
   String strLookup = "java:comp/env/jdbc/tipmis_ods"; 
   DataSource ds =(DataSource) ctx.lookup(strLookup);
   System.out.println("ds="+ds);
   System.out.println("ds="+ds.toString());
   Connection con = ds.getConnection();
    if (con != null){
        System.out.println("success");
    }else{
        System.out.println("failure");
    }       System.out.println("***************************************");
/*
String cell_id = "hn-001";
DivElementBO bean = new DivElementBO(cell_id, "0", 1);
String title = bean.getCellName();
StringBuffer str = bean.getGenerateDivElement();
*/
%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link href="css/bigscreen1.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="js/CalendarForComm.js"></script>
</head><body>
-------------------
<form method="post" name="frm" id="frm" action="a.jsp">
  <div>
<div id="page_system_title">
<!-- title start--> <!-- title end-->
</div>
<div id="page_system_content">
<!-- content start-->
<%//=str%>
<!-- content end-->
</div>
  </div>
</form>
</body>
</html>
报的错误如下：
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.232.1.203)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ods)))
)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.a_jsp._jspService(a_jsp.java:125)
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)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:50)
root cause org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.232.1.203)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ods)))
)
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
org.apache.jsp.a_jsp._jspService(a_jsp.java:67)
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)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:50)我用的是classes12。jar  ojdbc14。jar 都拷贝到tomcat\common\lib下了

解决方案 »

  1.   

    <value>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.232.1.203)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ods)))</value>      --->      <value>jdbc:oracle:thin:@（yourhostname）:1521:（your sid）</value>
      

  2.   

    Oracle数据库的TNSListener服务开了没？在控制面板--〉服务
      

  3.   

    出现这样的错误在有的时候,你重新启动一下服务器和是重新装下tomcat有的时候问题也可以得到解决的
      

  4.   

    还是不好用，改称<value>jdbc:oracle:thin:@（yourhostname）:1521:（your sid）</value>之后
    报的错误是
    type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Cannot create PoolableConnectionFactory (Io 异常: NL Exception was generated)
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
    org.apache.jsp.a_jsp._jspService(a_jsp.java:125)
    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)
    org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:50)
    root cause org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: NL Exception was generated)
    org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
    org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    org.apache.jsp.a_jsp._jspService(a_jsp.java:67)
    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)
    org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:50)
    note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
    --------------------------------------------------------------------------------