Spring批处理未获得Spring属性。一批表前缀

Question

当我在应用程序属性中添加表前缀时，我遇到了一个问题，Spring Batch没有获取该属性并设置默认前缀Batch。

spring.batch.table-prefix=SOMETHING.BATCH_

Spring版

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.1.4.RELEASE</version>
</parent>
<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
        <version>2.0.4.RELEASE</version>
        <exclusions>
            <exclusion>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-logging</artifactId>
            </exclusion>
        </exclusions>
</dependency>
<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-batch</artifactId>
        <version>2.1.2.RELEASE</version>
 </dependency>

org.springframework.jdbc.错误的SQL语法[SELECTJOB_INSTANCE_ID，JOB_NAMEBATCH_JOB_INSTANCEJOB_NAME=？和JOB_KEY = ?]; 嵌套异常java.sql.SQLSyntaErrorException： ORA-00942： table or view不存在

Answer 1

我解决了问题，效果很好。

我注入了一个用JobRepositoryFactoryBean创建的新JobRepository。在JobRepositoryFactoryBean中，我配置了数据源和前缀，当作业启动时，JdbcJobInstanceDao具有前缀。

我分享解决方案：

       private PlatformTransactionManager transactionManager(){
          return new ResourcelessTransactionManager();
        }
      private JobRepository createJobRepository() throws Exception {
         JobRepositoryFactoryBean factory = new JobRepositoryFactoryBean();
         factory.setDataSource(dataSourceAudit);
         factory.setTransactionManager(transactionManager());
         factory.setIsolationLevelForCreate("ISOLATION_READ_COMMITTED");
         factory.setTablePrefix("SOMETHING.BATCH_");
         factory.setDatabaseType("ORACLE");
         factory.setMaxVarCharLength(1000);
          return factory.getObject();
      }

      @Bean
        public JobLauncher jobLauncherBc() throws Exception{
             SimpleJobLauncher jobLauncher = new SimpleJobLauncher();
             jobLauncher.setTaskExecutor(new SimpleAsyncTaskExecutor());
             jobLauncher.setJobRepository(createJobRepository());
            return jobLauncher;
    }