RE: Axis web services for MySQL Connection.

[Thomas Herbstreuth]

Hi,   connecting to mySQl via SOAP can be understood as one of two things.   1.) Tunneling the requests that usually go through port 3306 via SOAP, that doesn't sound easy and i doubt if it's possible at all.   2.) Writing a webservice that connects to a mySQL Server (your Webservice would be the database client in this case) and delivering the data via a set of parametrized methods. You couldn't find anything specific about SOAPand JDBC because there is not the slightest difference in the use of JDBC in a Web-Service and a directly connected client.       ##############                                                                      ###########################                                                  ########################### # SOAP Client #      ------------------- SOAP (http) -----------------------   # Web Service                        #  --------------- JDBC (3306)-----------   # mySQL Server                     # ##############                                                                      ###########################                                                  ###########################                                                                                                  ###########################                                                 ##########################                                                                                                # normal mySQL Client           #--------------- JDBC (3306) -----------   # mySQL Server                     #                                                                                                ###########################                                                ########################### assistent =========       Unternehmensberatung       http://www.assistent.com       _________________________________________ Thomas Herbstreuth - [EMAIL PROTECTED] Telefon: +49 711 735 760 0 Telefax: +49 711 735 760 5   -----Original Message----- From: Joe Harrison [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 8:57 PM To: [EMAIL PROTECTED] Subject: Axis web services for MySQL Connection. I just setup Axis last week. My plan was to use Axis for database connectivity to MySQL. But I cannot find any examples of anyone using Axis with JDBC (or specifically the MM MySQL driver). I even bought several books, and one that is Axis-centric, but found no database examples…Am I on the right track or is their some other web service implementation I should consider for this task? Ultimately I want to use VB.net for the client, Axis for the middleware, and MySQL on the backend. I have successfully written a couple of sample applications using the “.jws?WSDL” implementation of Axis and Visual Studio.net, but I have not been able to connect to MySQL as of yet. I am new to Java and any help would be appreciated.