Return-Path: 
 <tomcat-user-return-16494-qmlist-jakarta-archive-tomcat-user=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 38058 invoked from network); 11 Apr 2002 20:12:46 -0000
Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131)
  by daedalus.apache.org with SMTP; 11 Apr 2002 20:12:46 -0000
Received: (qmail 28393 invoked by uid 97); 11 Apr 2002 20:12:30 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org
Received: (qmail 28376 invoked by uid 97); 11 Apr 2002 20:12:29 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 28364 invoked from network); 11 Apr 2002 20:12:29 -0000
User-Agent: Microsoft-Entourage/10.0.0.1309
Date: Thu, 11 Apr 2002 21:11:54 +0100
Subject: DBCP Pool Collections problems on TC4.0.3
From: Steven Elliott <ttoille@mac.com>
To: <tomcat-user@jakarta.apache.org>
Message-ID: <B8DBAC9A.41EE%ttoille@mac.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Craig I hope you or Ralph can help me out.  I would like to replace Tyrex
with the DBCP but I cannot seem to get the factory to work and the
exceptions are happenning in the Service invoker.

My server.xml looks like the following (please forgive the wrap:
 <Resource name="jdbc/pestanaAdminDB" auth="Container"
type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/pestanaAdminDB">
        <parameter>
            <name>factory</name>
               <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
         </parameter>
         <parameter>
            <name>maxActive</name>
            <value>10</value>
        </parameter>
        <parameter>
            <name>user</name>
            <value>username</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>pass</value>
        </parameter>
        <parameter>
            <name>driverClassName</name>
            <value>com.jnetdirect.jsql.JSQLDriver</value>
        </parameter>
        <parameter>
            <name>logfile</name>
            <value>JSQLConnectLog.txt</value>
        </parameter>
        <parameter>
            <name>driverName</name>
 <value>jdbc:JSQLConnect://pc2.cibertribe.pt:1433/database=pestanaAdmin</val
ue>
         </parameter>
   </ResourceParams>


If I use the default Tyrex pool everything works as it should.  Using the
above I am getting at the application log:
2002-04-11 20:59:13 org.apache.catalina.INVOKER.AdminLogin: init
2002-04-11 20:59:13 StandardWrapperValve[invoker]: Servlet.service() for
servlet invoker threw exception
java.lang.IllegalStateException
        at 
org.apache.catalina.connector.HttpResponseFacade.sendRedirect(HttpResponseFa
cade.java:173)
        at AdminLogin.doGet(AdminLogin.java:46)
        at AdminLogin.doPost(AdminLogin.java:56)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java
:446)
        at 
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.java:216)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
        at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
        at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
        at 
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
        at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
        at 
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
        at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
        at 
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
        at 
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
        at 
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
        at 
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
        at 
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
1012)
        at 
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107
)
        at java.lang.Thread.run(Thread.java:496)


AdminLogin is a simple login servlet which works in conjunction with a
Filter to restrict access.

Any ideas... things to try?

Thanks for any help.

Steven


--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>