Hi!
update:
ok switching to persistence-mysql seems to work and stores the ‘time-part’ correctly.
(not like 00:00:00 in jdbc-mariadb)
I’m persisting some, last updated states into a mariadb using ‘JDBC Persistence MariaDB’.
10:37:42.965 [DEBUG] [nce.jdbc.internal.JdbcPersistenceService] - JDBC: Stored item 'Lum_PST_KE' as '2' in SQL database at Tue Jan 17 10:37:42 CET 2017 in 63 ms.
10:37:42.965 [DEBUG] [hab.persistence.jdbc.internal.JdbcMapper] - JDBC::storeItemValue: item=Lum_PST_KE_LU (Type=DateTimeItem, State=2017-01-17T10:37:42)
10:37:42.965 [DEBUG] [rg.openhab.persistence.jdbc.model.ItemVO] - JDBC:ItemVO tableName=item0090; newTableName=null;
10:37:42.965 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::getItemType: Try to use ItemType DATETIMEITEM for Item Lum_PST_KE_LU
10:37:42.966 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::storeItemValueProvider: item 'Lum_PST_KE_LU' as Type 'DATETIMEITEM' in 'item0090' with state '2017-01-17T10:37:42'
10:37:42.966 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::storeItemValueProvider: getState: '2017-01-17T10:37:42'
10:37:42.966 [DEBUG] [rg.openhab.persistence.jdbc.model.ItemVO] - JDBC:ItemVO setValueTypes dbType=TIMESTAMP(3); javaType=class java.sql.Date;
10:37:42.966 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::storeItemValueProvider: DateTimeItem: '2017-01-17'
10:37:42.966 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::doStoreItemValue sql=INSERT INTO item0090 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? value='2017-01-17'
10:37:42.996 [DEBUG] [nce.jdbc.internal.JdbcPersistenceService] - JDBC: Stored item 'Lum_PST_KE_LU' as '2017-01-17T10:37:42' in SQL database at Tue Jan 17 10:37:42 CET 2017 in 31 ms.
10:37:42.997 [DEBUG] [hab.persistence.jdbc.internal.JdbcMapper] - JDBC::storeItemValue: item=Lum_PST_KE_LastUpdate (Type=StringItem, State=2017-01-17T10:37:42)
10:37:42.997 [DEBUG] [rg.openhab.persistence.jdbc.model.ItemVO] - JDBC:ItemVO tableName=item0091; newTableName=null;
10:37:42.997 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::getItemType: Try to use ItemType STRINGITEM for Item Lum_PST_KE_LastUpdate
10:37:42.997 [DEBUG] [.openhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::storeItemValueProvider: item 'Lum_PST_KE_LastUpdate' as Type 'STRINGITEM' in 'item0091' with state '2017-01-17T10:37:42'
The items in question have a dbType of TIMESTAMP but a java type of java.sql.Date
which doen’t preserve time only date?
Is this an isssue or do I something wrong here?
Hope my question is clear…
th@nx chris