{{theTime}}

Search This Blog

Total Pageviews

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.
}

No comments:

ImmutableList Example

private ImmutableList<String> getServerProps(){       ImmutableList.Builder<String> serverProps = ImmutableList.builder();      ...