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
