I have problem in openhab2 with persistence.
My items:
Number ESP_Temp01 “Temperatura [%.1f °C]” (gC_Furnace, gTemperature) {mqtt=“<[mosquitto:/DOM/ESP-10763452/temperatura/:state:default]”}
My “persist”
Strategies {
everyMinute : “0 * * * * ?”
everyHour : “0 0 * * * ?”
everyDay : “0 0 0 * * ?”
default = everyChange
}
Items {
ESP_Temp01 : strategy = everyChange, everyHour, everyMinute, restoreOnStartup
}
in idbc uncomment only:
url=jdbc:sqlite:/usr/share/openhab2/testSqlite.db
Openhab.log:
2017-01-20 17:24:41.265 [INFO ] [el.core.internal.ModelRepositoryImpl] - Refreshing model ‘postgre.persist’
2017-01-20 17:31:14.570 [INFO ] [el.core.internal.ModelRepositoryImpl] - Refreshing model ‘postgre.persist’
2017-01-21 11:49:31.329 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::logTime: ‘insertItemValue’:
afterAccess = 6 ms
timeAverage50 = 52 ms
timeAverage100 = 52 ms
timeAverage200 = 52 ms
afterAccessMin = 0 ms
afterAccessMax = 150 ms
1000Statements = 0 sec
statementCount = 12
2017-01-21 11:49:31.331 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::logTime: ‘insertItemValue’:
afterAccess = 3 ms
timeAverage50 = 48 ms
timeAverage100 = 48 ms
timeAverage200 = 48 ms
afterAccessMin = 0 ms
afterAccessMax = 150 ms
1000Statements = 0 sec
statementCount = 13
Openhab2 was created /usr/share/openhab2/testSqlite.db
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE items (ItemId INTEGER PRIMARY KEY AUTOINCREMENT, itemname VARCHAR(500) NOT NULL);
COMMIT;
But nothing wrote inside.
I have exalty the same problem with postgresql.
Any suggestions?