Rishabh Agarwal jain Rishabh Agarwal jain - 1 year ago 69
MySQL Question

Make the JDBC call throw a SQLException for a test case

I am writing test cases for my program and to maximize the code coverage I have to raise a SQLException, that exception will then be checked in my test case.

public double getTotalAmount(String form,String name) {
DbManager manager = new DbManager();
double amount = 0;
ResultSet executeQuery = manager.findAll("select amount From "+form+" where employee_name='"+name+"'");
try {
while (executeQuery.next()) {
String tempAmount = executeQuery.getString("amount");
amount += Double.valueOf(tempAmount);
return amount;
} catch (SQLException e) {

return -1;

Now I am unable to raise the SQLException in my code, can you suggest me how can I raise this exception in my code.

Answer Source

According to the javadocs


SQLException - if the columnIndex is not valid;

so in your code do

String tempAmount = executeQuery.getString(1000);

If your tester class needs to catch this exception, then you will also need to throw it from getTotalAmount

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download