solution to errors - Neethahiremath/Wiki GitHub Wiki

postgress gets below error :


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 org.postgresql.util.PSQLException: ERROR: relation "batch_job_instance" does not exist
Position: 39
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235)
at

solution:

  • this is because its trying to create schema in db, to avoid that, add h2 in memory db in pom and provide the below code
@Configuration
@EnableBatchProcessing
public class Configuration extends DefaultBatchConfigurer{

@Override
  public void setDataSource(DataSource dataSource) {
    // override to do not set datasource even if a datasource exist.
    // initialize will use a Map based JobRepository (instead of database)
  }
}


*   batch:
    job:
      enabled: false


*  <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <scope>runtime</scope>
        </dependency>

⚠️ **GitHub.com Fallback** ⚠️