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

Kafka Consumer Parallelism

Kafka Parallel Consumer Options: Key-level parallelism:  Multiple threads process the messages from a single partition in parallel while ma...