1

I am working on a legacy project which is build on purely Java/J2EE servlets. No spring and other frameworks. It is built on ant. Now I want to integrate junit with my project, I am able to integrate but I want to mock the DB and run the test cases in the mocked DB connection. I think in spring boot we can easily do that with H2 database. But only challenge I am facing is we are not using spring boot. I am able to mock the functions and run the test cases but what I need is to mock the full database and run the test classes on my mocked database. Any leads how I can achieve this or it is feasible or not?

Tech Geek
  • 437
  • 1
  • 4
  • 19

1 Answers1

0

You can run h2 database in pure java since it is written in it. See H2 Documentation.

Start h2 database server in pure java and run sql script

  1. To start a tcp-server you can use a Server tool:

    Server server = Server.createTcpServer();
server.start();

    To to start also a web-server (with h2-console) you can add:

    Server server = Server.createWebServer();
server.start();

  2. To open JdbcConnection and RunScript you can write something like this:

    private void createTables(String url, String username,
                          String password, File script)
        throws SQLException, IOException {

    Properties info = new Properties();
    info.put("user", username);
    info.put("password", password);

    JdbcConnection connection = new JdbcConnection(url, info);
    InputStreamReader reader =
            new InputStreamReader(new FileInputStream(script));

    RunScript.execute(connection, reader);

    reader.close();
    connection.close();
}

See also: