Re: axis msql jdbc configuration help

Mon, 18 Oct 2004 01:22:31 -0700 

Hi Axel ,

Quote from Tomcat doc :

The /context path/ of this web application, which is matched against the beginning of each request URI to select the appropriate web application for processing. All of the context paths within a particular Host <http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/host.html> must be unique. If you specify a context path of an empty string (""), you are defining the /default/ web application for this Host, which will process all requests not assigned to other Contexts.

The /Document Base/ (also known as the /Context Root/) directory for this web application, or the pathname to the web application archive file (if this web application is being executed directly from the WAR file). You may specify an absolute pathname for this directory or WAR file, or a pathname that is relative to the |appBase| directory of the owning Hos <http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/host.html>t

Axel Burwitz wrote:

Hi,

I am a beginner in Axis and need some help, because in spite of all Tomcat doc reading, googling, trying: I can't work it out:

I have a small Java WebService with usage of Axis programmed/installed/deployed/tested, and it works. Fine.

But now, I want to use my MySQL Database with JDBC as in all other Java programs.

I have copied the mysql-connector-java-3.0.11-stable-bin.jar to the directory /opt/tomcat/webapps/axis/WEB-INF/lib, have set the CLASSPATH entry for that location, and have - according to Tomcat doc- added

"<Context path="/axis" docBase="axis"
       debug="5" reloadable="true" crossContext="true">

         <Logger className="org.apache.catalina.logger.FileLogger"
                    prefix="localhost_DBTest_log." suffix=".txt"
                    timestamp="true"/>

         <Resource name="jdbc/axis"
                      auth="Container"
                      type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/axis">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

   <!-- Maximum number of dB connections in pool. Make sure you
        configure your mysqld max_connections large enough to handle
        all of your db connections. Set to 0 for no limit.
        -->
           <parameter>
             <name>maxActive</name>
             <value>100</value>
           </parameter>

   <!-- Maximum number of idle dB connections to retain in pool.
        Set to -1 for no limit.  See also the DBCP documentation on this
        and the minEvictableIdleTimeMillis configuration parameter.
        -->
           <parameter>
             <name>maxIdle</name>
             <value>30</value>
           </parameter>

   <!-- Maximum time to wait for a dB connection to become available
        in ms, in this example 10 seconds. An Exception is thrown if
        this timeout is exceeded.  Set to -1 to wait indefinitely.
        -->
           <parameter>
             <name>maxWait</name>
             <value>10000</value>
           </parameter>

   <!-- MySQL dB username and password for dB connections  -->
           <parameter>
            <name>username</name>
            <value>here is my name..</value>
           </parameter>
           <parameter>
            <name>password</name>
            <value>here is my pw...</value>
           </parameter>

<!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next
if you want to use this driver - we recommend using Connector/J though
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
-->
<!-- Class name for the official MySQL Connector/J driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/here is my webservicename?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>


into my $CATALINA/conf/server.xml


But but but: my program does not get anything working with database access !




Is there anything more to do ??

And I am not sure about the meaning of "path" and "docbase" (see above in the server.xml)

Any help wold be greatly appreciated !
(If I get it working, I promise to write a small How To and will publish it on our Linux User Group Website..)

Best regards

Axel

Reply via email to