camunda-database-settings
Used in:
components
- OverviewOverview
- VersionsVersions
- DependentsDependents
- DependenciesDependencies
<dependency>
<groupId>org.camunda.bpm</groupId>
<artifactId>camunda-database-settings</artifactId>
<version>7.23.0</version>
</dependency><?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.camunda.bpm</groupId>
<artifactId>camunda-parent</artifactId>
<relativePath>../parent</relativePath>
<version>7.23.0</version>
</parent>
<artifactId>camunda-database-settings</artifactId>
<packaging>pom</packaging>
<name>Camunda Platform - database settings</name>
<description>Provides general dependencies and profiles for database testing</description>
<properties>
<!-- database driver versions -->
<version.h2>2.3.232</version.h2>
<version.h2-v1>1.4.200</version.h2-v1><!-- used for instance migration qa -->
<version.oracle>23.5.0.24.07</version.oracle>
<version.mysql>8.3.0</version.mysql>
<version.sqlserver>8.4.1.jre8</version.sqlserver>
<version.db2-11.5>11.5.0.0</version.db2-11.5>
<version.db2>${version.db2-11.5}</version.db2>
<version.postgresql>42.5.5</version.postgresql>
<version.liquibase>4.8.0</version.liquibase>
<!-- needed for sql script and backward compatibility checks -->
<camunda.version.old>7.22.0</camunda.version.old>
<!-- Testcontainers JDBC URL parameters. By default, an empty string -->
<database.tc.params />
</properties>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>${version.h2}</version>
</dependency>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc11</artifactId>
<version>${version.oracle}</version>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>${version.mysql}</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>${version.sqlserver}</version>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>${version.postgresql}</version>
</dependency>
<dependency>
<groupId>com.ibm.db2</groupId>
<artifactId>jcc</artifactId>
<version>${version.db2}</version>
</dependency>
</dependencies>
</dependencyManagement>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<configuration>
<driver>${database.driver}</driver>
<url>${database.url}</url>
<username>${database.username}</username>
<password>${database.password}</password>
</configuration>
</plugin>
<plugin>
<groupId>org.liquibase</groupId>
<artifactId>liquibase-maven-plugin</artifactId>
<version>${version.liquibase}</version>
<configuration>
<driver>${database.driver}</driver>
<url>${database.url}</url>
<username>${database.username}</username>
<password>${database.password}</password>
<hubMode>off</hubMode>
<promptOnNonLocalDatabase>false</promptOnNonLocalDatabase>
</configuration>
</plugin>
</plugins>
</pluginManagement>
</build>
<profiles>
<profile>
<id>db2</id>
<properties>
<database.type>db2</database.type>
<database.driver>com.ibm.db2.jcc.DB2Driver</database.driver>
<database.datasource.class>com.ibm.db2.jcc.DB2SimpleDataSource</database.datasource.class>
</properties>
</profile>
<profile>
<id>db2-115</id>
<properties>
<version.db2>${version.db2-11.5}</version.db2>
</properties>
<dependencies>
<dependency>
<groupId>com.ibm.db2</groupId>
<artifactId>jcc</artifactId>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>com.ibm.db2</groupId>
<artifactId>jcc</artifactId>
<version>${version.db2}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>h2-in-memory</id>
<activation>
<activeByDefault>true</activeByDefault>
</activation>
<properties>
<database.url>jdbc:h2:mem:camunda;DB_CLOSE_DELAY=1000;LOCK_TIMEOUT=10000</database.url>
<database.driver>org.h2.Driver</database.driver>
<database.username>sa</database.username>
<database.password />
<hibernate.dialect>org.hibernate.dialect.H2Dialect</hibernate.dialect>
</properties>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>${version.h2}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>h2</id>
<properties>
<database.host>${project.parent.basedir}/target/h2/</database.host>
<database.name>process-engine</database.name>
<database.username>sa</database.username>
<database.password>sa</database.password>
<database.port>18080</database.port>
<!-- This url has to consistent for the subprojects: {server}-runtime and webapp-integration-tests -->
<database.url>jdbc:h2:${database.host}${database.name};AUTO_SERVER=TRUE;AUTO_SERVER_PORT=${database.port};LOCK_TIMEOUT=10000</database.url>
<database.type>h2</database.type>
<database.driver>org.h2.Driver</database.driver>
<database.datasource.class>org.h2.jdbcx.JdbcDataSource</database.datasource.class>
<jboss.datasource.filename>h2-ds.xml</jboss.datasource.filename>
<was.liberty.datasource.filename>h2-config.xml</was.liberty.datasource.filename>
<hibernate.dialect>org.hibernate.dialect.H2Dialect</hibernate.dialect>
</properties>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>${version.h2}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>mysql</id>
<properties>
<database.type>mysql</database.type>
<database.driver>com.mysql.cj.jdbc.Driver</database.driver>
<database.datasource.class>com.mysql.cj.jdbc.MysqlDataSource</database.datasource.class>
<database.tc.url>cammysql:8.0</database.tc.url>
<database.tc.params>/${database.name}?sendFractionalSeconds=false&amp;user=${database.username}&amp;password=${database.password}</database.tc.params>
</properties>
<dependencies>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>${version.mysql}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>oracle</id>
<properties>
<database.type>oracle</database.type>
<database.driver>oracle.jdbc.OracleDriver</database.driver>
<database.datasource.class>oracle.jdbc.pool.OracleDataSource</database.datasource.class>
</properties>
<dependencies>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc11</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc11</artifactId>
<version>${version.oracle}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>postgresql</id>
<properties>
<database.type>postgres</database.type>
<database.driver>org.postgresql.Driver</database.driver>
<database.datasource.class>org.postgresql.ds.PGSimpleDataSource</database.datasource.class>
<jboss.datasource.filename>postgresql-ds.xml</jboss.datasource.filename>
<was.liberty.datasource.filename>postgresql-config.xml</was.liberty.datasource.filename>
<hibernate.dialect>org.hibernate.dialect.PostgreSQLDialect</hibernate.dialect>
<database.tc.url>campostgresql:13.2</database.tc.url>
</properties>
<dependencies>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>${version.postgresql}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>postgresql-xa</id>
<properties>
<database.datasource.class>org.postgresql.xa.PGXADataSource</database.datasource.class>
<jboss.datasource.filename>postgresql-xa-ds.xml</jboss.datasource.filename>
<was.liberty.datasource.filename>postgresql-xa-config.xml</was.liberty.datasource.filename>
</properties>
</profile>
<profile>
<id>sqlserver</id>
<properties>
<database.type>mssql</database.type>
<database.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</database.driver>
<database.datasource.class>com.microsoft.sqlserver.jdbc.SQLServerDataSource</database.datasource.class>
<database.tc.url>camsqlserver:2019</database.tc.url>
<database.tc.params>;DatabaseName=${database.name};user=${database.username};password=${database.password};</database.tc.params>
</properties>
<dependencies>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>${version.sqlserver}</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</pluginManagement>
</build>
</profile>
<profile>
<id>sqlserver-2017</id>
<properties>
<database.tc.url>camsqlserver:2017</database.tc.url>
</properties>
</profile>
<profile>
<id>testcontainers</id>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>com.fasterxml.jackson</groupId>
<artifactId>jackson-bom</artifactId>
<version>${version.jackson}</version>
<scope>import</scope>
<type>pom</type>
</dependency>
</dependencies>
</dependencyManagement>
<dependencies>
<!-- Testcontainers depends on docker-java which depends on jackson-annotations -->
<dependency>
<artifactId>jackson-annotations</artifactId>
<groupId>com.fasterxml.jackson.core</groupId>
<scope>test</scope>
</dependency>
</dependencies>
</profile>
</profiles>
</project>
Open source consumption has exploded, with estimates placing this year’s downloads at over 6.6 trillion. This reliance on open source components, now making up to 90% of the modern software application, has ushered in both unprecedented innovation and complex challenges for software supply chains.
View the Report