How to Call Stored Procedures using JDBC

CallableStatement stmt = null ;

ResultSet resSet =null ;

Try{

stmt = connection.prepareCall("{call sp_name}") ;

resSet = stmt.executeQuery() ;

//parse the resSet.

}catch(SQLException e) {

 // Log error or Retry the transaction

} finally {

 close the statement & Resultset.

}