title: How to get the current status of a procedure in postgresql using spring batch
body: <p>I have a spring batch job that executes a procedure in PostgreSQL, now my problem is I want that procedure to get completed before I execute the next step.</p>
  <p>But from spring batch I can only execute <code>CALL procedureName()</code> using <code>jdbcTemplate</code> from my dao layer, But I don't know how to get the status of running procedure like whether it is running or not and is it still running. Thanks</p>