6 Replies Latest reply on Nov 18, 2004 7:14 AM by beyarecords

    jboss 4.0 + postgresql 7.4.5

    Albert Fang Newbie

      When I start jboss 4.0, I got a long list of errors. Basically, I am trying to use postgresql for JMS and persistence. Here is a digest fo the errors message!

      MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
      ObjectName: jboss.mq:service=PersistenceManager
      state: FAILED
      I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

      Depends On Me: jboss.mq:service=DestinationManager
      java.lang.NullPointerException
      ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
      state: FAILED
      I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

      Depends On Me: org.postgresql.util.PSQLException: ERROR: type "other" does not exist

      I did the configuration changes just like I had done to Jboss 3.2.5. But not working for Jboss4.0. Can someone help me ?

        • 1. Re: jboss 4.0 + postgresql 7.4.5
          Phillip Lindsay Newbie

          I have yet to get postgres 7.4 up and running as default data source. Done all the right things...arrrg.
          -phil

          • 2. Here is stack trace. Re: jboss 4.0 + postgresql 7.4.5
            Phillip Lindsay Newbie

            It appears to be related to type column type mapping "other" via new EJB Timer service:
            10:06:39,575 ERROR [DatabasePersistencePolicy] Starting failed jboss.ejb:persistencePolicy=database,service=EJBTimerService
            org.postgresql.util.PSQLException: ERROR: type "other" does not exist

            at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259)
            at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229)
            at org.jboss.ejb.txtimer.DatabasePersistencePolicy.createTableIfNotExists(DatabasePersistencePolicy.java:403)
            at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:102)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
            at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:172)
            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:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:908)
            at $Proxy0.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:416)
            at org.jboss.system.ServiceController.start(ServiceController.java:438)
            at org.jboss.system.ServiceController.start(ServiceController.java:438)
            at org.jboss.system.ServiceController.start(ServiceController.java:438)
            at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy4.start(Unknown Source)
            at org.jboss.deployment.SARDeployer.start(SARDeployer.java:261)
            at org.jboss.deployment.MainDeployer.start(MainDeployer.java:935)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:746)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:709)
            at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:119)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy8.deploy(Unknown Source)
            at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:305)
            at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:481)
            at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)
            at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
            at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891)
            at $Proxy0.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:416)
            at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy4.start(Unknown Source)
            at org.jboss.deployment.SARDeployer.start(SARDeployer.java:261)
            at org.jboss.deployment.MainDeployer.start(MainDeployer.java:935)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:746)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:709)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:693)
            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:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:119)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy5.deploy(Unknown Source)
            at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:396)
            at org.jboss.system.server.ServerImpl.start(ServerImpl.java:293)
            at org.jboss.Main.boot(Main.java:151)
            at org.jboss.Main$1.run(Main.java:405)
            at java.lang.Thread.run(Thread.java:534)
            10:06:39,591 WARN [ServiceController] Problem starting service jboss.ejb:persistencePolicy=database,service=EJBTimerService
            org.postgresql.util.PSQLException: ERROR: type "other" does not exist

            at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:259)
            at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:229)
            at org.jboss.ejb.txtimer.DatabasePersistencePolicy.createTableIfNotExists(DatabasePersistencePolicy.java:403)
            at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:102)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
            at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:172)
            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:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:908)
            at $Proxy0.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:416)
            at org.jboss.system.ServiceController.start(ServiceController.java:438)
            at org.jboss.system.ServiceController.start(ServiceController.java:438)
            at org.jboss.system.ServiceController.start(ServiceController.java:438)
            at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy4.start(Unknown Source)
            at org.jboss.deployment.SARDeployer.start(SARDeployer.java:261)
            at org.jboss.deployment.MainDeployer.start(MainDeployer.java:935)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:746)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:709)
            at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:119)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy8.deploy(Unknown Source)
            at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:305)
            at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:481)
            at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:204)
            at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:277)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
            at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
            at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:891)
            at $Proxy0.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:416)
            at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy4.start(Unknown Source)
            at org.jboss.deployment.SARDeployer.start(SARDeployer.java:261)
            at org.jboss.deployment.MainDeployer.start(MainDeployer.java:935)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:746)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:709)
            at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:693)
            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:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:119)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:131)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
            at $Proxy5.deploy(Unknown Source)
            at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:396)
            at org.jboss.system.server.ServerImpl.start(ServerImpl.java:293)
            at org.jboss.Main.boot(Main.java:151)
            at org.jboss.Main$1.run(Main.java:405)
            at java.lang.Thread.run(Thread.java:534)
            10:06:41,466 INFO [MailService] Mail Service bound to java:/Mail
            10:06:42,012 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=file:/C:/destinydev/cots/jboss-4.0.0/server/default/deploy/jmx-console.war/
            10:06:43,919 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=file:/C:/destinydev/cots/jboss-4.0.0/server/default/deploy/management/web-console.war/
            10:06:44,919 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
            MBeans waiting for other MBeans:
            ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
            state: FAILED
            I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

            Depends On Me: org.postgresql.util.PSQLException: ERROR: type "other" does not exist

            ObjectName: jboss.mq.destination:name=testTopic,service=Topic
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=securedTopic,service=Topic
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=testDurableTopic,service=Topic
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=testQueue,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=A,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=B,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=C,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=D,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me:
            ObjectName: jboss.mq.destination:name=ex,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me:
            ObjectName: jboss.mq:service=Invoker
            state: CONFIGURED
            I Depend On: jboss.mq:service=TracingInterceptor

            Depends On Me: jboss.mq:service=InvocationLayer,type=JVM
            jboss.mq:service=InvocationLayer,type=UIL2

            ObjectName: jboss.mq:service=TracingInterceptor
            state: CONFIGURED
            I Depend On: jboss.mq:service=SecurityManager

            Depends On Me: jboss.mq:service=Invoker

            ObjectName: jboss.mq:service=SecurityManager
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager

            Depends On Me: jboss.mq.destination:name=testTopic,service=Topic
            jboss.mq.destination:name=securedTopic,service=Topic
            jboss.mq.destination:name=testDurableTopic,service=Topic
            jboss.mq.destination:name=testQueue,service=Queue
            jboss.mq:service=TracingInterceptor
            jboss.mq.destination:name=DLQ,service=Queue

            ObjectName: jboss.mq.destination:name=DLQ,service=Queue
            state: CONFIGURED
            I Depend On: jboss.mq:service=DestinationManager
            jboss.mq:service=SecurityManager

            Depends On Me:
            ObjectName: jboss.mq:service=InvocationLayer,type=JVM
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me:
            ObjectName: jboss.mq:service=DestinationManager
            state: CONFIGURED
            I Depend On: jboss.mq:service=MessageCache
            jboss.mq:service=PersistenceManager
            jboss.mq:service=StateManager

            Depends On Me: jboss.mq.destination:name=testTopic,service=Topic
            jboss.mq.destination:name=securedTopic,service=Topic
            jboss.mq.destination:name=testDurableTopic,service=Topic
            jboss.mq.destination:name=testQueue,service=Queue
            jboss.mq.destination:name=A,service=Queue
            jboss.mq.destination:name=B,service=Queue
            jboss.mq.destination:name=C,service=Queue
            jboss.mq.destination:name=D,service=Queue
            jboss.mq.destination:name=ex,service=Queue
            jboss.mq:service=SecurityManager
            jboss.mq.destination:name=DLQ,service=Queue

            ObjectName: jboss.mq:service=PersistenceManager
            state: CONFIGURED
            I Depend On: jboss.jca:name=PostgresDS,service=DataSourceBinding

            Depends On Me: jboss.mq:service=DestinationManager

            ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
            state: CONFIGURED
            I Depend On: jboss.mq:service=Invoker

            Depends On Me:

            MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
            ObjectName: jboss.jca:name=PostgresDS,service=DataSourceBinding
            state: NOTYETINSTALLED
            I Depend On:
            Depends On Me: jboss.mq:service=PersistenceManager

            ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
            state: FAILED
            I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

            Depends On Me: org.postgresql.util.PSQLException: ERROR: type "other" does not exist

            • 4. Re: jboss 4.0 + postgresql 7.4.5
              Jeff Pierce Newbie

              I have setup JBoss to use PostgreSQL 8.0.0-beta4 on Windows as the default data source. EBJs and JMS seem to be working fine. However, on subsequent JBoss startups, the EJBTimerService throws an exception as shown below. I read the above bug report but I don't know what DatabasePersistencePolicy.createTableIfNotExists means. I am using JBoss 4.0.0. Is there more config I need to change? Thanks.

              ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
              state: FAILED
              I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

              Depends On Me: java.sql.SQLException: ERROR: relation "timers" already exists

              MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
              ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
              state: FAILED
              I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

              Depends On Me: java.sql.SQLException: ERROR: relation "timers" already exists

              • 5. Re: jboss 4.0 + postgresql 7.4.5
                osesm Newbie

                 

                "pierce7648" wrote:
                I have setup JBoss to use PostgreSQL 8.0.0-beta4 on Windows as the default data source. EBJs and JMS seem to be working fine. However, on subsequent JBoss startups, the EJBTimerService throws an exception as shown below. I read the above bug report but I don't know what DatabasePersistencePolicy.createTableIfNotExists means. I am using JBoss 4.0.0. Is there more config I need to change? Thanks.

                ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
                state: FAILED
                I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

                Depends On Me: java.sql.SQLException: ERROR: relation "timers" already exists

                MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
                ObjectName: jboss.ejb:persistencePolicy=database,service=EJBTimerService
                state: FAILED
                I Depend On: jboss.jca:name=DefaultDS,service=DataSourceBinding

                Depends On Me: java.sql.SQLException: ERROR: relation "timers" already exists


                From what I can tell, you may just have to deal with this for the time being.

                I want to keep postgresql as my db, but seeing as how I am not making any headway with 4.0 and pg 7.4.5, I may just move to mysql temporarily.

                • 6. Re: jboss 4.0 + postgresql 7.4.5
                  beyarecords Novice

                  Hi,
                  I am using postgreSQL 8 and Jboss 4.0.0 and struggled with the problem you mentioned. The problem stems from the file /deploy/ejb-deployer.xml:

                   <attribute name="CreateTableDDL">
                   create table TIMERS (
                   TIMERID varchar(50) not null,
                   TARGETID varchar(50) not null,
                   INITIALDATE timestamp not null,
                   INTERVAL bigint,
                   INSTANCEPK other,
                   INFO other,
                   constraint timers_pk primary key (TIMERID)
                   )
                   </attribute>
                  


                  The column type other is not supported in postgreSQL and needs to be replaced by the column type oid. As for the error message telling you that the table timers already exits (workround):

                  1. Use pgsql to determine the existence of the timers table. If it exists do nothing!

                  2. If pgsql is not your cup of tea, run Jboss once so that the times table is created, go into ejb-deployer.xml and comment out the create table code , so that the error is not generated if you should need to re-start Jboss.

                  Hope this helps

                  regards


                  Andrew