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
Have written a hint how I got it working, and it has helped some people before, so maybe you have a look at it:
http://www.lug-untermain.de/faqs/sqljava.php
rgds Axel
