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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
