[jboss-user] [JBoss jBPM] - Re: jBPM BPEL change DB - HowTo?
fwshk
do-not-reply at jboss.com
Mon Aug 7 21:56:39 EDT 2006
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
More information about the jboss-user
mailing list