tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Caroline Jen <jiapei_...@yahoo.com>
Subject Tomcat Connection Pool Configuration Problem (Cannot Establish the Connection)
Date Tue, 14 Sep 2004 20:56:48 GMT
Sorry about my previous posting.  Now, I have got
better trace of my JDBC connection problem.

I am using the Tomcat 5.0.27, j2sdk1.4.2, Oracle 10i,
Windows XP.

The error message is:

==============================================
root cause 

org.dhsinfo.content.exceptions.PageDAOSysException:
SQLException: Cannot create JDBC driver of class ''
for connect URL 'null'

org.dhsinfo.content.dao.OraclePageDAO.findPages(OraclePageDAO.java:51)

org.dhsinfo.content.PageService.getPages(PageService.java:18)

org.dhsinfo.content.SelectPage.execute(SelectPage.java:29)

org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)

org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)

org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)

javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
============================================


When I configured the Tomcat 5.0.27, I did put the
driver and URL in the
C:\jakarta-tomcat-5.0.27\conf\server.xml file (The
location is below the         <Logger
className="org.apache.catalina.logger.FileLogger"
directory="logs"  prefix="localhost_log."
suffix=".txt" timestamp="true"/> and before the
closing </Host> tag).  Please help me to see the
problem:

[code]
<Context path="/DBTest" docBase="DBTest"
        debug="5" reloadable="true"
crossContext="true">

  <Logger
className="org.apache.catalina.logger.FileLogger"
             prefix="localhost_DBTest_log."
suffix=".txt"
             timestamp="true"/>

   <Resource name="jdbc/OracleDB" auth="Container"
             type="javax.sql.DataSource"/> 

   <ResourceParams name="jdbc/OracleDB">
      <parameter>
         <name>factory</name>
        
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>
      <parameter>
         <name>maxWait</name>
         <value>5000</value>
      </parameter>
      <parameter>
         <name>maxActive</name>
         <value>20</value>
      </parameter>
      <parameter>
         <name>password</name>
         <value>cmis001</value>
      </parameter>
      <parameter>
         <name>url</name>
        
<value>jdbc:oracle:thin:@172.19.47.22:1521:devora2</value>
      </parameter>
      <parameter>
         <name>driverClassName</name>
        
<value>oracle.jdbc.driver.OracleDriver</value>
      </parameter>
      <parameter>
         <name>maxIdle</name>
         <value>10</value>
      </parameter>
      <parameter>
         <name>username</name>
         <value>cmis</value>
      </parameter>
      <parameter>
         <name>removeAbandoned</name>
         <value>true</value>
      </parameter>
      <parameter>
         <name>removeAbandonedTimeout</name>
         <value>60</value>
      </parameter>
      <parameter>
         <name>logAbandoned</name>
         <value>true</value>
      </parameter>
</ResourceParams>
</Context>
[/code]

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message