[jboss-user] [jBPM] - Verifying change to JBPM database

[David Harris]

David Harris [https://community.jboss.org/people/dmwpepper] created the discussion

"Verifying change to JBPM database"

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

--------------------------------------------------------------
Hi, I'm new to JBPM and wanted to change the underlying database to Postgress.   I believe I followed the instructions in the JBPM User Guide.  The server.log seems to indicate that it was deployed ok:

18:42:47,668 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
18:42:47,684 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010404: Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.2)
18:42:47,684 INFO  [org.jboss.as.jpa] (MSC service thread 1-6) JBAS011402: Starting Persistence Unit Service 'jbpm-gwt-console-server.war#org.jbpm.persistence.jpa'
18:42:47,684 INFO  [org.hibernate.ejb.Ejb3Configuration] (MSC service thread 1-6) HHH000204: Processing PersistenceUnitInfo [
name: org.jbpm.persistence.jpa

Dumb question, but I'm not sure how to test to see that its actually working?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/800931#800931]

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

[Jiri Svitak]

Jiri Svitak [https://community.jboss.org/people/jsvitak] created the discussion

"Re: Verifying change to JBPM database"

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

--------------------------------------------------------------
Hi,

you can try to run a business process in jbpm console and when it completes successfully, then it works. Server log should show no persistence related errors. You can also install pgAdmin, connect to the database and check that there is a database schema created for jbpm.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/801062#801062]

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

[David Harris]

David Harris [https://community.jboss.org/people/dmwpepper] created the discussion

"Re: Verifying change to JBPM database"

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

--------------------------------------------------------------
The directions on trying a MySQL database are confusing.  The directions end with:

+Start the demo+
+We've modified all the neccessary files at this point, all that's left to do is run the demo.+
+Of course, this would be a good time to start your database up as well!+



Don't you have to put a MySQL driver in standalone/deployments before running the demo?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/801185#801185]

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

[Jiri Svitak]

Jiri Svitak [https://community.jboss.org/people/jsvitak] created the discussion

"Re: Verifying change to JBPM database"

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

--------------------------------------------------------------
Hello David,

your second question does not relate to the first one. If the answer was helpful for you, could you mark your question as answered and start a new thread for another question? Otherwise the discussions become confusing. Thanks.
Regarding to your second question - I do not know which manual did you follow, but in general you have to provide jdbc driver for container to connect to database. For standalone deployment it's fine to use JBoss modules. See https://community.jboss.org/docs/DOC-16657 https://community.jboss.org/wiki/DataSourceConfigurationInAS7
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/801299#801299]

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