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

    jboss 4.0 + postgresql 7.4.5

    albertfang
    albertfang Oct 3, 2004 3:59 AM

      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 ?

      • 4528 Views
      • Tags:
        • 1. Re: jboss 4.0 + postgresql 7.4.5
          plindsay
          plindsay Oct 12, 2004 9:45 PM (in response to albertfang)

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

            • Actions
          • 2. Here is stack trace. Re: jboss 4.0 + postgresql 7.4.5
            plindsay
            plindsay Oct 13, 2004 1:08 PM (in response to albertfang)

            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

              • Actions
            • 3. Re: jboss 4.0 + postgresql 7.4.5
              plindsay
              plindsay Oct 14, 2004 1:27 AM (in response to albertfang)

              The issue was logged:
              http://sourceforge.net/tracker/index.php?func=detail&aid=1029232&group_id=22866&atid=376685

                • Actions
              • 4. Re: jboss 4.0 + postgresql 7.4.5
                pierce7648
                pierce7648 Nov 12, 2004 2:44 PM (in response to albertfang)

                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

                  • Actions
                • 5. Re: jboss 4.0 + postgresql 7.4.5
                  osesm
                  osesm Nov 17, 2004 3:28 PM (in response to albertfang)

                   

                  "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.

                    • Actions
                  • 6. Re: jboss 4.0 + postgresql 7.4.5
                    beyarecords
                    beyarecords Nov 18, 2004 7:14 AM (in response to albertfang)

                    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

                      • Actions