Kie-server with postgresql database

[Anand Parthiban]

Hi All,

I have installed kie-server and kie-wb on differenent machines and both works without any issues.

But currently both are running with the default H2 database instances which i wanted to move it to postgresql while deploying in production.


I have configured my wildfly 8.0.2 instance standalone-full.xml with datasource and driver details.

I have also created org/postgresql/main directory under wildfly/modules and added module.xml and the postgres driver.

But still when i start my server kie-server.war starts with the default H2 instance. 

Let me know if am doing anything wrong here

Attachment : standalone-full.xml

[Maciej Swiderski]

you need to instruct kie server to use different (than default) data source and dialect. You do that via system properties:

-Dorg.kie.server.persistence.dialect=org.hibernate.dialect.PostgreSQLDialect -Dorg.kie.server.persistence.ds=java:jboss/datasources/psjbpmDS

change the JNDI name of the data soure that matches your environment and that should do the trick. Though this is for kie server only, for workbench you need to modify persistence.xml that resides in jbpm-console.war/WEB-INF/classes/META-INF same stuff needs to be changed

Maciej

--
You received this message because you are subscribed to the Google Groups "jBPM Usage" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-usage+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-usage/51aa0867-4cbf-4e20-9d16-d42302fe966f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<standalone-full.xml>

[tony.h...@gmail.com]

Is this still required for 7.4.1F? (I hve given up trying to get the installation to work with Postgres)

If so where does this get inserted? ant scipt?