On 09/10/2016 03:52 AM, Aristedes Maniatis wrote: > On 5/08/2016 10:51am, Aristedes Maniatis wrote: >> Apache Cayenne runs tests against a couple of in-memory databases under >> Jenkins: >> >> https://builds.apache.org/job/cayenne-master >> >> >> I'd like to set up tests against other common databases since database >> integration tests are absolutely critical to the Cayenne project. At the >> very least MS-SQL, mysql, mariadb and postgresql would be lovely. Even more >> would be better... >> >> Do we already have this sort of infrastructure available to us? >> > > > Is there any database infrastructure available for Jenkins builds?
At least for the open source databases (mysql, mariadb, postgres) you can consider to use Docker, there already exists "official" Docker images. In your Jenkins job you can start e.g. a Postgres Docker container before the main build and stop/remove it after the build. Or, as Cayenne uses a Maven build: I made good experience with [1], that's a Maven plugin that starts a Docker container in pre-integration-test phase and stops it in post-integration-test phase. Kind Regards, Stefan [1] https://dmp.fabric8.io/
