[ http://jira.codehaus.org/browse/CONTINUUM-1181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_97410 ]
Andy Jefferson commented on CONTINUUM-1181: ------------------------------------------- Postgresql supports IIRC lowercase, and mixed case quoted identifiers. The default used by JPOX will be mixed case quoted, but you can easily set that property to "LowerCase". No idea what that has to do with this issue since no JPOX info is provided ... like log entries, exception, stack trace > 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-alpha-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 > Fix For: 1.1-alpha-2 > > > 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