ODE
  1. ODE
  2. ODE-666

Migrate from Derby to H2 as the default embedded test database

    Details

    • Type: Task Task
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.4
    • Fix Version/s: 1.3.6, 1.4
    • Component/s: None
    • Labels:
      None

      Activity

      Alexis Midon created issue -
      Hide
      Matthieu Riou added a comment -

      If I can give you one advice on this one, I'd say this: fuck Derby, use H2 instead as the default embedded database.

      Show
      Matthieu Riou added a comment - If I can give you one advice on this one, I'd say this: fuck Derby, use H2 instead as the default embedded database.
      Hide
      Rafal Rusin added a comment -

      At least we should make possible to run all ODE tests without derby.
      Now a lot of test cases (those without @Test(dataProvider="configs") entries use default config. This yields to using Derby when tests are executed with mysql config and does hangs.
      Jbi tests now use hib derby too.
      IMO default DB settings for tests should be set to localhost hib mysql, because we support this config the most (I think). User/password/db name could be default too.

      Show
      Rafal Rusin added a comment - At least we should make possible to run all ODE tests without derby. Now a lot of test cases (those without @Test(dataProvider="configs") entries use default config. This yields to using Derby when tests are executed with mysql config and does hangs. Jbi tests now use hib derby too. IMO default DB settings for tests should be set to localhost hib mysql, because we support this config the most (I think). User/password/db name could be default too.
      Alexis Midon made changes -
      Field Original Value New Value
      Priority Major [ 3 ] Blocker [ 1 ]
      Alexis Midon made changes -
      Summary Tests do not pass on Derby - locking issues Migrate from Derby to H2 as the default embedded database
      Alexis Midon made changes -
      Assignee Sean Ahn [ seanahn ]
      Hide
      Tammo van Lessen added a comment -

      Postponing it to 1.3.5 – could be solved as part of the JPA refactoring

      Show
      Tammo van Lessen added a comment - Postponing it to 1.3.5 – could be solved as part of the JPA refactoring
      Tammo van Lessen made changes -
      Issue Type Test [ 6 ] Task [ 3 ]
      Fix Version/s 1.3.5 [ 12314243 ]
      Fix Version/s 1.3.4 [ 12314168 ]
      Priority Blocker [ 1 ] Major [ 3 ]
      Rafal Rusin made changes -
      Assignee Sean Ahn [ seanahn ] Rafal Rusin [ rrusin ]
      Hide
      Rafal Rusin added a comment -

      Migrated axis2-war tests to h2

      ------------------------------------------------------------------------
      r959253 | rr | 2010-06-30 12:06:14 +0200 (śro) | 7 linii

      Expression namespace contexts memory optimization
      WSDL4J update
      SchemaCollection memory fix
      Resources cleanup
      Switched to H2 for axis-war tests
      Added h2 database creation

      Show
      Rafal Rusin added a comment - Migrated axis2-war tests to h2 ------------------------------------------------------------------------ r959253 | rr | 2010-06-30 12:06:14 +0200 (śro) | 7 linii Expression namespace contexts memory optimization WSDL4J update SchemaCollection memory fix Resources cleanup Switched to H2 for axis-war tests Added h2 database creation
      Tammo van Lessen made changes -
      Fix Version/s 1.4 [ 12315144 ]
      Fix Version/s 1.3.5 [ 12314243 ]
      Hide
      Tammo van Lessen added a comment - - edited

      this is fixed for trunk (1.4), at least for the test cases.

      Show
      Tammo van Lessen added a comment - - edited this is fixed for trunk (1.4), at least for the test cases.
      Tammo van Lessen made changes -
      Status Open [ 1 ] Resolved [ 5 ]
      Resolution Fixed [ 1 ]
      Tammo van Lessen made changes -
      Fix Version/s 1.3.6 [ 12323509 ]
      Tammo van Lessen made changes -
      Summary Migrate from Derby to H2 as the default embedded database Migrate from Derby to H2 as the default embedded test database
      Hide
      Hudson added a comment -

      UNSTABLE: Integrated in ODE-trunk-jdk6 #805 (See https://builds.apache.org/job/ODE-trunk-jdk6/805/)
      ODE-666 Migrated to H2 for bpel-runtime tests and bpel-test. Also cleaned up the axis2-war h2 tests. (vanto: rev dec47e4ba34045de1194be09aa311c10b101bbb7)

      • axis2-war/src/test/webapp/WEB-INF/conf.hib-derby/ode-axis2.properties
      • bpel-epr/src/main/java/org/apache/ode/il/dbutil/DerbyEmbeddedDB.java
      • axis2-war/src/test/webapp/WEB-INF/conf.jpa-derby/ode-axis2.properties
      • bpel-epr/src/main/java/org/apache/ode/il/dbutil/EmbeddedDB.java
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationMultiHibTest.java
      • dao-hibernate/src/test/java/org/apache/ode/daohib/bpel/BaseTestDAO.java
      • bpel-test/src/main/java/org/apache/ode/test/BPELTestAbstract.java
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/ProcessCronCleanupTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFaultTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanSuccessTest.java
      • bpel-epr/src/main/java/org/apache/ode/il/dbutil/DatabaseConnectionManager.java
      • bpel-epr/src/main/java/org/apache/ode/il/dbutil/InternalDB.java
      • bpel-epr/src/main/java/org/apache/ode/il/dbutil/Database.java
      • axis2-war/src/test/webapp/WEB-INF/conf.jpa-h2/ode-axis2.properties
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFailureHibTest.java
      • bpel-store/src/main/java/org/apache/ode/store/hib/DbConfStoreConnectionFactory.java
      • dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionFactoryImpl.java
      • bpel-store/src/test/java/org/apache/ode/store/hib/DaoTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/SystemCronCleanupTest.java
      • jbi/src/test/resources/smx-base.xml
      • dao-jpa-ojpa-derby/src/main/scripts/simplesched-h2.sql
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinLazyTest.java
      • bpel-epr/src/main/java/org/apache/ode/il/config/OdeConfigProperties.java
      • axis2-war/src/main/webapp/WEB-INF/conf/ode-axis2.properties
      • axis2-war/src/test/maven2/ode-axis2.properties
      • tasks/h2.rake
      • axis2-war/src/test/java/org/apache/ode/axis2/ODEConfigDirAware.java
      • bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/ClusteredOutgoingTrafficTest.java
      • axis2-war/src/test/webapp/WEB-INF/conf.hib-h2/ode-axis2.properties
      • axis2-war/src/test/java/org/apache/ode/axis2/management/InstanceManagementTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinHibTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/SelectorsTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinLazyHibTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/BpelActivityTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/Axis2TestBase.java
      • bpel-runtime/src/test/java/org/apache/ode/bpel/runtime/MockBpelServer.java
      • axis2-war/src/test/webapp/WEB-INF/conf/ode-axis2.properties
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationUnicityTest.java
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFaultHibTest.java
      • Rakefile
      • bpel-runtime/src/test/java/org/apache/ode/bpel/engine/cron/CronSchedulerTest.java
      • dao-jpa-ojpa-derby/src/main/descriptors/persistence.h2.xml
      • axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationMultiTest.java
      • bpel-epr/src/main/java/org/apache/ode/il/dbutil/H2EmbeddedDB.java
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanSuccessHibTest.java
      • tasks/derby.rake
      • axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFailureTest.java
      Show
      Hudson added a comment - UNSTABLE: Integrated in ODE-trunk-jdk6 #805 (See https://builds.apache.org/job/ODE-trunk-jdk6/805/ ) ODE-666 Migrated to H2 for bpel-runtime tests and bpel-test. Also cleaned up the axis2-war h2 tests. (vanto: rev dec47e4ba34045de1194be09aa311c10b101bbb7) axis2-war/src/test/webapp/WEB-INF/conf.hib-derby/ode-axis2.properties bpel-epr/src/main/java/org/apache/ode/il/dbutil/DerbyEmbeddedDB.java axis2-war/src/test/webapp/WEB-INF/conf.jpa-derby/ode-axis2.properties bpel-epr/src/main/java/org/apache/ode/il/dbutil/EmbeddedDB.java axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationMultiHibTest.java dao-hibernate/src/test/java/org/apache/ode/daohib/bpel/BaseTestDAO.java bpel-test/src/main/java/org/apache/ode/test/BPELTestAbstract.java axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/ProcessCronCleanupTest.java axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinTest.java axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFaultTest.java axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanSuccessTest.java bpel-epr/src/main/java/org/apache/ode/il/dbutil/DatabaseConnectionManager.java bpel-epr/src/main/java/org/apache/ode/il/dbutil/InternalDB.java bpel-epr/src/main/java/org/apache/ode/il/dbutil/Database.java axis2-war/src/test/webapp/WEB-INF/conf.jpa-h2/ode-axis2.properties axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFailureHibTest.java bpel-store/src/main/java/org/apache/ode/store/hib/DbConfStoreConnectionFactory.java dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/BpelDAOConnectionFactoryImpl.java bpel-store/src/test/java/org/apache/ode/store/hib/DaoTest.java axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/SystemCronCleanupTest.java jbi/src/test/resources/smx-base.xml dao-jpa-ojpa-derby/src/main/scripts/simplesched-h2.sql axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinLazyTest.java bpel-epr/src/main/java/org/apache/ode/il/config/OdeConfigProperties.java axis2-war/src/main/webapp/WEB-INF/conf/ode-axis2.properties axis2-war/src/test/maven2/ode-axis2.properties tasks/h2.rake axis2-war/src/test/java/org/apache/ode/axis2/ODEConfigDirAware.java bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java axis2-war/src/test/java/org/apache/ode/axis2/ClusteredOutgoingTrafficTest.java axis2-war/src/test/webapp/WEB-INF/conf.hib-h2/ode-axis2.properties axis2-war/src/test/java/org/apache/ode/axis2/management/InstanceManagementTest.java axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinHibTest.java axis2-war/src/test/java/org/apache/ode/axis2/SelectorsTest.java axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationJoinLazyHibTest.java axis2-war/src/test/java/org/apache/ode/axis2/BpelActivityTest.java axis2-war/src/test/java/org/apache/ode/axis2/Axis2TestBase.java bpel-runtime/src/test/java/org/apache/ode/bpel/runtime/MockBpelServer.java axis2-war/src/test/webapp/WEB-INF/conf/ode-axis2.properties axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationUnicityTest.java axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFaultHibTest.java Rakefile bpel-runtime/src/test/java/org/apache/ode/bpel/engine/cron/CronSchedulerTest.java dao-jpa-ojpa-derby/src/main/descriptors/persistence.h2.xml axis2-war/src/test/java/org/apache/ode/axis2/correlation/CorrelationMultiTest.java bpel-epr/src/main/java/org/apache/ode/il/dbutil/H2EmbeddedDB.java axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanSuccessHibTest.java tasks/derby.rake axis2-war/src/test/java/org/apache/ode/axis2/instancecleanup/CleanFailureTest.java

        People

        • Assignee:
          Rafal Rusin
          Reporter:
          Alexis Midon
        • Votes:
          1 Vote for this issue
          Watchers:
          4 Start watching this issue

          Dates

          • Created:
            Updated:
            Resolved:

            Development