I'm trying to get Continuum to store its data in a postgres database while running under JBoss and I'm getting an exception. It seems that someone is trying to change the transaction isolation during a transaction.
I'm running postgres 8.1.4-1 on MS Windows (and am using the driver jar postgresql-8.1-408.jdbc3). Any ideas? Excerpt from JBoss logs follows... 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - Starting Continuum. 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - < Continuum 1.1-SNAPSHOT started! > 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - ----------------------------------- 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - \ ^__^ 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - \ (oo)\_______ 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - (__)\ )\/\ 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - ||----w | 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - || || 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - 2007-02-21 12:56:02,613 [ScannerThread] INFO Continuum - 2007-02-21 12:56:02,613 [ScannerThread] INFO ContinuumInitializer:default - Continuum initializer running ... 2007-02-21 12:56:02,644 [ScannerThread] WARN LocalManagedConnectionFactory - Error resetting transaction isolation org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction. at org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation( AbstractJdbc2Connection.java:733) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.cleanup( BaseWrapperManagedConnection.java:189) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection (InternalManagedConnectionPool.java:320) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.returnConnection (JBossManagedConnectionPool.java:620) at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection (BaseConnectionManager2.java:363) at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed (TxConnectionManager.java:623) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle( BaseWrapperManagedConnection.java:266) at org.jboss.resource.adapter.jdbc.WrappedConnection.close( WrappedConnection.java:129) at org.jpox.store.rdbms.adapter.DatabaseAdapter.getConnection( DatabaseAdapter.java:928) at org.jpox.store.rdbms.RDBMSNonmanagedTransaction.begin( RDBMSNonmanagedTransaction.java:324) at org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached( PlexusJdoUtils.java:356) at org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached( PlexusJdoUtils.java:346) at org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached( JdoContinuumStore.java:1302) at org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached( JdoContinuumStore.java:1287) at org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached( JdoContinuumStore.java:1282) at org.apache.maven.continuum.store.JdoContinuumStore.getAllObjectsDetached( JdoContinuumStore.java:1277) at org.apache.maven.continuum.store.JdoContinuumStore.getSystemConfiguration( JdoContinuumStore.java:1375) at org.apache.maven.continuum.initialization.DefaultContinuumInitializer.initialize (DefaultContinuumInitializer.java:90) at org.apache.maven.continuum.DefaultContinuum.start( DefaultContinuum.java:2281) at org.codehaus.plexus.personality.plexus.lifecycle.phase.StartPhase.execute( StartPhase.java:33) at org.codehaus.plexus.lifecycle.AbstractLifecycleHandler.start( AbstractLifecycleHandler.java:130) at org.codehaus.plexus.component.manager.AbstractComponentManager.startComponentLifecycle (AbstractComponentManager.java:143) at org.codehaus.plexus.component.manager.AbstractComponentManager.createComponentInstance (AbstractComponentManager.java:133) at org.codehaus.plexus.component.manager.ClassicSingletonComponentManager.getComponent (ClassicSingletonComponentManager.java:87) at org.codehaus.plexus.DefaultComponentLookupManager.lookup( DefaultComponentLookupManager.java:101) at org.codehaus.plexus.DefaultPlexusContainer.lookup( DefaultPlexusContainer.java:313) at org.codehaus.plexus.DefaultPlexusContainer.lookup( DefaultPlexusContainer.java:291) at org.codehaus.plexus.container.initialization.StartLoadOnStartComponentsPhase.execute (StartLoadOnStartComponentsPhase.java:54) at org.codehaus.plexus.DefaultPlexusContainer.initializePhases( DefaultPlexusContainer.java:928) at org.codehaus.plexus.DefaultPlexusContainer.initialize( DefaultPlexusContainer.java:876) at org.codehaus.plexus.DefaultPlexusContainer.construct( DefaultPlexusContainer.java:853) at org.codehaus.plexus.DefaultPlexusContainer.<init>( DefaultPlexusContainer.java:222) at org.codehaus.plexus.DefaultPlexusContainer.<init>( DefaultPlexusContainer.java:236) at org.codehaus.plexus.xwork.PlexusLifecycleListener.contextInitialized( PlexusLifecycleListener.java:76) at org.apache.catalina.core.StandardContext.listenerStart( StandardContext.java:3763) at org.apache.catalina.core.StandardContext.start(StandardContext.java :4211) at org.apache.catalina.core.ContainerBase.addChildInternal( ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java :739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) 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:585) at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java :503) at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java :164) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.apache.catalina.core.StandardContext.init(StandardContext.java :5052) 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:585) at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java :503) at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java :164) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal( TomcatDeployer.java:297) at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy( TomcatDeployer.java:103) at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:371) at org.jboss.web.WebModule.startModule(WebModule.java:83) at org.jboss.web.WebModule.startService(WebModule.java:61) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart( ServiceMBeanSupport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle( ServiceMBeanSupport.java:245) 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:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke( ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke( AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.system.ServiceController$ServiceProxy.invoke( ServiceController.java:978) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:417) at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke( ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke( AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy38.start(Unknown Source) at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java :466) 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:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke( ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke( AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke( ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.interceptor.DynamicInterceptor.invoke( DynamicInterceptor.java:97) at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext( InterceptorServiceMBeanSupport.java:238) at org.jboss.ws.integration.jboss.DeployerInterceptor.start( DeployerInterceptor.java:92) at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start( SubDeployerInterceptorSupport.java:188) at org.jboss.deployment.SubDeployerInterceptor.invoke( SubDeployerInterceptor.java:95) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke( AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy39.start(Unknown Source) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782) at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke( ReflectedDispatcher.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke( AbstractInterceptor.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke( ModelMBeanOperationInterceptor.java:142) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.server.AbstractMBeanInvoker.invoke( AbstractMBeanInvoker.java:264) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210) at $Proxy8.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy( URLDeploymentScanner.java:421) at org.jboss.deployment.scanner.URLDeploymentScanner.scan( URLDeploymentScanner.java:634) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan( AbstractDeploymentScanner.java:263) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop( AbstractDeploymentScanner.java:274) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run( AbstractDeploymentScanner.java:225)
