RE: Using SOAP for remote database access via SQL: Retrieving the Resultset

[Tony Sciacca]

Hello Johannes,   You may want to consider a product called XAware, which is a set of data integration components which can do exactly what you are talking about. XAware uses XML as the core technology for information exchange, and easily allows connection to and mapping to and from relational databases (as well as just about any other kind of data source). Through the use of a visual IDE, XML views of data are created which can be interfaced with as a SOAP interface. In fact, in the IDE a .wsdl file can be automatically generated which can be used to define the access to the XML view that is created. In terms of quantity, XAware is currently developing streaming capabilities (due out in a month or so) which will address the issue of large result sets.  Tony Sciacca XAware Inc. http://www.xaware.com [EMAIL PROTECTED] -----Original Message----- From: Johannes Fiala [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 12:01 PM To: [EMAIL PROTECTED] Subject: Using SOAP for remote database access via SQL: Retrieving the Resultset   Hi there, I want to create a SOAP interface to allow access to a local relational database system. Issuing the request (SQL-Statement with parameters) should be no problem, but what about returning the resultset? Has anybody experience in transferring a java.sql.ResultSet over the wire? Should I convert the whole resultset to XML and then send it back? What about quantity measures? Has anybody tried to transfer let's say more than 1 MB response over the wire? Does it make sense to split the resultset and allow for subsequent calls (like using a cursor and fetching the next records)? Anybody who would like to share his experiences in this field? johannes