13 Replies Latest reply on Oct 26, 2006 5:22 AM by ovidiu.feodorov

    Changing defaultDS to postgres: NoSuchMethodException

    chuckanut

      I am trying to change the DefaultDS to postgres by following the wiki doc. I have copied the example files into the correct locations. I am using Jboss4.0.3SP1 and Postgres 8.0.3.

      When I start up JBoss, I can see that the DefaultDS gets created because the tables hilosequences and timers are created. Also, It shows up in the jmx-console as started and bound to DefaultDS. The problem is with the JDBCPersistence manager. I get the following error. Any ideas?

      17:18:27,641 ERROR [MainDeployer] Could not create deployment: file:/C:/sift-root/eclipse-workspace/sift2/jbos
      s/jboss-4.0.3SP1/server/messaging/deploy/jboss-messaging.sar/postgresql-persistence-service.xml
      org.jboss.deployment.DeploymentException: org.jboss.messaging.core.plugin.JDBCPersistenceManager.<init>(); - n
      ested throwable: (java.lang.NoSuchMethodException: org.jboss.messaging.core.plugin.JDBCPersistenceManager.<ini
      t>())
      


        • 1. Re: Changing defaultDS to postgres: NoSuchMethodException
          chuckanut

          I tried using a more recent version of Jboss AS (4.0.5.GA) to see if that was the problem, but I am getting the same error. I am using the posgres service file from the examples directory and a -ds.xml file created by the installer tool which looks correct. I pasted some more context from the stack trace below.

          10:04:36,922 ERROR [MainDeployer] Could not create deployment: file:/C:/jbos
          s/jboss-4.0.5.GA/server/messaging/deploy/jboss-messaging.sar/postgresql-persistence-service.xml
          org.jboss.deployment.DeploymentException: org.jboss.messaging.core.plugin.JDBCPersistenceManager.<init>(); - n
          ested throwable: (java.lang.NoSuchMethodException: org.jboss.messaging.core.plugin.JDBCPersistenceManager.<ini
          t>())
           at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:196)
           at org.jboss.system.ServiceController.install(ServiceController.java:226)
           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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
           at $Proxy4.install(Unknown Source)
           at org.jboss.deployment.SARDeployer.create(SARDeployer.java:249)
           at org.jboss.deployment.MainDeployer.create(MainDeployer.java:969)
           at org.jboss.deployment.MainDeployer.create(MainDeployer.java:959)
           at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:818)
           at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
           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.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 $Proxy6.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(AbstractDeploymentScann
          er.java:263)
           at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:
          336)
           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)
          


          • 2. Re: Changing defaultDS to postgres: NoSuchMethodException
            chuckanut

            This problem doesn't seem to occur with mysql. I installed a mysql db and used the example config files and the server is running fine. I wonder if there is a problem with the postgres example config file?

            • 3. Re: Changing defaultDS to postgres: NoSuchMethodException
              ovidiu.feodorov

              What Messaging version are you using?

              • 4. Re: Changing defaultDS to postgres: NoSuchMethodException
                ctomc

                I have exact same error but when using DB2 as database (I modified oracle-persistence-service.xml to make it work with db2)

                it was working ok on jboss 4.0.3SP1 with messaging 1.0.1GA
                but when I upgraded to 1.2alpha1 i get this exception...

                I tried to use 1.2alpha because I had problems running 1.0.1 on jboss 4.0.5GA


                cheers,
                Tomaz

                • 5. Re: Changing defaultDS to postgres: NoSuchMethodException
                  timfox

                  If you're using 1.2alpha, then the only config that is currently up to date and working is the config for mysql.

                  It is a fairly simple (but fairly time consuming) task to get them working and this is going to be done by the beta release.

                  If anyone wants to volunteer then please be guest :)

                  Basically all you need to do is start with the working mysql config and change the dml/dll as necessary to match your specific database.

                  BTW please remember 1.2 is currently in alpha so you use at your own risk!

                  • 6. Re: Changing defaultDS to postgres: NoSuchMethodException
                    weston.price

                    I have been doing quite a bit of testing for the JCA adapter. It was my plan to go through and update the jdbc support files being that I test on multiple DB hosts.

                    • 7. Re: Changing defaultDS to postgres: NoSuchMethodException
                      timfox

                       

                      "weston.price@jboss.com" wrote:
                      I have been doing quite a bit of testing for the JCA adapter. It was my plan to go through and update the jdbc support files being that I test on multiple DB hosts.


                      Weston, that would be a great help, thx :)

                      • 8. Re: Changing defaultDS to postgres: NoSuchMethodException
                        ovidiu.feodorov

                         

                        ctomc wrote:
                        I tried to use 1.2alpha because I had problems running 1.0.1 on jboss 4.0.5GA



                        Hindrances while using 1.2.Alpha are somewhat to be expected.

                        It's the last part of your statement that I am worried about. Can you please provide more details so we can understand what kind of "problems" you experienced and possibly help you getting 1.0.1 running?


                        Thanks!


                        • 9. Re: Changing defaultDS to postgres: NoSuchMethodException
                          ctomc

                          Hello Ovidiu,

                          I have managed to get 1.0.1 running. I had EJB 3 configuration broken, and that effected some other services too.

                          I reinstalled jboss 4.0.5GA from scratch and then installed messaging 1.0.1 and it worked fine.

                          btw, I have messaging running on DB2, if anyone needs configuration file for presister I can upload it here.


                          cheers,
                          Tomaz

                          • 10. Re: Changing defaultDS to postgres: NoSuchMethodException
                            ovidiu.feodorov

                            Of course, your contribution is welcome. Please attach it to this thread. We can even ship it with the release, in the examples section, but for that you need to go through the ordeal of the click-through individual Contributor Agreement :)

                            • 11. Re: Changing defaultDS to postgres: NoSuchMethodException
                              chuckanut

                               


                              If you're using 1.2alpha, then the only config that is currently up to date and working is the config for mysql.


                              Yes, i'm using 1.2Alpha1. Thanks for the response.

                              • 12. Re: Changing defaultDS to postgres: NoSuchMethodException
                                ctomc

                                Ovidiu,

                                I have attached file for presistence on db2 in issue:
                                http://jira.jboss.com/jira/browse/JBMESSAGING-624
                                because to make it fully work there must be a small change in code.


                                cheers,
                                toma?

                                • 13. Re: Changing defaultDS to postgres: NoSuchMethodException
                                  ovidiu.feodorov

                                  Thanks, I have scheduled it for 1.0.2.CR1. Let's see when we can get that out.