Camunda对数据库创建脚本使用单独的用户开发者社区

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

考研的紫菜汤 · 1985年诺贝尔医学、生理学奖成果介绍· 1 年前 ·

刀枪不入的火锅 · 中国证券监督管理委员会深圳监管局行政处罚决定 ...· 1 年前 ·

慷慨大方的野马 · 2023曼岛TT第9日西班牙车手马丁内斯发生 ...· 1 年前 ·

知识渊博的橡皮擦 · 新型推进系统赋能未来航空业发展 - ...· 1 年前 ·

果断的风衣 · 华硕主板U盘启动快捷键详解-华硕-淘宝百科网· 1 年前 ·

腾讯云

开发者社区

文档意见反馈控制台

首页 TVP

文章/答案/技术大牛

发布

spring.datasource.url=<database url>
spring.datasource.username=<app username>
spring.datasource.password=<password>
spring.datasource.driverClassName=<driver>

datasource:
    initialize: false
    type: com.zaxxer.hikari.HikariDataSource
    jdbcUrl: jdbc:oracle:thin:@192.168.0.1:1521:MYDB
    username: MYAPP
    password: MYAPP
camunda.bpm:
        job-execution-enabled:  true
        history-level: FULL
        auto-deployment-enabled: true
        id-generator: strong
        checkProcessDefinitions: true
        deployment-resource-pattern:  classpath:/process/**/*.bpmn
        datasource:
          type: com.zaxxer.hikari.HikariDataSource
          schema-update: true
          schema-name: camunda
          jdbcUrl: jdbc:oracle:thin:@192.168.0.1:1521:MYDB
          username: camunda
          password: camunda

 package org.valz.service.impl;
 import java.io.IOException;
 import java.sql.SQLException;
 import javax.naming.NamingException;
 import javax.sql.DataSource;
 import org.valz.framework.common.core.Constants;
 import org.camunda.bpm.engine.spring.ProcessEngineFactoryBean;
 import org.camunda.bpm.engine.spring.SpringProcessEngineConfiguration;
 import org.camunda.bpm.engine.spring.SpringProcessEngineServicesConfiguration;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
 import org.springframework.boot.context.properties.ConfigurationProperties;
 import org.springframework.context.annotation.Bean;
 import org.springframework.context.annotation.Configuration;
 import org.springframework.context.annotation.Import;
 import org.springframework.context.annotation.Profile;
 import org.springframework.core.io.Resource;
 import org.springframework.core.io.support.ResourcePatternResolver;
 import org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor;
 import org.springframework.jdbc.datasource.DataSourceTransactionManager;
 import org.springframework.jndi.JndiTemplate;
 import org.springframework.transaction.PlatformTransactionManager;
 @Configuration
 @Import( SpringProcessEngineServicesConfiguration.class )
 public class CamundaConfiguration  {
     @Value("${spring.camunda.bpm.history-level}")
     private String historyLevel;
     // add more configuration here
     // ---------------------------
     // configure data source via application.properties
     @Autowired
     private ResourcePatternResolver resourceLoader;
     @Bean
     // @ConfigurationProperties(prefix="spring.camunda.bpm")
     public SpringProcessEngineConfiguration processEngineConfiguration() throws IOException {
         SpringProcessEngineConfiguration config = new SpringProcessEngineConfiguration();
         config.setDataSource(camundaDataSource());
         config.setDatabaseSchemaUpdate("true");
         config.setTransactionManager(transactionManager());
         config.setHistory(historyLevel);
         config.setJobExecutorActivate(false);
         config.setMetricsEnabled(false);
         config.setJdbcBatchProcessing(false);
         // deploy all processes from folder 'processes'classpath:/process/*.bpmn
         Resource[] resources = resourceLoader.getResources("classpath:/process/**/*.bpmn");
         config.setDeploymentResources(resources);
         return config;
     @Bean
     public PlatformTransactionManager transactionManager() {
         return new DataSourceTransactionManager(camundaDataSource());
     @Bean(name="camundaBpmDataSource")
     @ConfigurationProperties(prefix="spring.camunda.bpm.dataSource")
     @Profile(Constants.SPRING_PROFILE_DEVELOPMENT)
     public DataSource camundaDataSource() {
         System.out.println("spring.camunda.bpm.dataSource");
         return DataSourceBuilder.create().build();
     @Bean(name = "camundaBpmDataSource")
     @Profile(Constants.SPRING_PROFILE_PRODUCTION)
     public DataSource jndiDataSource() throws SQLException, NamingException {
         JndiTemplate jndi = new JndiTemplate();
         DataSource dataSource = (DataSource) jndi.lookup("camunda");
         return dataSource;
     @Bean
     public ProcessEngineFactoryBean processEngine() throws IOException {
         ProcessEngineFactoryBean factoryBean = new ProcessEngineFactoryBean();
         factoryBean.setProcessEngineConfiguration(processEngineConfiguration());
         return factoryBean;
 }

package org.Valz.boot.config;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.context.annotation.Profile;
import org.springframework.jdbc.datasource.lookup.JndiDataSourceLookup;
import org.springframework.transaction.annotation.EnableTransactionManagement;
@Configuration
@EnableTransactionManagement
public class DatabaseConfiguration {
   public DatabaseConfiguration() {
@Bean(
    name = {"dataSource"}
@Primary
@ConfigurationProperties(

回答 1

Stack Overflow用户