{{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:

BlockingQueue Applications

Java BlockingQueue is a versatile data structure that can be used in various real-time scenarios where multiple threads need to communicate ...