How to connect postgresql database from camunda jboss bmp

Camunda 7 Topics Discussion & Questions
1

Hi Friends. I have been trying this since 3-4 days. Not able to succeed. How to create data source in Camunda Jboss to connect to PostgreSQL. Following is data source I have created

			 <datasource jndi-name="java:jboss/datasources/ProcessEngine" pool-name="ProcessEngine" enabled="true" use-java-context="true">
             <connection-url>jdbc:postgresql://13.74.161.104:5432/TestCamunda</connection-url> 
			<!--	<connection-url>jdbc:sqlserver:localhost:1433;database=inf-dev-eun-master-db</connection-url> -->
                <driver>postgresql</driver>
                <security>
                    <user-name>uname</user-name>
                    <password>pwd</password>
                </security>
            </datasource>
          
            <drivers>
				<driver name="postgresql" module="org.postgresql">
				   <xa-datasource-class>org.postgresql.main.postgresql-9.4-1206-jdbc41.jar</xa-datasource-class>
				</driver>
            </drivers>
2

What error are you getting?
Have you added the postgre driver to JBoss?
Can you connect to the database using a local client?

3

Hi,

take a look in the camunda platform qa folder. There is the jboss runtime configured with postgresql.
See for example the datasources:

<datasources>
  <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
    <driver>h2</driver>
    <security>
      <user-name>sa</user-name>
      <password>sa</password>
    </security>
  </datasource>
  <datasource jta="true" jndi-name="java:jboss/datasources/ProcessEngine" pool-name="ProcessEngine" enabled="true" use-java-context="true" use-ccm="true">
    <connection-url>${database.url}</connection-url>
    <driver>postgresql</driver>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <pool>
      <prefill>false</prefill>
      <use-strict-min>false</use-strict-min>
      <flush-strategy>FailingConnectionOnly</flush-strategy>
    </pool>
    <security>
      <user-name>${database.username}</user-name>
      <password>${database.password}</password>
    </security>
    <validation>
      <validate-on-match>false</validate-on-match>
      <background-validation>false</background-validation>
    </validation>
  </datasource>
</datasources>

The standalone configuration can be found here.
Also for a short example you can see this forum post.

Hope it helps.

Greets,
Chris