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

[Johannes Fiala <so...@fwd.at>]

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