I have an existing Wildfly installation containing other apps. Besides that I want to deploy Kie Workbench too. Here I do not want to use the demo installation using Ant, which starts downloading and installing JBoss afresh.
My existing environment is below.
OS: Windows Server
Database: Postgres 9.6.1
JDBC: postgresql-42.1.4.jar
App Server: wildfly-10.1.0.Final
BPM/Drools App: kie-wb-7.2.0.Final-wildfly10.war
I deployed the Kie Workbench by downloading the war file from here: https://repo1.maven.org/maven2/org/kie/kie-wb/
Now I would like to change the default H2 database driver with Postgresql 9.6.
Prior to this I created users and datasources already and had a workable kie-wb site, but only problem is: it is running on H2.
Any help appreciated in replacing H2 with Postgresql driver.
I performed the below steps. But somewhere I went wrong, not sure where. I am unable to login to the kie workbench.
JBPM App Server Configuration for PostgreSQL
Issue the below ant commands from the directory of the expanded zip files:
ant clean.generated.ddl
ant download.ddl.dependencies
ant install.jboss
ant install.jBPM-console.into.jboss
Make sure standalone.xml and standalone-full.xml are being copied into the Wildfly configuration directory correctly.
Move the wildfly directory to the location of the JBOSS_HOME, or create environment variable pointing to the same.
Create the directory modules\org\postgresql\main in JBOSS_HOME home and copy files: module.xml, postgresql-42.1.4.jar
Add admin user in the Management Realm: admin
Bing! you are done!