I increased the datetime precision in our tables:
desc ACT_HI_ACTINST;
+——————–+————–+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+——————–+————–+——+—–+———+——-+
| ID_ | varchar(64) | NO | PRI | NULL | |
| PROC_DEF_ID_ | varchar(64) | NO | | NULL | |
| PROC_INST_ID_ | varchar(64) | NO | MUL | NULL | |
| EXECUTION_ID_ | varchar(64) | NO | MUL | NULL | |
| ACT_ID_ | varchar(255) | NO | | NULL | |
| TASK_ID_ | varchar(64) | YES | | NULL | |
| CALL_PROC_INST_ID_ | varchar(64) | YES | | NULL | |
| ACT_NAME_ | varchar(255) | YES | | NULL | |
| ACT_TYPE_ | varchar(255) | NO | | NULL | |
| ASSIGNEE_ | varchar(255) | YES | | NULL | |
| START_TIME_ | datetime(3) | NO | MUL | NULL | |
| END_TIME_ | datetime(3) | YES | MUL | NULL | |
| DURATION_ | bigint(20) | YES | | NULL | |
| TENANT_ID_ | varchar(255) | YES | | | |
+——————–+————–+——+—–+———+——-+
But when I check what activiti is writing back to this table the increased precision isnt being used:
select START_TIME_,END_TIME_ from ACT_HI_ACTINST order by START_TIME_ desc limit 5;
+————————-+————————-+
| START_TIME_ | END_TIME_ |
+————————-+————————-+
| 2015-01-13 10:15:23.000 | 2015-01-13 10:15:23.000 |
| 2015-01-13 10:15:21.000 | 2015-01-13 10:15:23.000 |
| 2015-01-13 10:15:20.000 | 2015-01-13 10:15:20.000 |
| 2015-01-13 02:39:59.000 | 2015-01-13 02:39:59.000 |
| 2015-01-13 02:39:59.000 | 2015-01-13 02:39:59.000 |
+————————-+————————-+
I am on version 5.16.
Is there anything I need to do to tell activiti to start using the increased precision?
