9. 打開源文件 JbpmSessionFactory.java, 在 getInstance() 方法里, 刪除下面代碼

InitialContext initialContext = new InitialContext();
 Object o = initialContext.lookup(jndiName);

將下面這行

instance = (JbpmSessionFactory)
PortableRemoteObject.narrow(o, JbpmSessionFactory.class);

替換為 instance = (JbpmSessionFactory)
PortableRemoteObject.narrow(
new JbpmSessionFactory(createConfiguration()), JbpmSessionFactory.class);

10.在 createConfiguration(String configResource) 方法里, 注釋掉這段代碼

String hibernatePropertiesResource =
JbpmConfiguration.getString("jbpm.hibernate.properties");

if (hibernatePropertiesResource!=null)
{
   Properties hibernateProperties = new Properties();

   try
      { 
         hibernateProperties.load(
                 ClassLoaderUtil.getStream(hibernatePropertiesResource) ); 
      }
   catch (IOException e)
     {
         e.printStackTrace();
         throw new RuntimeException(
               "couldn't load the hibernate properties" +
               " from resource '"hibernatePropertiesResource"'", e);
      }
    log.debug("overriding hibernate properties with "+ hibernateProperties); configuration.setProperties(hibernateProperties); 
 }

同時加入下面的代碼

configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect"); configuration.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver"); configuration.setProperty("hibernate.connection.url", "jdbc:mysql://localhost:3306/";); configuration.setProperty("hibernate.connection.username", "");

configuration.setProperty("hibernate.connection.password", "");

configuration.setProperty("hibernate.connection.pool_size", "15");

11.這種方法需要先開starter-kit中的jboss，然后build websale，最后deploy

參考文章：
http://mdvjiangbin.bokee.com/3185679.html
http://www.aygfsteel.com/znjqolf/archive/2005/12/19/24654.html
還有好多，查過之后都忘了鏈接了，謝謝前人的總結！



方法二：
1，在starter-kit server中部署的jbpm應用里的deploy目錄中創建mysql-ds.xml

文件內容參考如下：
<?xml version="1.0" encoding="UTF-8"?>

<!-- The Hypersonic embedded database JCA connection factory config
$Id: hsqldb-ds.xml,v 1.15 2004/09/15 14:37:40 loubyansky Exp $ -->

<datasource>
   <local-tx-datasource>

      <!-- The jndi name of the DataSource, it is prefixed with java:/ -->
      <!-- Datasources are not available outside the virtual machine -->
      <jndi-name>DefaultDS</jndi-name>

      <!-- for tcp connection, allowing other processes to use the hsqldb
      database. This requires the org.jboss.jdbc.HypersonicDatabase mbean.
      <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
-->
      <!-- for totally in-memory db, not saved when jboss stops.
      The org.jboss.jdbc.HypersonicDatabase mbean necessary
      <connection-url>jdbc:hsqldb:.</connection-url>
-->
      <!-- for in-process persistent db, saved when jboss stops. The
      org.jboss.jdbc.HypersonicDatabase mbean is necessary for properly db shutdown
-->
      <connection-url>jdbc:mysql://localhost:3306/jbpm</connection-url>

      <!-- The driver class -->
      <driver-class>com.mysql.jdbc.Driver</driver-class>

      <!-- The login and password -->
      <user-name>jbpm</user-name>
      <password>jbpm</password>

      <!--example of how to specify class that determines if exception means connection should be destroyed-->
      <!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name-->

      <!-- this will be run before a managed connection is removed from the pool for use by a client-->
      <!--<check-valid-connection-sql>select * from something</check-valid-connection-sql> -->

      <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
      <min-pool-size>5</min-pool-size>

      <!-- The maximum connections in a pool/sub-pool -->
      <max-pool-size>20</max-pool-size>

      <!-- The time before an unused connection is destroyed -->
      <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->
      <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections -->
      <idle-timeout-minutes>0</idle-timeout-minutes>
  
   </local-tx-datasource>
        <metadata>
  <type-mapping>mySQL</type-mapping>
  </metadata>
 </datasource>


2，刪除該目錄有關hsqldb  設置datasource的兩個xml文件。

3，edit 上一目錄conf下的standardjaws.xml中的這段
<datasource>java:/DefaultDS</datasource>
   <type-mapping>mySQL</type-mapping>
讓type-mapping對應mysql-ds.xml中的type-mapping

Step 4: JMS configuration descriptors
a) Remove hsqldb-jdbc2-service.xml from folder deploy/jms. Save this file somewhere else.

b) Copy mysql-jdbc2-service.xml from folder docs/example/jms to deploy/jms.

c) Edit mysql-jdbc2-service.xml and change the datasource name if applicable. In my configuration I don't use HSQL at all so I configured the default datasource DefaultDS for MySQL. In this file, change mySQLDS to DefaultDS. Note that datasource names are case sensitive.

Step 5: Install MySQL Java Connector
Download MySQL Connector/J and place the file mysql-connector-java-3.0.15-ga-bin.jar in the lib folder of the server.



！！！同時需要修改deploy中jbpm.sar文件夾里的jbpm.sar.cfg.jar文件，更新該文件里面的數據庫配置


參考文章：
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3861605