OT : Re: MySQL and Axis

["Michael C. Clark" <me...@michaelcclark.com>]

Please see:

http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources-howto.html

The configuration of a JNDI resource is not related to Axis, it's a
function of the Tomcat container itself.  You are definately on the right
path, but you might try building a simple servlet to test the connection.

You are definately on the right track.

-mcc
> Does anyone please know the right configuration inside Tomcat's
> server.xml for accessing a MySql database inside an Axis web service?
>
> This is what I've tried inside server.xml:
> <Context path="/axis" docBase="axis"
>          debug="5" reloadable="true" crossContext="true">
>
>        <Resource name="jdbc/axis" auth="Container"
> type="javax.sql.DataSource"
>                 maxActive="100" maxIdle="30" maxWait="10000"
>                 username="XX" password="xxx"
> driverClassName="com.mysql.jdbc.Driver"
>
> url="jdbc:mysql://localhost:3306/dbname?autoReconnect=true"/>
>   </Context>
>
> With this added to the Axis web.xml:
> <description>dbName</description>
>    <resource-ref>
>        <description>DB Connection</description>
>        <res-ref-name>jdbc/axis</res-ref-name>
>        <res-type>javax.sql.DataSource</res-type>
>        <res-auth>Container</res-auth>
>    </resource-ref>
>
> It doesn't work.  Any ideas, please?
>
> Thanks.
>
> Madeleine
>