1. In mysql, create a database 'bpms64kie':
$ mysql -u root -p -e "create database bpms64kie";
2. Import the dump:
$ mysql -u root -p bpms64kie < bpms64kie_db.dump
3. Grant access to user jboss/jboss:
$ mysql -u root -p -e "grant all privileges on bpms64kie.* to 'jboss'@'localhost'";
4. Configure the RHPAM 7.x instance:
<property name="org.kie.server.persistence.ds" value="java:jboss/datasources/mysqlpamDS"/>
<property name="org.kie.server.persistence.dialect" value="org.hibernate.dialect.MySQL57InnoDBDialect"/>
<property name="hibernate.hbm2ddl.auto" value="none"/>
<xa-datasource jndi-name="java:jboss/datasources/mysqlpamDS" pool-name="mysqlpamDS">
<xa-datasource-property name="URL">
jdbc:mysql://localhost:3306/bpms64kie
</xa-datasource-property>
<driver>mysql</driver>
<security>
<user-name>jboss</user-name>
<password>jboss</password>
</security>
<xa-pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
</validation>
</xa-datasource>
<xa-datasource jndi-name="java:jboss/datasources/ejb_timer" pool-name="ejb_timer">
<xa-datasource-property name="URL">
jdbc:mysql://localhost:3306/bpms64kie
</xa-datasource-property>
<driver>mysql</driver>
<security>
<user-name>jboss</user-name>
<password>jboss</password>
</security>
<xa-pool>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
</validation>
</xa-datasource>
5. Start the RHPAM instance / kie-server
6. Run the script:
$ sh
case03200412.sh
true
...
Process 9 created for process case03200412.timertest
...
> GET /kie-server/services/rest/server/admin/containers/example:case03200412:1.0/processes/instances/9/timers HTTP/1.1
{
"timer-instance" : [ {
"name" : "do something-",
"id" : 1,
"timer-id" : 1,
"activation-time" :
{
"java.util.Date" : 1652132074566
}
,
"last-fire-time" : null,
"next-fire-time" : {
"java.util.Date" : 1665424800000
},
"delay" : 13292725434,
"period" : 0,
"repeat-limit" : -1,
"process-instance-id" : 9,
"session-id" : 20
} ]
// compare this to the instance 6, which has been created in BPMS 6.4
> GET /kie-server/services/rest/server/admin/containers/example:case03200412:1.0/processes/instances/6/timers HTTP/1.1
{
"timer-instance" : [
{
"name" : "[SLA]do something",
"id" : 0,
"timer-id" : 0,
"activation-time" : null,
"last-fire-time" : null,
"next-fire-time" : null,
"delay" : 0,
"period" : 0,
"repeat-limit" : 0,
"process-instance-id" : 0,
"session-id" : 0
}
, {
"name" : "",
"id" : 1,
"timer-id" : 1,
"activation-time" :
{
"java.util.Date" : 1652129630737
}
,
"last-fire-time" : null,
"next-fire-time" : {
"java.util.Date" : 1665424800000
},
"delay" : 13295169263,
"period" : 0,
"repeat-limit" : 0,
"process-instance-id" : 6,
"session-id" : 15
} ]