org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory --help. using Tomcat4.1

[Shilpa Nalgonda <sn...@mypublisher.com>]

org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFact
ory, cause:
java.sql.SQLException: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=135286784)(E
RR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
        at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:82)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:300)
        at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:838)
        at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:821)
        at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:518)
        at
com.mypublisher.oemapi.DAO.DBAccess.getConnection(DBAccess.java:47)
        at com.mypublisher.oemapi.DAO.Persister.<init>(Persister.java:32)
        at org.apache.jsp.test_jsp._jspService(test_jsp.java:56)
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)

I have this configuartion in server.xml,
====================================================
 	<Context path="/rpcoemapi" docBase="rpcoemapi"
        	debug="5" reloadable="true" crossContext="true" useNaming="true">

  	<Logger className="org.apache.catalina.logger.FileLogger"
             prefix="localhost_rpcoemapi_log." suffix=".txt"
             timestamp="true"/>
       <Resource name="jdbc/DBNAME"
               auth="Container"
               type="javax.sql.DataSource"/>

  	<ResourceParams name="jdbc/DBNAME">
    	<parameter>
      	  <name>factory</name>
      	  <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    	</parameter>

    	<!-- Maximum number of dB connections in pool. Make sure you
         configure your mysqld max_connections large enough to handle
         all of your db connections. Set to 0 for no limit.
         -->
    	<parameter>
          <name>maxActive</name>
          <value>50</value>
        </parameter>

    	<!-- Maximum number of idle dB connections to retain in pool.
         Set to 0 for no limit.
         -->
        <parameter>
         <name>maxIdle</name>
         <value>10</value>
        </parameter>

   	 <!-- Maximum time to wait for a dB connection to become available
         in ms, in this example 10 seconds. An Exception is thrown if
         this timeout is exceeded.  Set to -1 to wait indefinitely.
         -->
    	<parameter>
         <name>maxWait</name>
         <value>10000</value>
        </parameter>

    	<!-- MySQL dB username and password for dB connections  -->
    	<parameter>
     	  <name>username</name>
     	  <value>ioeadmin</value>
    	</parameter>
    	<parameter>
     	  <name>password</name>
     	  <value>ioeadmin</value>
    	</parameter>

    	<!-- Class name for mm.mysql JDBC driver -->
    	<parameter>
       	  <name>driverClassName</name>
       	  <value>oracle.jdbc.driver.OracleDriver</value>
    	</parameter>

    	<!-- The JDBC connection url for connecting to your MySQL dB.
         The autoReconnect=true argument to the url makes sure that the
         mm.mysql JDBC Driver will automatically reconnect if mysqld closed
the
         connection.  mysqld by default closes idle connections after 8
hours.
         -->
    	<parameter>
      	<name>url</name>

<value>jdbc:oracle:thin:@IPADDRESS:1521:DBNAME?autoReconnect=true</value>
   	</parameter>
</ResourceParams>
</Context>
============================================================================
=================
getConnection method uses the below code:

Context ctx = new InitialContext();
Context env = (Context)ctx.lookup("java:comp/env");
DataSource ds = (DataSource) env.lookup("jdbc/DBNAME");
conn = ds.getConnection();


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