Hello Clay, I just tested 4.1.7 and the commons-dbcp.jar that comes with it is still broken. I reported this issue after testing 4.1.6. To reiterate, I have DBCP connection pooling working just fine in Tomcat-4.1.3 and it doesn't work in 4.1.6 or 4.1.7.
What I have done to work around this is to copy the commons-dbcp.jar from Tomcat-4.1.3 to Tomcat-4.1.7. After doing this, everything works just fine. I guess I'd better report the bug in bugzilla. Jake Tuesday, July 09, 2002, 2:13:23 PM, you wrote: CG> I went to 4.1.7 yesterday, I tjhought hey this will all work because the CG> .tar.gz has the commons jars already wrapped up in it, yay this will all CG> work great just by getting the new stuff. so I downloaded it got it up and CG> running, and then added the new DBTest context as specified to the CG> server.xml.... CG> watched the log hopefully, then...... CG> exact same error in the log file, is the some little step that I may have CG> missed? CG> clay CG> -----Original Message----- CG> From: Jacob Kjome [SMTP:[EMAIL PROTECTED]] CG> Sent: Monday, July 08, 2002 7:04 PM CG> To: Tomcat Users List CG> Subject: Re: going crazy with DBCP CG> Try using Tomcat 4.1.3 or 4.1.7 (not anything in between because I think CG> DBCP was broken for a bit there). Everything should work just great. CG> Jake CG> At 04:36 PM 7/8/2002 -0700, you wrote: >>I will pay someone to help me at this point, I am not rich but I know when >>to admit when need help. I am basically at the end of my rope trying to CG> get >>dbcp to work, I have been over >> >>http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 >> >>about one hundred times, basically it's impossible to get the exact >>configuration that he speaks of, like some of the commons stuff I couldn't >>find those versions, anyway it would really suprise me if those EXACT >>versions are the only ones that work. >> >>I tried to install the RPM 4.0.4 version of tomcat and the webapps, but I >>could not get the manager to work, so I went back to 4.0.2. Is there such CG> a >>difference between 4.0.2 and to point versions that it causes this stuff CG> to >>fail? Is the only way to get DBCP to work is to actually build tomcat from >>source? Anyway I have done the best I can and spent two days configuring, >>this where I am at: >> >>tomcat 4.0.2 full >>mysql 4.0.1-2 >> >>mm.mysql-2.0.14-bin.jar in $TOMCAT_HOME/common/lib >> >>commons-collections-2.0 - commons-collections.jar in >>$TOMCAT_HOME/common/lib >>commons-dbcp-20020707.tar.gz - commons-dbcp.jar in $TOMCAT_HOME/common/lib >>commons-pool-20020707.tar.gz - commons-pool.jar in $TOMCAT_HOME/common/lib >> >>added to server.xml >> >><!-- the data source added by Clay--> >><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/TestDB" auth="Container" >>type="javax.sql.DataSource"/> >> <ResourceParams name="jdbc/TestDB"> >> <parameter> >> <name>factory</name> >> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> >> </parameter> >> <parameter><name>maxActive</name><value>100</value></parameter> >> <parameter><name>maxIdle</name><value>30000</value></parameter> >> <parameter><name>maxWait</name><value>100</value></parameter> >> <parameter><name>username</name><value>tomcat</value></parameter> >> <parameter><name>password</name><value>password</value></parameter> >> <parameter> >> <name>driverClassName</name><value>org.gjt.mm.mysql.Driver</value> >> </parameter> >> <parameter> >> <name>url</name><value>jdbc:mysql://localhost:3306/test</value> >> </parameter> >> </ResourceParams> >></Context> >> >>when tomcat is started i get the following log errors: >> >>2002-07-08 16:14:38 StandardContext[/DBTest]: Starting >>2002-07-08 16:14:38 StandardContext[/DBTest]: Processing start(), current >>available=false >>2002-07-08 16:14:38 StandardContext[/DBTest]: Configuring default CG> Resources >>2002-07-08 16:14:38 StandardContext[/DBTest]: Error initializing CG> resources: >>Document base /home/tomcat/jwsdp-1_/webapps/DBTest does not exist or is CG> not >>a readable directory >>2002-07-08 16:14:38 StandardContext[/DBTest]: Configuring non-privileged >>default Loader >>2002-07-08 16:14:38 StandardContext[/DBTest]: Configuring default Manager >>2002-07-08 16:14:38 StandardContext[/DBTest]: Processing standard CG> container >>startup >>2002-07-08 16:14:38 StandardContext[/DBTest]: Context startup failed due CG> to >>previous errors >>2002-07-08 16:14:38 StandardContext[/DBTest]: Exception during cleanup >>after start failed >>LifecycleException: Container StandardContext[/DBTest] has not been >>started >> at >>org.apache.catalina.core.StandardContext.stop(StandardContext.java:3521) >> at >>org.apache.catalina.core.StandardContext.start(StandardContext.java:3499) >> at >>org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1190) >> at >>org.apache.catalina.core.StandardHost.start(StandardHost.java:739) >> at >>org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1190) >> at >>org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347) >> at org.apache.catalina.core.StandardService.start(StandardServic >>e.java:499) >> at >>org.apache.catalina.core.StandardServer.start(StandardServer.java:2187) >> at org.apache.catalina.startup.Catalina.start(Catalina.java:504) >> at CG> org.apache.catalina.startup.Catalina.execute(Catalina.java:399) >> at CG> org.apache.catalina.startup.Catalina.process(Catalina.java:179) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav >>a:39) >> at >>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor >>Impl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:324) >> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at >>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav >>a:39) >> >> >>I am not an expert, but I feel like I have to be to get DBCP to work.... >> >> >> >>clay >> >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED] e.org>> >>For additional commands, e-mail: CG> <mailto:[EMAIL PROTECTED]> CG> -- CG> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> CG> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- Best regards, Jacob mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>