title: Best practices while calling a Stored Procedure from JDBC
body: <p>I am trying to improving my application's performance be combining multiple query calls into Stored Procedures. This will reduce n/w traffic, round trips and also separate data-processing logic from application.</p>
  
  <p>While I am at it, I am thinking of using most efficient way to do it. </p>
  
  <p>As of now, I am planning to use <code>PreparedStatement</code> with <code>prepareCall</code> method. </p>
  
  <p>If there is a better way of doing it, please suggest. </p>
  
  <p>I will need to pass many <code>IN params</code> to procedures and will also need <code>OUT params</code> back in <code>JAVA</code>  code. </p>