4.0.0 com.atlassian.bamboo atlassian-bamboo 8.0.0 atlassian-bamboo-tests-parent pom Atlassian Bamboo Tests Parent localhost bamboo_functest bamboo_functest bamboo_functest bamboo-upgrade-tests bamboo-plugin-points-test bamboo-docker-images-tests org.codehaus.mojo sql-maven-plugin ${db.admin.username} ${db.admin.password} ${db.admin.url} ${jdbc.driver} mysql mysql 3306 root root jdbc:mysql://${db.host}:${db.port} bamboo bamboo com.mysql.cj.jdbc.Driver jdbc:mysql://${db.host}:${db.port}/${db.instance}?autoReconnect=true&useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true com.atlassian.maven.plugins bamboo-maven-plugin mysql jdbc ${db.username} ${db.password} ${db.url} org.codehaus.mojo sql-maven-plugin drop-database clean execute true DROP DATABASE `${db.instance}`; DROP USER '${db.username}'@'${db.host}'; continue create-database clean execute true CREATE DATABASE `${db.instance}` CHARACTER SET UTF8 COLLATE utf8_bin; CREATE USER '${db.username}'@'${db.host}' IDENTIFIED BY '${db.password}'; GRANT ALL ON `${db.instance}`.* TO '${db.username}'@'${db.host}'; abort mssql 1433 sa com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://${db.host}:${db.port} Ighu0jie mssql-remote ${mssql.db.instance} ${mssql.db.host} sa com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://${db.host}:${db.port};databaseName=${db.instance} com.atlassian.maven.plugins bamboo-maven-plugin mssql jdbc ${db.username} ${db.password} ${db.url} org.codehaus.mojo sql-maven-plugin drop-database clean execute true DROP DATABASE "${db.instance}"; continue create-database clean execute true CREATE DATABASE "${db.instance}" CONTAINMENT = PARTIAL COLLATE Latin1_General_CS_AS; abort add-user-to-database clean execute true ALTER DATABASE "${db.instance}" SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE; USE "${db.instance}"; CREATE USER ${db.username} WITH PASSWORD = '${db.password}'; EXEC sp_addrolemember 'db_owner', '${db.username}'; abort mssql-docker bamboo localhost Passw0rd ${db.admin.url};databaseName=${db.instance} com.atlassian.maven.plugins bamboo-maven-plugin mssql jdbc ${db.username} ${db.password} ${db.url} org.codehaus.mojo sql-maven-plugin create-database clean execute true CREATE DATABASE "${db.instance}" COLLATE Latin1_General_CS_AS; abort add-user-to-database clean execute true ALTER DATABASE "${db.instance}" SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE; CREATE LOGIN ${db.username} WITH PASSWORD = '${db.password}', DEFAULT_DATABASE=master, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF; USE "${db.instance}"; ALTER AUTHORIZATION ON DATABASE::${db.instance} TO ${db.username}; abort oracle 1521 oracle sys oracle JIRADB jdbc:oracle:thin:@${db.host}:${db.port}:${db.instance} jira jira oracle.jdbc.OracleDriver jdbc:oracle:thin:@${db.host}:${db.port}:${db.instance} com.atlassian.maven.plugins bamboo-maven-plugin oracle12c jdbc ${db.username} ${db.password} ${db.url} pgsql 5432 postgres postgres postgres jdbc:postgresql://${db.host}:${db.port}/postgres org.postgresql.Driver jdbc:postgresql://${db.host}:${db.port}/${db.instance} com.atlassian.maven.plugins bamboo-maven-plugin postgresql jdbc ${db.username} ${db.password} ${db.url} org.codehaus.mojo sql-maven-plugin drop-database clean execute true DROP DATABASE IF EXISTS "${db.instance}"; DROP ROLE IF EXISTS "${db.username}"; continue create-database clean execute true CREATE ROLE "${db.username}" NOSUPERUSER NOCREATEDB NOCREATEROLE LOGIN ENCRYPTED PASSWORD '${db.password}'; CREATE DATABASE "${db.instance}" WITH OWNER "${db.username}" ENCODING 'UTF8'; abort