title: Spring Batch Framework - Auto create Batch Table
body: <p>I just created a batch job using Spring Batch framework, but I don't have Database privileges to run CREATE SQL. When I try to run the batch job I hit the error while the framework tried to create TABLE_BATCH_INSTANCE. I try to disable the </p>
  
  <pre><code>&lt;jdbc:initialize-database data-source="dataSource" enabled="false"&gt;    
   ...
  &lt;/jdbc:initialize-database&gt;
  </code></pre>
  
  <p>But after I tried I still hit the error </p>
  
  <pre><code>org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  </code></pre>
  
  <p>Anyway can disable the SQL, I just want to test my reader writer and processor work properly. </p>