Maybe something like [MockResultSet](http://commons.apache.org/proper/commons-dbutils/testapidocs/org/apache/commons/dbutils/MockResultSet.html) could be used to test such things.
One more alternative here: http://mockrunner.sourceforge.net/doc/api/com/mockrunner/mock/jdbc/MockResultSet.html

I haven't used any of these yet so I'm not sure if they would work fine here but maybe it's worth trying.