title: Avoid Creating SimpleJdbcCall multiple times
body: <p>I have to call callDb  around 20,000 in Service layer . with the below was it is taking 30 minutes because i am creating
  SimpleJdbcCall  object everytime..How can i avoid creating SimpleJdbcCall object   for each call.</p>
  <pre><code>@Repository
  public class JdbcActorDao  {
  
  
  
   void callDb ( ) 
   
   
   {
   
   
          SimpleJdbcCall simpleJdbcCall =
                  new SimpleJdbcCall(jdbcTemplate)
                          .withProcedureName(&quot;read_actor&quot;)
                          .withoutProcedureColumnMetaDataAccess()
                          .useInParameterNames(&quot;in_id&quot;)
                          .declareParameters(
                                  new SqlParameter(&quot;in_id&quot;, Types.NUMERIC),
                                  new SqlOutParameter(&quot;out_first_name&quot;, Types.VARCHAR),
                                  new SqlOutParameter(&quot;out_last_name&quot;, Types.VARCHAR),
                                  new SqlOutParameter(&quot;out_birth_date&quot;, Types.DATE)
                          );
      }
  
  
  
  
  simpleJdbcCall.execute(...) ;
  
  
  }
  </code></pre>