0 Replies Latest reply on Dec 1, 2011 2:07 AM by free

    Configuring Guvnor to use PostgreSQL

    free

      With reference to http://docs.jboss.org/drools/release/5.2.0.Final/drools-guvnor-docs/html/chap-database_configuration.html,

      I use the Repository Configuration Manager in Guvnor to connect PostgreSQL(replaced the repository.xml and deleted repository directory),

      and when I opened http://localhost:8080/drools-guvnor/org.drools.guvnor.Guvnor/Guvnor.html,creating 11 tables and 2 index in PostgreSQL Database,but then,the webside ouccer 404 error,I can't open guvnor.

       

      I noticed the repository directory was created when I start jboss,and there was only workspaces/default/workspace.xml in  repository directory.

       

      And when I change the repository.xml for postgresql to repository.xml for the default file database,I can success to visit the http://localhost:8080/drools-guvnor/org.drools.guvnor.Guvnor/Guvnor.html.

      So,why it success to start jboss when using the default file database,but postgresql failsured.

       

      I use Drools 5.2.0.Final and jboss-5.1.0.GA and jbossws-native-3.4.1.GA.

       

      error infomation:

       

      2011-11-30 17:19:49,824 INFO  [org.jboss.web.WebService] (main) Using RMI server codebase: http://localhost:8083/

      2011-11-30 17:19:58,801 WARN  [org.jboss.detailed.classloader.ClassLoaderManager] (main) Unexpected error during load of:org.jboss.wsf.stack.jbws.JAXBIntroDeploymentAspect

      java.lang.IncompatibleClassChangeError: class org.jboss.wsf.stack.jbws.JAXBIntroDeploymentAspect has interface org.jboss.wsf.spi.deployment.DeploymentAspect as super class

                at java.lang.ClassLoader.defineClass1(Native Method)

                at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632)

                at java.lang.ClassLoader.defineClass(ClassLoader.java:616)

                at org.jboss.classloader.spi.base.BaseClassLoader.access$200(BaseClassLoader.java:63)

                at org.jboss.classloader.spi.base.BaseClassLoader$2.run(BaseClassLoader.java:572)

                at org.jboss.classloader.spi.base.BaseClassLoader$2.run(BaseClassLoader.java:532)

                at java.security.AccessController.doPrivileged(Native Method)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClassLocally(BaseClassLoader.java:530)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClassLocally(BaseClassLoader.java:507)

                at org.jboss.classloader.spi.base.BaseDelegateLoader.loadClass(BaseDelegateLoader.java:134)

                at org.jboss.classloader.spi.filter.FilteredDelegateLoader.loadClass(FilteredDelegateLoader.java:131)

                at org.jboss.classloader.spi.base.ClassLoadingTask$ThreadTask.run(ClassLoadingTask.java:452)

                at org.jboss.classloader.spi.base.ClassLoaderManager.nextTask(ClassLoaderManager.java:251)

                at org.jboss.classloader.spi.base.ClassLoaderManager.process(ClassLoaderManager.java:150)

                at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:265)

                at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:1119)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClassFromDomain(BaseClassLoader.java:798)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:441)

                at java.lang.ClassLoader.loadClass(ClassLoader.java:248)

                at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataFactoryVisitor.addBeanComponent(BeanMetaDataFactoryVisitor.java:63)

                at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataFactoryVisitor.deploy(BeanMetaDataFactoryVisitor.java:126)

                at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployerWithInput.deploy(AbstractRealDeployerWithInput.java:125)

                at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployerWithInput.internalDeploy(AbstractRealDeployerWithInput.java:102)

                at org.jboss.deployers.spi.deployer.helpers.AbstractComponentDeployer.internalDeploy(AbstractComponentDeployer.java:78)

                at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)

                at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)

                at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)

                at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)

                at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)

                at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)

                at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)

                at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)

                at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

                at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)

                at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)

                at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)

                at org.jboss.Main.boot(Main.java:221)

                at org.jboss.Main$1.run(Main.java:556)

                at java.lang.Thread.run(Thread.java:662)

      2011-11-30 17:19:58,894 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/D:/work/JBPM/workplatform/platform2/jbpm-installer/jboss-5.1.0.GA/server/default/deployers/jbossws.deployer/ state=PreReal mode=Manual requiredState=Real

      org.jboss.deployers.spi.DeploymentException: Error deploying: vfsfile:/D:/work/JBPM/workplatform/platform2/jbpm-installer/jboss-5.1.0.GA/server/default/deployers/jbossws.deployer/

                at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)

                at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataFactoryVisitor.deploy(BeanMetaDataFactoryVisitor.java:136)

                at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployerWithInput.deploy(AbstractRealDeployerWithInput.java:125)

                at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployerWithInput.internalDeploy(AbstractRealDeployerWithInput.java:102)

                at org.jboss.deployers.spi.deployer.helpers.AbstractComponentDeployer.internalDeploy(AbstractComponentDeployer.java:78)

                at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)

                at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)

                at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

                at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)

                at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)

                at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)

                at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)

                at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)

                at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)

                at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)

                at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)

                at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)

                at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)

                at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)

                at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)

                at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)

                at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)

                at org.jboss.Main.boot(Main.java:221)

                at org.jboss.Main$1.run(Main.java:556)

                at java.lang.Thread.run(Thread.java:662)

      Caused by: java.lang.IllegalArgumentException: Exception loading class for ScopeKey addition.

                at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataFactoryVisitor.addBeanComponent(BeanMetaDataFactoryVisitor.java:67)

                at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataFactoryVisitor.deploy(BeanMetaDataFactoryVisitor.java:126)

                ... 34 more

      Caused by: java.lang.ClassNotFoundException: Unexpected error during load of: org.jboss.wsf.stack.jbws.JAXBIntroDeploymentAspect, msg=class org.jboss.wsf.stack.jbws.JAXBIntroDeploymentAspect has interface org.jboss.wsf.spi.deployment.DeploymentAspect as super class

                at org.jboss.classloader.spi.base.ClassLoaderManager.process(ClassLoaderManager.java:165)

                at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:265)

                at org.jboss.classloader.spi.base.BaseClassLoaderDomain.loadClass(BaseClassLoaderDomain.java:1119)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClassFromDomain(BaseClassLoader.java:798)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:441)

                at java.lang.ClassLoader.loadClass(ClassLoader.java:248)

                at org.jboss.deployers.vfs.deployer.kernel.BeanMetaDataFactoryVisitor.addBeanComponent(BeanMetaDataFactoryVisitor.java:63)

                ... 35 more

      Caused by: java.lang.IncompatibleClassChangeError: class org.jboss.wsf.stack.jbws.JAXBIntroDeploymentAspect has interface org.jboss.wsf.spi.deployment.DeploymentAspect as super class

                at java.lang.ClassLoader.defineClass1(Native Method)

                at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632)

                at java.lang.ClassLoader.defineClass(ClassLoader.java:616)

                at org.jboss.classloader.spi.base.BaseClassLoader.access$200(BaseClassLoader.java:63)

                at org.jboss.classloader.spi.base.BaseClassLoader$2.run(BaseClassLoader.java:572)

                at org.jboss.classloader.spi.base.BaseClassLoader$2.run(BaseClassLoader.java:532)

                at java.security.AccessController.doPrivileged(Native Method)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClassLocally(BaseClassLoader.java:530)

                at org.jboss.classloader.spi.base.BaseClassLoader.loadClassLocally(BaseClassLoader.java:507)

                at org.jboss.classloader.spi.base.BaseDelegateLoader.loadClass(BaseDelegateLoader.java:134)

                at org.jboss.classloader.spi.filter.FilteredDelegateLoader.loadClass(FilteredDelegateLoader.java:131)

                at org.jboss.classloader.spi.base.ClassLoadingTask$ThreadTask.run(ClassLoadingTask.java:452)

                at org.jboss.classloader.spi.base.ClassLoaderManager.nextTask(ClassLoaderManager.java:251)

                at org.jboss.classloader.spi.base.ClassLoaderManager.process(ClassLoaderManager.java:150)

                ... 41 more