Run DB certification tests with Fuse 7.11 AR26 on EAP

Automatic triggering of the job:

• This jenkins-job should be launched automatically by our pipeline. Results of test-run are loaded into polarion .
  All relevant parameters are loaded automatically from UMB message. Explanation of fields (with example value):
• GIT_BRANCH (master), refers to git branch of https://gitlab.cee.redhat.com/jboss-fuse-qe/jbossqe-camel-it
• GIT_BRANCH_JJ (master), refers to git branch of https://gitlab.cee.redhat.com/jboss-fuse-qe/jenkins-jobs
• JOB_MVN_PROPERTIES (version.camel=2.23.2.fuse-7_10_0-00020-redhat-00001,version.wildfly.camel=5.8.0.fuse-7_10_0-00010-redhat-00001,version.redhat.fuse=7.10.0.fuse-sb2-7_10_0-00014-redhat-00001,
  version.fuse.eap=7.10.0.fuse-7_10_0-00012-redhat-00001,version.eap=7.4.2)
• VERSION_REDHAT_FUSE (7.10.0.fuse-sb2-7_10_0-00014-redhat-00001), Red Hat Fuse build version, see also curator artifact 'redhat'
• VERSION_FUSE_EAP (7.10.0.fuse-7_10_0-00012-redhat-00001)
• JOB_EAP_FUSE_INSTALLER_URL (file://${HUDSON_STATIC_ENV}/fuse/fuse-eap-installer-${VERSION_FUSE_EAP}.jar)
• JOB_EAP_URL (file://${HUDSON_STATIC_ENV}/eap/${VERSION_EAP}/jboss-eap-${VERSION_EAP}.zip)
• VERSION_EAP (7.4.2)
• MATRIX_FILTER
  This checkbox area is automatically selected via pairwise algorithm note-1. However, if you need to try other combinations - feel free to check/uncheck any combination.
  note-1: For further info, see pairwise project. There you could specify configurations of OS, PLATFORM, JOB_DB, jdk in models/database.txt file. Results (located in build/results/matrix_filter.groovy) are applicable for all database jobs (eap, karaf, and springboot2). To update jenkins-jobs matrix, the content of that groovy file has to be copied to ci-ops-fuse project in resources/matrix-filters/database.groovy)

Manual triggering of the job:

• Run the job with appropriate parameter values, e.g. see above (defaults).

Manual generation on your machine:

• way A
• 1) on your local, run 'export JIRA_ACCESS_TOKEN=xyz'
• 2) Download fuse-eap-intaller jar file (fuse-eap-installer-7.10.0.fuse-7_10_0-00012-redhat-00001.jar) and install it on EAP
• 3) Start EAP
• 4) in dbAllocator , allocate a database (e.g. Postgres). Otherwise, in-memory H2 database is used as default.
• 5) Execute on jbossqe-camel-it project:

  mvn clean install -Pjboss-eap -pl :database-integration-parent -Ddb=postgres \
  -Ddb.username=dballo10 -Ddb.password=dballo10 \
  -Ddb.jdbc_url="jdbc:postgresql://db20.mw.lab.eng.bos.redhat.com:5432/dballo10" \
  -Ddb.xadriver=org.postgresql.xa.PGXADataSource -Ddb.module=org.postgresql -am -amd -fae
  

  way B

• 1) on your local, run 'export JIRA_ACCESS_TOKEN=xyz'
• 2) clone jenkins-jobs (either 7.10.x or master)
• 3) 'cp src/main/resources/env.properties_template src/main/resources/env.properties' and update env.properties
• 4) to the location specified in 'workspace' properties of env.properties download jbossqe-camel-it ,
  default is current folder.
• 5) in jenkins-jobs folder run:

  mvn clean install exec:java -Dexec.arguments=database-camel-eap -DuseAlias \
  -Dconfig=jobs -Djob.db=postgres125
  

  if you want to test against postgres125, all options for testing are specified in /src/main/resources/databases.yaml

Successful tests: All test should be OK.

Failing tests:

Unstable/Flaky tests: