11:06 p.m.
AUNG MYO ZAW [http://community.jboss.org/people/aungmyozaw] created the discussion
"Re: how to install the jbpm5 to work on mysql database"
To view the discussion, visit: http://community.jboss.org/message/610866#610866
--------------------------------------------------------------
Hi nirav2003,
I also develop a sample project with Spring, jBPM5 and Drools. For me, I configure in
update hibernate.cfg.xml, persistence.xml and testDS1-ds.xml. And also I have point out
my WS-Human Task Server's persistence.xml from runtime/jbpm-human-task-5.0.0.jar.
Inside jar, there has also persistence for WS-HT server. I change and point out it like
that:
<?xml version="1.0" encoding="UTF-8"
standalone="yes"?>
<persistence version="1.0"
xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
http://java.sun.com/xml/ns/persistence/orm
http://java.sun.com/xml/ns/persistence/orm
http://java.sun.com/xml/ns/persistence/orm_1_0.xsd
http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
xmlns:orm=" http://java.sun.com/xml/ns/persistence/orm
http://java.sun.com/xml/ns/persistence/orm"
xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance
http://www.w3.org/2001/XMLSchema-instance"
xmlns=" http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence">
<persistence-unit name="org.jbpm.task">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.jbpm.task.Attachment</class>
<class>org.jbpm.task.Content</class>
<class>org.jbpm.task.BooleanExpression</class>
<class>org.jbpm.task.Comment</class>
<class>org.jbpm.task.Deadline</class>
<class>org.jbpm.task.Comment</class>
<class>org.jbpm.task.Deadline</class>
<class>org.jbpm.task.Delegation</class>
<class>org.jbpm.task.Escalation</class>
<class>org.jbpm.task.Group</class>
<class>org.jbpm.task.I18NText</class>
<class>org.jbpm.task.Notification</class>
<class>org.jbpm.task.EmailNotification</class>
<class>org.jbpm.task.EmailNotificationHeader</class>
<class>org.jbpm.task.PeopleAssignments</class>
<class>org.jbpm.task.Reassignment</class>
<class>org.jbpm.task.Status</class>
<class>org.jbpm.task.Task</class>
<class>org.jbpm.task.TaskData</class>
<class>org.jbpm.task.SubTasksStrategy</class>
<class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class>
<class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class>
<class>org.jbpm.task.User</class>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.connection.driver_class"
value="com.mysql.jdbc.Driver"/>
<property name="hibernate.connection.url"
value="jdbc:mysql://localhost:3306/jbpm" />
<property name="hibernate.connection.username"
value="root"/>
<property name="hibernate.connection.password"
value="admin"/>
<property name="hibernate.connection.autocommit"
value="false" />
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="create" />
<property name="hibernate.show_sql" value="false" />
</properties>
</persistence-unit>
</persistence>
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/610866#610866]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
6:06 p.m.
nirav2003 [http://community.jboss.org/people/nirav2003] created the discussion
"Re: how to install the jbpm5 to work on mysql database"
To view the discussion, visit: http://community.jboss.org/message/611069#611069
--------------------------------------------------------------
Sorry for the late reply, but still I was trying to make it work. I have configured it as
follows:
1. Hibernate.cfg.xml
<session-factory>
<!-- Database connection settings -->
<property
name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property
name="connection.url">jdbc:mysql://192.168.12.99:3306/jbpm_demo?useUnicode=true&characterEncoding=UTF-8</property>
<!--property
name="connection.url">jdbc:h2:file:/NotBackedUp/data/mydb</property-->
<property name="connection.username">jbpmUser</property>
<property name="connection.password">jbpm</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property
name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property
name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property
name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">false</property>
<!-- Drop and re-create the database schema on startup? -->
<property name="hbm2ddl.auto">create</property>
<mapping resource="AuditLog.hbm.xml"/>
</session-factory>
2. Persistence.xml
<persistence-unit name="org.jbpm.persistence.jpa"
transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:jdbc/jbpmDatasource</jta-data-source>
<mapping-file>META-INF/JBPMorm.xml</mapping-file>
<class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.info.SessionInfo</class>
<class>org.drools.persistence.info.WorkItemInfo</class>
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.MySQLInnoDBDialect"/>
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="create" />
<property name="hibernate.show_sql" value="false" />
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup" />
</properties>
</persistence-unit>
3. TestDS1-ds.xml
<local-tx-datasource>
<jndi-name>jdbc/jbpmDatasource</jndi-name>
<connection-url>jdbc:mysql://192.168.12.99:3306/jbpm_demo?useUnicode=true&characterEncoding=UTF-8</connection-url>
<!--connection-url>jdbc:h2:mem:mydb</connection-url-->
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>jbpmUser</user-name>
<password>jbpm</password>
</local-tx-datasource>
4. Persistence.xml in jbpm-human-task-5.1.0.CR1.jar properties changed to
<properties>
<property name="hibernate.dialect"
value="org.hibernate.dialect.MySQLInnoDBDialect"/>
<property name="hibernate.connection.driver_class"
value="com.mysql.jdbc.Driver"/>
<property name="hibernate.connection.url"
value="jdbc:mysql://192.168.12.99:3306/JBPM_DEMO?useUnicode=true&characterEncoding=UTF-8"
/>
<property name="hibernate.connection.username"
value="jbpmUser"/>
<property name="hibernate.connection.password"
value="jbpm"/>
<property name="hibernate.connection.autocommit"
value="false" />
<property name="hibernate.max_fetch_depth" value="3"/>
<property name="hibernate.hbm2ddl.auto" value="create" />
<property name="hibernate.show_sql" value="false" />
</properties>
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/611069#611069]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
6:19 p.m.
nirav2003 [http://community.jboss.org/people/nirav2003] created the discussion
"Re: how to install the jbpm5 to work on mysql database"
To view the discussion, visit: http://community.jboss.org/message/611070#611070
--------------------------------------------------------------
After doing all this changes the end result is still same, database in MySql is not
created after running install command.
Also, when i am running the startup command i am receiving above error. (The error is due
to the database table not found.)
using following softwares:
MySql 5.1
jbpm-5.1.0.CR1-installer.zip
Windows 2008 server.
MySql is installed on different server.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/611070#611070]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
12:33 a.m.
AUNG MYO ZAW [http://community.jboss.org/people/aungmyozaw] created the discussion
"Re: how to install the jbpm5 to work on mysql database"
To view the discussion, visit: http://community.jboss.org/message/611106#611106
--------------------------------------------------------------
Nevermine nirav. As for me,
~ Firstly I configure "jbpm-5.0.0\build.xml",
~ And then, configure "db\persistence.xml, db\hibernate.cfg.xml,
db\testDS1-DS.xml",
~ And then, I also changed in "jbpm-5.0.0\lib\jbpm-5.0.0.bin.zip". Extract zip
and there are seven jars. I configured the jbpm-human-task-5.0.0.jar like previous
describe.
~ And then create a database in MySQL with name "jbpm" that described in
persistence.xml.
~ I run and command with Ant "ant install.demo.mysql".
~ And also want to sugguest to reference "
http://docs.jboss.org/jbpm/v5.0/userguide/ch02.html
http://docs.jboss.org/jbpm/v5.0/userguide/ch02.html"
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/611106#611106]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
12:23 p.m.
nirav2003 [http://community.jboss.org/people/nirav2003] created the discussion
"Re: how to install the jbpm5 to work on mysql database"
To view the discussion, visit: http://community.jboss.org/message/611272#611272
--------------------------------------------------------------
Thanks for the explanation.
It looks like the only difference is in build.xml
Can you share what you change in build.xml? (I am not good with the build tools.)
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/611272#611272]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
12:56 p.m.
nirav2003 [http://community.jboss.org/people/nirav2003] created the discussion
"Re: how to install the jbpm5 to work on mysql database"
To view the discussion, visit: http://community.jboss.org/message/611277#611277
--------------------------------------------------------------
Finally I found the problem.
Anyone using MySql 5 and above needs different dialect for hibernate.
Use MySQL5InnoDBDialect instead of MySQLInnoDBDialect.
Everything is fine after changing the dialect.
Thanks everyone for your contribution. Specially AUNG MYO ZAW.
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/611277#611277]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4938
days inactive
4941
days old
5 comments
2 participants
participants (2)
-
AUNG MYO ZAW -
nirav2003