title: Can Spring Batch work with Amazon Redshift?
body: <p>I'm trying to use Spring Batch (4.0.1.RELEASE) working with Amazon Redshift. I got through the first major problem with Redshift's lack of support for sequences <a href="https://stackoverflow.com/questions/20789731/using-redshfit-as-spring-batch-job-repository-and-alternatives-to-sequence-in-re">here</a>.</p>
  
  <p>However, now I've run into this when I try to run a job:</p>
  
  <pre><code>10:57:07.122 ERROR [http-nio-8080-exec-4 ] [JobLaunchingService] [] Could not start job [demoJob]
  org.springframework.dao.InvalidDataAccessApiUsageException: PreparedStatementCallback; SQL [INSERT INTO BATCH_JOB_EXECUTION_CONTEXT (SHORT_CONTEXT, SERIALIZED_CONTEXT, JOB_EXECUTION_ID) VALUES(?, ?, ?)[Amazon][JDBC](10220) Driver does not support this optional feature.; nested exception is java.sql.SQLFeatureNotSupportedException: [Amazon][JDBC](10220) Driver does not support this optional feature.
  </code></pre>
  
  <p>This is with the Redshift 1.2.16.1027 JDBC Driver.</p>
  
  <p>Is it even possible to use Redshift as the batch database? Any suggestions on how to get around this?</p>