RMI and JDBC ResultSet

I am developing a project

The basic archeiecture is like this:

a reporting tool

a virtualDB

a real DB

the reporting tool request for data from virtualDB, the virtualDB actually fetch the result for it.

The virtualDB is a remote object using RMI which can be called in the reporting tool(stub)

the virtualDB is connecting to the real DB through JDBC-ODBC driver.

Now comes the problem, when the virtualDB has the ResultSet which is return by JDBC-ODBC. I cannot pass the ResultSet from remote site to my reporting tool, at run time, it will throw NotSerializable Exception, I guess this is because the JDBC-ODBC ResultSet does not implement that interface.

So is there any way I can solve this problem to allow the reporting tool(client) receive the ResultSet that VirtualDB has got?

Thanks in advance, any comment would be a great help for me!!!

[913 byte] By [ZHXa] at [2007-10-3 3:14:15]