Issue while replacing the H2 database with PostgresSQL

Suchi

unread,

Mar 13, 2015, 9:10:20 PM3/13/15

to jbpm-...@googlegroups.com

I followed the necessary steps mentioned in the documentation(http://docs.jboss.org/jbpm/v6.2/userguide/ch03.html#d0e950), however I get the following error

2015-03-13 17:03:01,282 WARN [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015960: Class Path entry log4j-1.2.16.jar in /C:/Users/<>kfj/deployment/trunk/jbpm-installer/content/jbpm-console.war/WEB-INF/lib/jbpmmigration-0.13.jar does not point to a valid jar for a Class-Path reference.

2015-03-13 17:03:01,704 INFO [org.jboss.as.jpa] (MSC service thread 1-5) JBAS011401: Read persistence.xml for org.jbpm.domain

...

2015-03-13 17:03:02,796 WARN [org.jboss.as.dependency.private] (MSC service thread 1-13) JBAS018567: Deployment "deployment.jbpm-console.war" is using a private module ("org.apache.neethi:main") which may be changed or removed in future versions without notice.

2015-03-13 17:03:02,796 WARN [org.jboss.as.dependency.private] (MSC service thread 1-13) JBAS018567: Deployment "deployment.jbpm-console.war" is using a private module ("org.apache.xml-resolver:main") which may be changed or removed in future versions without notice.

2015-03-13 17:03:02,796 WARN [org.jboss.as.dependency.private] (MSC service thread 1-13) JBAS018567: Deployment "deployment.jbpm-console.war" is using a private module ("org.jboss.as.naming:main") which may be changed or removed in future versions without notice.

2015-03-13 17:03:02,796 WARN [org.jboss.as.dependency.private] (MSC service thread 1-13) JBAS018567: Deployment "deployment.jbpm-console.war" is using a private module ("org.jboss.as.server:main") which may be changed or removed in future versions without notice.

2015-03-13 17:03:02,827 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("deploy") failed - address: ([("deployment" => "jbpm-console.war")]) - failure description: {"JBAS014771: Services with missing/unavailable dependencies" => ["jboss.persistenceunit.\"jbpm-console.war#org.jbpm.domain\".__FIRST_PHASE__ is missing [jboss.naming.context.java.jboss.postgresDS]"]}

2015-03-13 17:03:02,842 INFO [org.jboss.as.server] (ServerService Thread Pool -- 31) JBAS018559: Deployed "postgresql-9.1-902.jdbc4.jar" (runtime-name : "postgresql-9.1-902.jdbc4.jar")

2015-03-13 17:03:02,842 INFO [org.jboss.as.server] (ServerService Thread Pool -- 31) JBAS018559: Deployed "jbpm-console.war" (runtime-name : "jbpm-console.war")

2015-03-13 17:03:02,858 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

JBAS014775: New missing/unsatisfied dependencies:

service jboss.naming.context.java.jboss.postgresDS (missing) dependents: [service jboss.persistenceunit."jbpm-console.war#org.jbpm.domain".__FIRST_PHASE__]

2015-03-13 17:03:02,920 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management

2015-03-13 17:03:02,920 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

2015-03-13 17:03:02,920 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: WildFly 8.1.0.Final "Kenny" started (with errors) in 95972ms - Started 278 of 327 services (2 services failed or missing dependencies, 108 services are lazy, passive or on-demand)

2015-03-13 17:03:04,678 INFO [org.jboss.as.server.deployment] (MSC service thread 1-15) JBAS015877: Stopped deployment jbpm-console.war (runtime-name: jbpm-console.war) in 1596ms

2015-03-13 17:03:04,771 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018558: Undeployed "jbpm-console.war" (runtime-name: "jbpm-console.war")

2015-03-13 17:03:04,771 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report

JBAS014775: New missing/unsatisfied dependencies:

service jboss.persistenceunit."jbpm-console.war#org.jbpm.domain".__FIRST_PHASE__ (missing) dependents: [service jboss.deployment.unit."jbpm-console.war".POST_MODULE]

SNIPPET OF THE DATASOURCE:

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

<driver>postgresql</driver>

<user-name>jbpm</user-name>

</security>

</datasource>

QUESTION:

Can someone explain what role do the "jndi-name" and "pool-name" play and how I can cutomize/configure them?

(Currently I'm randomly choosing them, based on examples available)

Suchi

unread,

Mar 16, 2015, 5:32:06 PM3/16/15

to jbpm-...@googlegroups.com

I was able to resolve the errors by keeping the "pool-name" as pool-name="H2DS".

Also I have created the following document, hope it helps people trying to move from h2 to postgres

http://pastebin.com/AqdNrzEi

However, I'm still wondering how to configure the pool name to something else and what role does it play. If anyone can help me understand.

Thanks,

Suchi

Kris Verlaenen

unread,

Mar 16, 2015, 8:31:43 PM3/16/15

to Suchi, jbpm-...@googlegroups.com

Thanks, I'm updating the jbpm-installer doc with similar code examples for PostgreSQL, they should be on the jbpm.org documentation tomorrow.

I'm not sure why you seem to be having issues with pool-name 'postgresDS', I tried the same earlier with pool-name 'PostgreSQLDS' and that seemed to work. Is it possible that there were other changes as well, or possibly the database wasn't set up correctly yet?

Kris

--
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/cacc3ddd-c46b-45ef-a181-95dde0e99b52%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Suchi

unread,

Mar 16, 2015, 9:21:38 PM3/16/15

to jbpm-...@googlegroups.com, such...@gmail.com

Hi Kris,

Thanks for your input.

I tried to change the pool-name again and re-install the demo, it seems to boot up fine now.

Not sure, what went wrong last time!

Suchi

unread,

Mar 20, 2015, 7:35:54 PM3/20/15

to jbpm-...@googlegroups.com, such...@gmail.com

I'm created the following blog:

https://learnjbpmsuchi.wordpress.com/2015/03/20/moving-from-h2-database-to-postgresql/

Hope it's more accessible.

Reply all

Reply to author

Forward