jBPM3備忘録

ローカルのデータベースでテストする

diff --git a/pom.xml b/pom.xml
index 68269a0..2dfb8fd 100644
--- a/pom.xml
+++ b/pom.xml
@@ -693,11 +693,24 @@
           <value>mysql</value>
         </property>
       </activation>
+      <properties>
+        <database>mysql</database>
+
+        <jdbc.mysql.server>localhost</jdbc.mysql.server>
+        <jdbc.mysql.port>3306</jdbc.mysql.port>
+        <jdbc.mysql.database>soa531</jdbc.mysql.database>
+        <jdbc.mysql.url>jdbc:mysql://${jdbc.mysql.server}:${jdbc.mysql.port}/${jdbc.mysql.database}</jdbc.mysql.url>
+        <jdbc.mysql.username>mysql</jdbc.mysql.username>
+        <jdbc.mysql.password>mysql</jdbc.mysql.password>
+        <jdbc.mysql.driver>com.mysql.jdbc.Driver</jdbc.mysql.driver>
+
+      </properties>
+
       <dependencies>
         <dependency>
-          <groupId>${jdbc.driver.group}</groupId>
-          <artifactId>${jdbc.driver.artifact}</artifactId>
-          <version>${jdbc.driver.version}</version>
+          <groupId>mysql</groupId>
+          <artifactId>mysql-connector-java</artifactId>
+          <version>5.1.6</version>
           <scope>test</scope>
         </dependency>
       </dependencies>

mvn test -Dtest=JBPM4031Test -Pmysql

マニュアル削除SQL (基本selectで確認 -> ID_ で delete)

delete from JBPM_MODULEINSTANCE where PROCESSINSTANCE_ = 17;
update JBPM_PROCESSINSTANCE set ROOTTOKEN_ = NULL where ID_ = 16;
delete from JBPM_TOKEN where PARENT_ = 19;
delete from JBPM_PROCESSINSTANCE where ID_ = 16;