Hey Clay, here's something I noticed. With Tomcat 4.0.x the place to
put your jars for server wide access is in %CATALINA%\lib, not
%CATALINA%\common\lib. (the common\lib is the new location for 4.1.x)
Also, double-check your URL in your <Resource> tag. I'm not famaliar
with the tag for MySQL, but I thought that there should be a colon
between your Port and your Database.
Finally, there is an error saying that DBTest
("/home/tomcat/jwsdp-1_/webapps/DBTest" ??) does not exist within your
webapps folder. Your <Context> tag has a docBase attribute that either
points to a relative path to the webapps folder (by default) or you need
to put in an absolute path.
Good luck. Also, if you used Tomcat 4.1.x, (4.1.7 hint hint) all the
Commons Jars are included, so all you would have to do is add your MySQL
Jars. Plus you can configure your Resources through the Admin GUI if
you really wanted too.
- Andrew
-----Original Message-----
From: Clay Graham [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 7:36 PM
To: '[EMAIL PROTECTED]'
Subject: going crazy with DBCP
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
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 a
difference between 4.0.2 and to point versions that it causes this stuff
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
Resources 2002-07-08 16:14:38 StandardContext[/DBTest]: Error
initializing resources:
Document base /home/tomcat/jwsdp-1_/webapps/DBTest does not exist or is
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 container
startup
2002-07-08 16:14:38 StandardContext[/DBTest]: Context startup failed due
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
org.apache.catalina.startup.Catalina.execute(Catalina.java:399)
at
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]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
