1. OpenJPA
  2. OPENJPA-876

Better test profiles for proprietary databases (DB2, Oracle) and continuous build


    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.3, 1.1.0, 1.2.0, 1.3.0, 2.0.0-M2
    • Fix Version/s: 1.0.4, 1.2.1, 1.3.0, 2.0.0-M2
    • Component/s: None
    • Labels:


      Currently we use the test-custom and test-custom2 profiles in openjpa-persistence-jdbc/pom.xml to enable testing of a variety of databases. Basically anything that does not have a publicly available JDBC drivers.

      This support works well if you run the build manually, but isn't always perfect when using a continuous build system.

      In many continuous build systems you want to have a single build definition which can be run on any number of machines. Ideally each machine could store the database settings in $


      /.m2/settings.xml. Where this becomes a problem is if a single machine wants to use our test-custom profile in conjuction with another one. For example mvn -Ptest-custom,test-custom-oracle clean install. In order to make this work Maven would have to set variables in test-custom-oracle and then read them in the test-custom profile. Ensuring that the properties are handled in the correct order is cumbersome and doesn't seem to work in recent versions of maven / surefire.

      To resolve the problem I propose creating specific profiles for testing with various proprietary databases. These profiles rely on the user running mvn install:install-file $

      {maven args}

      to install a copy of the jdbc drivers in a local repository prior to running, but after that one time setup step it's a lot easier to run tests on various databases (manually or on a build system).

      1. OPENJPA-876-branches13x.patch
        8 kB
        Donald Woods
      2. OPENJPA-876-trunk.patch
        8 kB
        Donald Woods



          • Assignee:
            Michael Dick
            Michael Dick
          • Votes:
            0 Vote for this issue
            0 Start watching this issue


            • Created: