I basically did it this way, the libraries you get for JDBC with mysql are in jar that you find (as of today, sep 21... Lots of new stuff/changes seems to be coming out from MySQL every week) here http://dev.mysql.com/downloads/connector/j/3.0.html
The documentation (with lots of good examples of how to get the connection set up, how to set parameters in your SQL statements, how to turn off autocommit in case you want transaction rollback in case of exception, etc) is here http://dev.mysql.com/doc/connector/j/en/index.html Everything is pretty straightforward... The main gotcha I ran into with regard to this was: Make sure that you move a copy of the mysql JDBC connector libraries (jar file you get from MySQL.com) in tomcat's lib directory. Otherwise when you move your axis classes over they won't be able to set up the connection. -----Original Message----- From: Brian H. Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 10:44 AM To: [EMAIL PROTECTED]; Yahoo Subject: Re: a problem with JDBC and Web Service If you are in a Tomcat environment, you *can* use server configured datasources. But, you can also use traditional Java JDBC calls (Class.forName, DriverManager.getConnection, createStatement(), executeQuery(), etc.). The basic JDBC tutorial at Sun will work from inside of Tomcat. --- bhw On Tue, 21 Sep 2004 16:18:20 +0200, Daniel S�nchez G�mez <[EMAIL PROTECTED]> wrote: > Hi, > > I'm newbie of Web service and I want to do a web service wich > inserts data into a mysql database > > I dont't know if I need to configue server.xml and web.xml files? (I > work with Tomcat) > > I've read jndi-datasource-examples-howto.html, but it's a servlet > example and I don't know if it is identical to a simple webservice > > -- > Regars, > Daniel mailto:[EMAIL PROTECTED] > >
