[jboss-user] [JBoss jBPM] - Re: jBPM BPEL change DB - HowTo?

[fwshk]

Hi Claus,

Thanks for trying my previous post. May be my previous post is not well organized. However, I make a updated version for MySQL. In facts, I haven't been used MSSQL.

My Configure:
 - jbpm-bpel-1.1-beta1
 - jboss-4.0.4.GA
 - mysql-5.0.21
 - mysql-connector-java-5.0.0-beta

1. Edit JBPM_HOME\build.properties
jboss.home=D:/Try/jboss-4.0.4.GA
  | jbpm.bpel.version=1.1-beta1
  | jbpm.version=3.1.1

2. Edit JBPM_HOME\src\resources\jbpm-bpel.sar\hibernate.properties
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
  | hibernate.connection.datasource=java:/jbpmBpelDS
  | hibernate.show_sql=true
  | hibernate.query.substitutions=true 1, false 0 
  | hibernate.hbm2ddl.auto=update
Notice:
 - Datasource name is case sentience
 - doankhoavy talk about use "create" rather than "update"

3. Edit JBPM_HOME\src\resources\jbpm-bpel.sar\jbpm-bpel-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>jbpmBpelDS</jndi-name>
  |     <connection-url>jdbc:mysql://localhost/jbpmBpel</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>root</user-name>
  |     <password></password>
  |     <min-pool-size>5</min-pool-size>
  |     <max-pool-size>20</max-pool-size>
  |     <idle-timeout-minutes>0</idle-timeout-minutes>
  |     <track-statements />
  |     <metadata>
  |       <type-mapping>MySQL</type-mapping>
  |     </metadata>
  |   </local-tx-datasource>
  | </datasources>

4. Execute command
CD JBPM_HOME
  | ANT build.service.404

5. Copy JBPM_HOME\build\jbpm-bpel.sar to JBOSS\service\default\deploy
Notice:
 - Place into your server instead of default server

6. Copy MySQL Driver into JBOSS\service\default\lib
Notice:
 - Place into your server instead of default server

7. Before start JBoss:
 - Please confirm that your MySQL is running
 - The database is existing in your MySQL
 - The user is able to access the database

8. Start your JBoss

Wish it is helpful for you and I am welcome for point out my mistake.

Roy

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963693#3963693

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963693