tryin to connect infopath(MS Office) to a web service written in java

[mrjavoman]

I've been wrestling with this problem for a couple of days now, I've been trying to connect infopath(ms office, used to create forms) to a web service written in java, this web service makes queries to an mysql server and returns the results set using a datatype called WebRowSet, from the reasearch I've done WebRowSet is supposed to work like the DataSet datatype in .NET but so far i haven't been able to get the same results, the web service is running on apache Axis2

the web service retruns a WebRowSet object using an implementation of the WebRowSet interface
the code on the web service:

import com.sun.rowset.WebRowSetImpl;
import javax.sql.rowset.WebRowSet;


preparedStatement = connect.prepareStatement("SELECT * FROM table");
resultSet = preparedStatement.executeQuery();
WebRowSet wrs = new WebRowSetImpl();
wrs.populate(resultSet);
return wrs;

I'm able to see the web service from infopath but when connecting to it I don't get any data from it.
I've also tried creating an XML file using the WebRowSet method wrs.WriteXML(), in that case infopath is able to read the XML file but the data is not in a format infopath can use from the get go.

after struggling with this I've come to think that i will probably need to customize the implementation of WebRowSet to my needs in order to use a java web service with infopath.

so i guess my questions are, has anyone ever tried to do something like this?, do you think it would it be too much work to pursue an infopath/open source technologies connection?

i would really appreciate any advice you guys could give me thanks.