Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1036

Modeshape unit test JpaConnectorNoCreateWorkspaceTest freezes when Oracle is used.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 2.4.0.Final, 2.2.1.GA
    • 2.2.1.GA
    • Storage
    • None
    • Workaround Exists
    • Hide

      When using Oracle, manually specify the "isolationLevel" property on the appropriate "mode:source" fragment in the ModeShape configuration to either "2" for TRANSACTION_READ_COMMITTED) or "8" for TRANSACTION_SERIALIZABLE.

      Show
      When using Oracle, manually specify the "isolationLevel" property on the appropriate "mode:source" fragment in the ModeShape configuration to either "2" for TRANSACTION_READ_COMMITTED) or "8" for TRANSACTION_SERIALIZABLE.

    Description

      Modeshape unit test JpaConnectorNoCreateWorkspaceTest freezes when Oracle is used as database. Test did not end even after 8 hours of running, it had to be aborted. The expcetion in test log is: java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels.

      Tested with Oracle 11g R2 and Oracle 10g.

      See: http://hudson.qa.jboss.com/hudson/view/BRMS/job/brms-modeshape-single/23/console


      Full stack trace:
      java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels
      at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:4368)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.setTransactionIsolation(NewProxyConnection.java:701)
      at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:80)
      at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113)
      at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
      at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
      at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
      at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:670)
      at org.modeshape.connector.store.jpa.JpaSource.getConnection(JpaSource.java:1180)
      at org.modeshape.graph.connector.test.AbstractConnectorTest$2.createConnection(AbstractConnectorTest.java:129)
      at org.modeshape.graph.Graph.execute(Graph.java:278)
      at org.modeshape.graph.Graph$5.process(Graph.java:226)
      at org.modeshape.graph.request.RequestBuilder.verifyWorkspace(RequestBuilder.java:72)
      at org.modeshape.graph.Graph.useWorkspace(Graph.java:377)
      at org.modeshape.connector.store.jpa.JpaConnectorNoCreateWorkspaceTest.initializeContent(JpaConnectorNoCreateWorkspaceTest.java:78)
      at org.modeshape.graph.connector.test.AbstractConnectorTest.startRepository(AbstractConnectorTest.java:168)
      at org.modeshape.graph.connector.test.AbstractConnectorTest.beforeEach(AbstractConnectorTest.java:209)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.junit.internal.runners.MethodRoadie.runBefores(MethodRoadie.java:122)
      at org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:86)
      at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:77)
      at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
      at org.junit.internal.runners.JUnit4ClassRunner.invokeTestMethod(JUnit4ClassRunner.java:88)
      at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
      at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
      at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
      at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
      at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
      at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:36)
      at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:420)
      at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:911)
      at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:743)
      2010-11-24 07:43:59,262 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (main) schema export unsuccessful
      java.sql.SQLException: READ_COMMITTED and SERIALIZABLE are the only valid transaction levels
      at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:4368)
      at com.mchange.v2.c3p0.impl.NewProxyConnection.setTransactionIsolation(NewProxyConnection.java:701)
      at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:80)
      at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
      at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)
      at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
      at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:352)
      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
      at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
      at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:670)
      at org.modeshape.connector.store.jpa.JpaSource.getConnection(JpaSource.java:1180)
      at org.modeshape.graph.connector.test.AbstractConnectorTest$2.createConnection(AbstractConnectorTest.java:129)
      at org.modeshape.graph.Graph.execute(Graph.java:278)
      at org.modeshape.graph.Graph$5.process(Graph.java:226)
      at org.modeshape.graph.request.RequestBuilder.verifyWorkspace(RequestBuilder.java:72)
      at org.modeshape.graph.Graph.useWorkspace(Graph.java:377)
      at org.modeshape.connector.store.jpa.JpaConnectorNoCreateWorkspaceTest.initializeContent(JpaConnectorNoCreateWorkspaceTest.java:78)
      at org.modeshape.graph.connector.test.AbstractConnectorTest.startRepository(AbstractConnectorTest.java:168)
      at org.modeshape.graph.connector.test.AbstractConnectorTest.beforeEach(AbstractConnectorTest.java:209)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.junit.internal.runners.MethodRoadie.runBefores(MethodRoadie.java:122)
      at org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:86)
      at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:77)
      at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
      at org.junit.internal.runners.JUnit4ClassRunner.invokeTestMethod(JUnit4ClassRunner.java:88)
      at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
      at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
      at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
      at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
      at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
      at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:36)
      at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:420)
      at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:911)
      at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:743)

      Attachments

        Activity

          People

            rhauch Randall Hauch (Inactive)
            psiroky_jira Petr Široký (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: