MySQL and Axis

Sat, 02 Apr 2005 17:38:46 -0800

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

Reply via email to