Bug 724522 (BRMS-468)

Summary:	Modeshape unit test JpaConnectorNoCreateWorkspaceTest freezes when Oracle is used.
Product:	[JBoss] JBoss Enterprise BRMS Platform 5	Reporter:	Petr Široký <psiroky>
Component:	Modeshape	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	high
Version:	5.1.0.ER4	CC:	rhauch
Target Milestone:	---	Keywords:	TestBlocker
Target Release:	5.1.0.CR1
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/BRMS-468
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:	brms-standalone-5.1.0 ER4
Last Closed:	2010-12-07 18:11:20 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Petr Široký 2010-11-29 12:33:16 UTC

Affects Testing: Blocks Testing
securitylevel_name: Public

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)

Comment 1 Van Halbert 2010-12-03 15:03:17 UTC

Link: Added: This issue Cloned to BRMS-498

Comment 2 Randall Hauch 2010-12-03 22:34:23 UTC

MODE-1036 has been marked as resolved. Hopefully you will see this fixed in the next ER build.

Comment 3 Van Halbert 2010-12-06 14:16:21 UTC

Release Notes Text: Added: ModeShape has applied a fix to the 2.2.x product branch and should be in the next release

Comment 4 Petr Široký 2010-12-07 18:11:20 UTC

Verified fixed in BRMS 5.1.0 CR1