[jboss-user] [jBPM] - Re: PostgreSQL - empty database - install.demo.db does not exist

[roxy1987]

roxy1987 [https://community.jboss.org/people/roxy1987] created the discussion

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

To view the discussion, visit: https://community.jboss.org/message/789315#789315

--------------------------------------------------------------
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
[https://community.jboss.org/message/789315#789315]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130108/96bdda64/attachment-0001.html