How to mock a database connection with JUnit?

Question

Simply can't find a concrete example where a db connection is mocked. Preferred with Mockito.

public Connection getCon() throws SQLException, Exception {
        Properties login = new Properties();

        TimeZone timeZone = TimeZone.getTimeZone("GMT+2:00");
        TimeZone.setDefault(timeZone);

        Connection conn = null;
        conn = DriverManager.getConnection(url, username, password);

        return conn;
}

Want to test this method...

score 1 · Answer 1 · answered Feb 27 '20 at 13:23

1

All you need is to mock static class DriverManager. Here is an answer to exactly your issue: Mocking static methods with Mockito

answered Feb 27 '20 at 13:23

Misha Lemko

591
4
9

well...still can't figure it out – basti Feb 27 '20 at 14:17
@basti throw code, that don't work for you and the exception – Misha Lemko Feb 27 '20 at 15:01

How to mock a database connection with JUnit?

1 Answers1