Can I build a result set from a file in Java?

Question

I do not have much experience with result sets, but since ResultSet is an interface, I assume that I can implement it to work with a file as a backend. This is nonsense? Is there any solution for my problem?

Answer 1

It seems that the Csv2JDBC project already exists, which may contain at least an example implementation of ResultSet.

Answer 2

HSQL also provides support for interpreting csv files as ResultSet s.