Hi Joe, I think the real problem is that, in Java there is not standard way of representing an offline result set (ie a DataSet). What you have to do is write a custom deserialiser to parse the xml in the soap response and put the data in an object that is equivalent to a .NET Dataset object. Does anyone on this list know of a free implementation of this?
-----Original Message----- From: Joe Harrison [mailto:[EMAIL PROTECTED]] Sent: 04 June 2002 15:12 To: [EMAIL PROTECTED] Subject: RE:RE:Axis web services for MySQL Connection. > You couldn't find anything specific about SOAP and JDBC because there is not the slightest difference in the use of JDBC in a Web-Service and a directly connected client. There is one major distinction between a MySQL client and a Web Service connecting to a database, the Web Service has to redistribute the data and the MySQL client does not. Sorry but I did not clearly explain my problem. I have successfully connected to MySQL using JDBC but the code that I have written would not qualify as a web service, it is a client. In .net, the data is collected via a Web Service using an OLE DB connection or an OLE ODBC connection as a "DataSet", and then redistributed via an XML message. Every Java example I have seen uses "System.out.println(data)" , this assumes it is the data's final destination, but I would like to "return dataset". I am not sure, but I believe in the Java world, data is collected via EJB's which then become data objects. The Web Service would then, in turn, access these data objects. If this is true, why would there be so many layers of separation between the data source and the end-user's application? It just seems that distribution of data would be the primary role of Web Services, yet it is in this area that I have been unable to find any documentation. I know this not due to a failing on the part of Java/SOAP developers, but rather my lack of understanding of Java and the role of web services. So should my focus be on EJBs? ############## ############## ###### ########## #SOAP CLIENT# ---- SOAP (HTTP) ---- # Web Service # -----(?)-----# EJB # ---JDBC(3306)----#Database# ############## ############## ###### ########## I guess this is my question: How do I write a Java Web Service that RETURNS a bucket of data, a DataSet, to a SOAP client? Thanks for all your help guys. -----Original Message----- From: Thomas Herbstreuth [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 4:45 AM To: [EMAIL PROTECTED] Subject: RE: Axis web services for MySQL Connection. 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.
