[ http://jira.codehaus.org/browse/CONTINUUM-1181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_88323 ]
Emmanuel Venisse commented on CONTINUUM-1181: --------------------------------------------- You can try to uncomment the following code in your application.xml (Note: it is in two places in application.xml) {code:xml} <property> <name>org.jpox.identifier.case</name> <value>PreserveCase</value> </property> {code} And remove your database before to restart continuum > Continuum aborts when running Postgres under JBoss > -------------------------------------------------- > > Key: CONTINUUM-1181 > URL: http://jira.codehaus.org/browse/CONTINUUM-1181 > Project: Continuum > Issue Type: Bug > Components: Database > Affects Versions: 1.1 > Environment: MS Windows XP Pro SP2 > postgres 8.1.4-1 with JDBC Driver postgresql-8.1-408.jdbc3 > JBoss 4.0.5.GA > Reporter: thierry lach > > 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. > 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) -- 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