How do I unit test jdbc code in java? [closed]

by

You have several options:

  • Mock the database with a Mock library, e.g. JMock. The huge drawback of this that your queries and the data will most likely be not tested at all.
  • Use a light weight database for the tests, such as HSQLDB. If your queries are simple, this is probably the easiest way to go.
  • Dedicate a database for the tests. DBUnit is a good option, or if you are using Maven, you can also use the sql-maven-plugin to set up and tear down the database properly (be careful of dependencies between tests). I recommend this option as it will give you the biggest confidence that the queries work properly with your db vendor.

Sometimes it is necessary and useful to make these tests configurable so that these tests are only executed if the database is available. This can be done with e.g. build properties.

More Related Contents:

  1. How to simulate a DB for testing (Java)?
  2. Conditionally ignoring tests in JUnit 4
  3. Test class with a new() call in it with Mockito
  4. Assert equals between 2 Lists in Junit
  5. Mockito : how to verify method was called on an object created within a method?
  6. How to tell a Mockito mock object to return something different the next time it is called?
  7. Get name of currently executing test in JUnit 4
  8. How to get all table names from a database?
  9. How to test code dependent on environment variables using JUnit?
  10. How is driver class located in JDBC4
  11. Multiple RunWith Statements in jUnit
  12. How to run all tests belonging to a certain Category in JUnit 4
  13. How to set JVM parameters for Junit Unit Tests?
  14. How to write junit tests for interfaces?
  15. How to use JUnit to test asynchronous processes
  16. AssertEquals 2 Lists ignore order
  17. How to verify that a specific method was not called using Mockito?
  18. JUnit 4: Set up things in a test suite before tests are run (like a test’s @BeforeClass method, just for a test suite)
  19. How to test a Jersey REST web service?
  20. com.mysql.jdbc.PacketTooBigException
  21. Injecting @Autowired private field during testing
  22. Why are my mocked methods not calld when executing a unit test?
  23. Forming Mockito “grammars”
  24. differences between 2 JUnit Assert classes
  25. Concurrent JUnit testing
  26. Java PreparedStatement UTF-8 character problem
  27. How can I unit test void functions?
  28. JUnit: new instance before invoking each @Test method. What are the benefits?
  29. JUnit test with dynamic number of tests
  30. Easier DynamoDB local testing

Leave a Comment