Return-Path: Delivered-To: apmail-continuum-issues-archive@www.apache.org Received: (qmail 15068 invoked from network); 11 Jul 2008 00:56:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jul 2008 00:56:56 -0000 Received: (qmail 42661 invoked by uid 500); 11 Jul 2008 00:56:56 -0000 Delivered-To: apmail-continuum-issues-archive@continuum.apache.org Received: (qmail 42648 invoked by uid 500); 11 Jul 2008 00:56:56 -0000 Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@continuum.apache.org Delivered-To: mailing list issues@continuum.apache.org Received: (qmail 42637 invoked by uid 99); 11 Jul 2008 00:56:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Jul 2008 17:56:56 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.246.2.115] (HELO codehaus01.managed.contegix.com) (63.246.2.115) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 11 Jul 2008 00:56:04 +0000 Received: from codehaus01.managed.contegix.com (localhost.localdomain [127.0.0.1]) by codehaus01.managed.contegix.com (Postfix) with ESMTP id DEB5E14A8048 for ; Thu, 10 Jul 2008 19:56:26 -0500 (CDT) Message-ID: <26887446.1215737786835.JavaMail.haus-jira@codehaus01.managed.contegix.com> Date: Thu, 10 Jul 2008 19:56:26 -0500 (CDT) From: "Carlos Sanchez (JIRA)" To: issues@continuum.apache.org Subject: [jira] Created: (CONTINUUM-1820) Error using Atomikos datasource and Postgres MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Error using Atomikos datasource and Postgres -------------------------------------------- Key: CONTINUUM-1820 URL: http://jira.codehaus.org/browse/CONTINUUM-1820 Project: Continuum Issue Type: Bug Components: Database Affects Versions: 1.1, 1.2 Environment: Postgres 8.3 Java 1.6.0_06 Atomikos 3.2.3 Reporter: Carlos Sanchez Attachments: atomikos-error.patch Getting the error "Cannot change transaction isolation level in the middle of a transaction." See attached patch for a configuration that will make continuum store test fail using atomikos and postgres 8.3 javax.jdo.JDODataStoreException: Error while obtaining connection for POID generation : Cannot change transaction isolation level in the middle of a transaction. at org.jpox.store.rdbms.RDBMSManager$2.retrieveConnection(RDBMSManager.java:1586) at org.jpox.store.rdbms.poid.AbstractRDBMSPoidGenerator.obtainPoidBlock(AbstractRDBMSPoidGenerator.java:80) at org.jpox.store.poid.AbstractPoidGenerator.obtainPoidBlock(AbstractPoidGenerator.java:187) at org.jpox.store.poid.AbstractPoidGenerator.next(AbstractPoidGenerator.java:95) at org.jpox.store.rdbms.RDBMSManager.getStrategyValue(RDBMSManager.java:1634) at org.jpox.state.StateManagerImpl.populateStrategyFields(StateManagerImpl.java:812) at org.jpox.state.StateManagerImpl.(StateManagerImpl.java:582) at org.jpox.state.StateManagerFactory.newStateManager(StateManagerFactory.java:105) at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1205) at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1259) at org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1231) at org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:772) at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:387) at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:209) at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:464) at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519) at org.jpox.store.StoreManager.insert(StoreManager.java:938) at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3667) at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3646) at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1206) at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1277) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:97) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:78) at org.apache.maven.continuum.store.JdoContinuumStore.addObject(JdoContinuumStore.java:1931) at org.apache.maven.continuum.store.JdoContinuumStore.addObject(JdoContinuumStore.java:1926) at org.apache.maven.continuum.store.JdoContinuumStore.addProjectGroup(JdoContinuumStore.java:1921) at org.apache.maven.continuum.store.AbstractContinuumStoreTestCase.createBuildDatabase(AbstractContinuumStoreTestCase.java:397) at org.apache.maven.continuum.store.AbstractContinuumStoreTestCase.createBuildDatabase(AbstractContinuumStoreTestCase.java:126) at org.apache.maven.continuum.store.ContinuumStoreTest.setUp(ContinuumStoreTest.java:1159) at junit.framework.TestCase.runBare(TestCase.java:125) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) NestedThrowablesStackTrace: org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction. at org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:762) 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 com.atomikos.jdbc.nonxa.ThreadLocalConnection.invoke(Unknown Source) at $Proxy0.setTransactionIsolation(Unknown Source) at org.jpox.store.rdbms.adapter.DatabaseAdapter.getConnection(DatabaseAdapter.java:974) at org.jpox.store.rdbms.RDBMSManager.getConnection(RDBMSManager.java:458) at org.jpox.store.rdbms.RDBMSManager$2.retrieveConnection(RDBMSManager.java:1579) at org.jpox.store.rdbms.poid.AbstractRDBMSPoidGenerator.obtainPoidBlock(AbstractRDBMSPoidGenerator.java:80) at org.jpox.store.poid.AbstractPoidGenerator.obtainPoidBlock(AbstractPoidGenerator.java:187) at org.jpox.store.poid.AbstractPoidGenerator.next(AbstractPoidGenerator.java:95) at org.jpox.store.rdbms.RDBMSManager.getStrategyValue(RDBMSManager.java:1634) at org.jpox.state.StateManagerImpl.populateStrategyFields(StateManagerImpl.java:812) at org.jpox.state.StateManagerImpl.(StateManagerImpl.java:582) at org.jpox.state.StateManagerFactory.newStateManager(StateManagerFactory.java:105) at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1205) at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1259) at org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1231) at org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:772) at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:387) at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:209) at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:464) at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2519) at org.jpox.store.StoreManager.insert(StoreManager.java:938) at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3667) at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3646) at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1206) at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1277) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:97) at org.codehaus.plexus.jdo.PlexusJdoUtils.addObject(PlexusJdoUtils.java:78) at org.apache.maven.continuum.store.JdoContinuumStore.addObject(JdoContinuumStore.java:1931) at org.apache.maven.continuum.store.JdoContinuumStore.addObject(JdoContinuumStore.java:1926) at org.apache.maven.continuum.store.JdoContinuumStore.addProjectGroup(JdoContinuumStore.java:1921) at org.apache.maven.continuum.store.AbstractContinuumStoreTestCase.createBuildDatabase(AbstractContinuumStoreTestCase.java:397) at org.apache.maven.continuum.store.AbstractContinuumStoreTestCase.createBuildDatabase(AbstractContinuumStoreTestCase.java:126) at org.apache.maven.continuum.store.ContinuumStoreTest.setUp(ContinuumStoreTest.java:1159) at junit.framework.TestCase.runBare(TestCase.java:125) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira