topic Increased precision in DateTime columns being unused. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182930#M136060 <HTML><HEAD></HEAD><BODY><SPAN>I increased the datetime precision in our tables:</SPAN><BR /><BR /><SPAN>desc ACT_HI_ACTINST;</SPAN><BR /><SPAN>+——————–+————–+——+—–+———+——-+</SPAN><BR /><SPAN>| Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Null | Key | Default | Extra |</SPAN><BR /><SPAN>+——————–+————–+——+—–+———+——-+</SPAN><BR /><SPAN>| ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | NO&nbsp;&nbsp; | PRI | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| PROC_DEF_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| PROC_INST_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | NO&nbsp;&nbsp; | MUL | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| EXECUTION_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | NO&nbsp;&nbsp; | MUL | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| ACT_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(255) | NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| TASK_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| CALL_PROC_INST_ID_ | varchar(64)&nbsp; | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| ACT_NAME_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(255) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| ACT_TYPE_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(255) | NO&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| ASSIGNEE_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(255) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| START_TIME_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | datetime(3)&nbsp; | NO&nbsp;&nbsp; | MUL | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| END_TIME_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | datetime(3)&nbsp; | YES&nbsp; | MUL | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| DURATION_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | bigint(20)&nbsp;&nbsp; | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>| TENANT_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(255) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>+——————–+————–+——+—–+———+——-+</SPAN><BR /><BR /><BR /><BR /><SPAN>But when I check what activiti is writing back to this table the increased precision isnt being used:</SPAN><BR /><BR /><SPAN> select START_TIME_,END_TIME_ from ACT_HI_ACTINST order by START_TIME_ desc limit 5;</SPAN><BR /><SPAN>+————————-+————————-+</SPAN><BR /><SPAN>| START_TIME_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | END_TIME_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>+————————-+————————-+</SPAN><BR /><SPAN>| 2015-01-13 10:15:23.000 | 2015-01-13 10:15:23.000 |</SPAN><BR /><SPAN>| 2015-01-13 10:15:21.000 | 2015-01-13 10:15:23.000 |</SPAN><BR /><SPAN>| 2015-01-13 10:15:20.000 | 2015-01-13 10:15:20.000 |</SPAN><BR /><SPAN>| 2015-01-13 02:39:59.000 | 2015-01-13 02:39:59.000 |</SPAN><BR /><SPAN>| 2015-01-13 02:39:59.000 | 2015-01-13 02:39:59.000 |</SPAN><BR /><SPAN>+————————-+————————-+</SPAN><BR /><BR /><BR /><SPAN>I am on version 5.16.</SPAN><BR /><BR /><SPAN>Is there anything I need to do to tell activiti to start using the increased precision?</SPAN></BODY></HTML> Tue, 13 Jan 2015 19:16:40 GMT jorell 2015-01-13T19:16:40Z Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182930#M136060 I increased the datetime precision in our tables:desc ACT_HI_ACTINST;+——————–+————–+——+—–+———+——-+| Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Null | Key | Default | Extra |+——————–+————–+——+—–+———+——-+| ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | NO&nbsp;&nbsp; | PRI | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; || PROC_DEF_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | varchar(64)&nbsp; | Tue, 13 Jan 2015 19:16:40 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182930#M136060 jorell 2015-01-13T19:16:40Z Re: Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182931#M136061 <HTML><HEAD></HEAD><BODY><SPAN>What database are you using? Mysql? If so, are you using mysql 5.6+ ?</SPAN></BODY></HTML> Fri, 16 Jan 2015 11:55:50 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182931#M136061 jbarrez 2015-01-16T11:55:50Z Re: Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182932#M136062 <HTML><HEAD></HEAD><BODY><SPAN>I am using Maria db 10.0.12</SPAN><BR /><SPAN>It does support microsecond precision.</SPAN></BODY></HTML> Fri, 16 Jan 2015 19:32:38 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182932#M136062 jorell 2015-01-16T19:32:38Z Re: Increased precision in DateTime columns being unused. https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182933#M136063 <HTML><HEAD></HEAD><BODY><SPAN>Some googling led me to this: </SPAN><A href="http://stackoverflow.com/questions/25445807/mariadb-jdbc-settimestamp-truncates-milliseconds" rel="nofollow noopener noreferrer">http://stackoverflow.com/questions/25445807/mariadb-jdbc-settimestamp-truncates-milliseconds</A><BR /><BR /><SPAN>Did you try that?</SPAN></BODY></HTML> Wed, 21 Jan 2015 12:59:28 GMT https://connect.hyland.com/t5/alfresco-archive/increased-precision-in-datetime-columns-being-unused/m-p/182933#M136063 jbarrez 2015-01-21T12:59:28Z