[JCS-84] information loss and ambiguous field names in JDBCDiskCache

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: jcs-1.3, jcs-2.0-beta-1
• Fix Version/s: jcs-2.0-beta-1
• Component/s: JDBC Disk Cache
• Assignee: Thomas Vandahl
• Reporter: Aleksandar Ivanisevic
• Created: 13/Sep/11 14:12
• Updated: 01/Apr/15 14:50
• Resolved: 30/Oct/11 18:10

Description

in JDBCDiskCache CREATE_TIME is defined as DATE, not as TIMESTAMP (or DATETIME in mysql) so the time information is lost greatly reducing the usability of the field. Also, CREATE_TIME_SECONDS is not actually a create time but an update time since it is set to current time on every update.

attached patch solves both issues