I am looking for some kind of library from which I can provide stubs for SQL calls (for
unit testing). Kind of like a dummy
JDBC driver (a similar idea to JDBCProxy, but better).
It would work in a similar manner to this:
String connectionString = "jdbc:stub:<stub_definition_file>";
Connection connection = DriverManager.getConnection(connectionString, "username", "password");
The stub connection could then be used to create statements, which when executed return whatever data we define in the <stub_definition_file>.
I have a couple of questions:
1) Are there any (mature) existing libraries which do this already?
2) Is this is a good approach to the problem of testing code that accesses a database? (It means we can run unit tests without the dependency of a test database).
