请教!Tomcat 5.0连接oracle 9 并行服务器问题

pt@st

Tomcat 5.0连接不上oracle 9 并行服务器
配置如下:
<Resource auth="Container" description="DB Connection" name="test" type="javax.sql.DataSource"/>
  <ResourceParams name="test">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbcracle:thin190.131.44.141:1521ra92</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>tccs</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>tccs</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
  </ResourceParams>  
</Context>
把上述配置改为oracle 9 单机服务器正常

jinxueping

不同的IP的Oracle的实例名是不一样的，是不是这个地方有问题，是不是把报错信息贴上来好些。

pt@st

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

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

exception

javax.servlet.ServletException: ??SQL????:Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbcracle:thin(DESCRIPTION =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=fdb1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=fdb2)(PORT=1521))(LOAD_BALANCE = yes)(FAILOVER=ON))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=fccs)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=15))))'
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:75
        org.apache.jsp.login.index_jsp._jspService(index_jsp.java:315)
        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)
        filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)


root cause

com.telthink.report.util.ConsultException: ??SQL????:Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbcracle:thin(DESCRIPTION =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=fdb1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=fdb2)(PORT=1521))(LOAD_BALANCE = yes)(FAILOVER=ON))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=fccs)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=15))))'
        com.telthink.report.util.ConsultSql.executeQuery(ConsultSql.java:76)
        com.telthink.report.Login.getAreaDept(Login.java:51)
        org.apache.jsp.login.index_jsp._jspService(index_jsp.java:6
        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)
        filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)


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


--------------------------------------------------------------------------------

Apache Tomcat/5.0.27