I reported the issue with DBCP as bug 10614: http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10614
As far as versions of the various commons libraries, I am currently using Tomcat-4.1.7, so the commons library versions are whatever come with the 4.1.7 build of Tomcat except for the commons-dbcp.jar which is the one that came with Tomcat-4.1.3. It all works together quite nicely, but I sure hope this issue is fixed in a future version of Tomcat so I don't have to bother with all this and benefit from whatever bugfixes are in the latest commons-dbcp library. Jake At 07:45 PM 7/9/2002 -0700, you wrote: >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]>
