Thanks Jacob, you rock...hopefully someone wil bless the DBCP stuff on the list when its all working....
I'll try 4.1.3 until then, one question though... which versions of the commons connector, dbcp, and pool are you using? clay -----Original Message----- From: Jacob Kjome [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:54 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re[2]: going crazy with DBCP 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]>