JBoss Community

Re: PostgreSQL - empty database - install.demo.db does not exist

created by roxy1987 in jBPM - View the full discussion

Your configuration looks goood. I hope the name iof the driver jar file you use is postgresql-jdbc.jar

 

This is what your subsystem tag looks like





<subsystem xmlns="urn:jboss:domain:datasources:1.0">

<datasources>

<datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="jbpmDS" enabled="true" use-java-context="true">

<connection-url>jdbc:postgresql://localhost:5432/jbpm5</connection-url>

<driver>postgresql</driver>

<pool></pool>

<security>

<user-name>jbpm5</user-name>

<password>jbpm5</password>

</security>

</datasource>

<drivers>

<driver name="postgresql" module="org.postgresql">

<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>

</driver>

</drivers>

</datasources>

</subsystem>



And this is what the original one is :





 

 

I#nstead of just replacing the entire thing, you should only modify the values in the original. Because the fragment in the user guide is from previous versions. This may not be the cause of the problem but just modify and check.

Everything else looks good. Lemme know..

<subsystem xmlns="urn:jboss:domain:datasources:1.0">

<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/jbpmDS" pool-name="H2DS" enabled="true" use-java-context="true" use-ccm="true">

<connection-url>jdbc:h2:~/jbpm</connection-url> #

<driver>h2</driver>

<pool>

<min-pool-size>1</min-pool-size>

<max-pool-size>4</max-pool-size>

<prefill>false</prefill>

<use-strict-min>false</use-strict-min>

<flush-strategy>FailingConnectionOnly</flush-strategy>

</pool>

<security>

<user-name>sa</user-name>

</security>

<validation>

<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

<validate-on-match>false</validate-on-match>

<background-validation>false</background-validation>

</validation>

</datasource>

<drivers>

<driver name="h2" module="com.h2database.h2">

<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

</driver>

</drivers>

</datasources>

</subsystem>

Reply to this message by going to Community

Start a new discussion in jBPM at Community