Postgres 9.6的jBPM 7.3.0持久性

本文介绍了Postgres 9.6的jBPM 7.3.0持久性的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试使用 Postgres 9.6在 jbpm-installer-7.3.0.Final 中设置持久性.

I'm trying to set the persistence in jbpm-installer-7.3.0.Final with Postgres 9.6.

经过多次尝试后，我可以正常启动服务器和控制台，但是从工作台界面中，我无法使用进程"或任务".

After MANY attempts, I am able to start the server and the console without errors, but from the workbench interface, I'm unable to use Processes or Tasks.

它显示一个弹出窗口:

无法加载过程定义.检查是否启用了jBPM功能，以及是否正确设置了远程服务器.

Process Definitions could not be loaded. Check if the jBPM Capabilities are enabled and if the remote server is correctly set up.

在Wildfly部署控制台中，我可以看到:

in the Wildfly deployment console I can see:

[org.jbpm.workbench.ks.integration.KieServerDataSetManager] (kieserver)无法在服务器default-kieserver @ localhost:8080上注册查询，这很可能是由于缺少BPM功能(详细信息服务器该客户端所连接的服务器没有能力处理QueryServicesClient)

[org.jbpm.workbench.ks.integration.KieServerDataSetManager] (kieserver) Not possible to register queries on server default-kieserver@localhost:8080 most likely due to BPM capability missing (details Server that this client is connected to has no capabilities to handle QueryServicesClient)

即使来自Kie服务器的响应似乎允许所有操作(与H2相同，也可以正常工作)

even if the response from the Kie server, seems to allow everything (it's the same as for H2, that works fine)

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <response type="SUCCESS" msg="Kie Server info"> <kie-server-info> <capabilities>KieServer</capabilities> <capabilities>BRM</capabilities> <capabilities>BPM</capabilities> <capabilities>CaseMgmt</capabilities> <capabilities>BPM-UI</capabilities> <capabilities>BRP</capabilities> <capabilities>DMN</capabilities> <capabilities>BPMQueries</capabilities> <location>localhost:8080/kie-server/services/rest/server</location> <messages> <content>Server KieServerInfo{serverId='default-kieserver', version='7.3.0.Final', location='localhost:8080/kie-server/services/rest/server', capabilities=[KieServer, BRM, BPM, CaseMgmt, BPM-UI, BRP, DMN, BPMQueries]}started successfully at Mon Oct 02 17:45:00 CEST 2017</content> <severity>INFO</severity> <timestamp>2017-10-02T17:45:00.138+02:00</timestamp> </messages> <name>default-kieserver</name> <id>default-kieserver</id> <version>7.3.0.Final</version> </kie-server-info> </response>

以下是我设置Postgres的步骤

我假设前面的所有步骤都已完成，您为H2 Demo设置所做的步骤

I'm assuming all the previous steps are done, the ones you do for the H2 Demo setup

• 设置wildfly-10.1.0.Final \ modules \ org \ postgresql \ main \ module.xml

• SET wildfly-10.1.0.Final\modules\org\postgresql\main\module.xml

<resource-root path="postgresql-42.1.4.jar"/>

(JAR位于同一目录中-这是Postgres 9.6 JDBC 4 JDK 8的驱动程序)

(The JAR is in the same directory - this is the driver for Postgres 9.6 JDBC 4 JDK 8)

更改standalone-full.xml

Change standalone-full.xml

<datasources> <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"> <connection-url>jdbc:postgresql:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url> <driver>postgresql</driver> <security> <user-name>jbpm</user-name> <password>jbpm</password> </security> </datasource> <datasource jta="true" jndi-name="java:jboss/datasources/jbpmDS" pool-name="PostgresqlDS" enabled="true" use-java-context="true" use-ccm="true"> <connection-url>jdbc:postgresql://localhost:5432/jbpm</connection-url> <driver>postgresql</driver> <security> <user-name>jbpm</user-name> <password>jbpm</password> </security> </datasource> <drivers> <driver name="postgresql" module="org.postgresql"> <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class> </driver> </drivers> </datasources>

我在具有jbpm模式和用户的jbpm数据库上运行了ddl脚本

I ran the ddl scripts on a jbpm database, with jbpm schema and user

psql -h localhost -f postgresql-jbpm-schema.sql jbpm jbpm

psql -h localhost -f postgresql-jbpm-schema.sql jbpm jbpm

psql -h localhost -f postgresql-jbpm-lo-trigger-clob.sql jbpm jbpm

psql -h localhost -f postgresql-jbpm-lo-trigger-clob.sql jbpm jbpm

• 我想避免使用 ant 来启动服务器，所以我复制了 Wildfly 10.1.0 启动字符串

  • I wanted to avoid ant to start the server, so I replicated the Wildfly 10.1.0 launch string

    (首先，我设置一个 JAVA_OPTS 变量，以提高最大Java堆大小: -Xms512m -Xmx2G )

    (first, I set a JAVA_OPTS var, to raise the max java heap size: -Xms512m -Xmx2G)

    wildfly-10.1.0.Final \ bin \ standalone.bat -b localhost --server-config = standalone-full.xml -Dorg.kie.demo = false -Dorg.kie.example = false -Dorg.kie .server.id = default-kieserver -Dorg.kie.server.persistence.ds = java:jboss/datasources/jbpmDS -Dorg.kie.server.controller = localhost:8080/jbpm-console/rest/controller -Dorg.kie.server.location = 本地主机:8080/kie-server/services/rest/server -Dorg.kie.server.persistence .dialect = org.hibernate.dialect.PostgreSQL94Dialect

    wildfly-10.1.0.Final\bin\standalone.bat -b localhost --server-config=standalone-full.xml -Dorg.kie.demo=false -Dorg.kie.example=false -Dorg.kie.server.id=default-kieserver -Dorg.kie.server.persistence.ds=java:jboss/datasources/jbpmDS -Dorg.kie.server.controller=localhost:8080/jbpm-console/rest/controller -Dorg.kie.server.location=localhost:8080/kie-server/services/rest/server -Dorg.kie.server.persistence.dialect=org.hibernate.dialect.PostgreSQL94Dialect

    就是这样.

    推荐答案

    最有可能是由于您的服务器模板(ID为default-kieserver)没有处理能力.进入Deployments-> Execution Servers并从那里删除模板.然后重新启动服务器，并且kie服务器应正确注册其所有功能.

    it's most likely due to your server template (with id default-kieserver) does not have process capabilities. Go into Deployments -> Execution Servers and remove the template from there. Then restart the server and kie server should register with all its capabilities properly.

    或者，您可以使用给定的ID/名称手动创建服务器模板，并且应该只需要它即可.

    Alternatively you can create server template manually with given id/name and it should be all that is needed.