Ok, so I believe OH is connecting to the DB now, but it nothing is being read from or written to the DB, it seems. I’m getting errors like this after putting the jdbc binding into debug mode:
JDBC::query: query for Humidity returned 0 rows in 14 ms
JDBC::query: query for Inside_Humidity returned 0 rows in 16 ms
JDBC::query: query for TempDisplay returned 0 rows in 13 ms
Here is my mysql.persist:
Strategies {
default = everyChange
}
Items {
* : strategy = everyChange, restoreOnStartup
Inside_* : strategy = everyChange, restoreOnStartup
PorchLight_Switch: strategy = everyChange, restoreOnStartup
GarageLight_Switch: strategy = everyChange, restoreOnStartup
PatioLight_Switch: strategy = everyChange, restoreOnStartup
LRWindowLight_Switch: strategy = everyChange, restoreOnStartup
Desk_Light_Switch: strategy = everyChange, restoreOnStartup
Utility_Switch: strategy = everyChange, restoreOnStartup
Humidity : strategy = everyChange, restoreOnStartup
PressureDisplay : strategy = everyChange, restoreOnStartup
TempDisplay : strategy = everyChange, restoreOnStartup
Sunrise : strategy = everyChange, restoreOnStartup
Sunset : strategy = everyChange, restoreOnStartup
Daylength : strategy = everyChange, restoreOnStartup
Daylength2 : strategy = everyChange, restoreOnStartup
stair_light_level: strategy = everyChange, restoreOnStartup
back_door_1_level: strategy = everyChange, restoreOnStartup
window_light_level: strategy = everyChange, restoreOnStartup
DeskMoteBattery_level: strategy = everyChange, restoreOnStartup
DoorSensor_Battery: strategy = everyChange, restoreOnStartup
WallMote_Battery: strategy = everyChange, restoreOnStartup
luminance_check_started: strategy = everyChange, restoreOnStartup
max_luminance: strategy = everyChange, restoreOnStartup
max_luminance_time: strategy = everyChange, restoreOnStartup
Barrier_State: strategy = everyChange, restoreOnStartup
Hallway_Humidity: strategy = everyChange, restoreOnStartup
Car_Battery_Level: strategy = everyChange, restoreOnStartup
CarBattery_Update: strategy = everyChange, restoreOnStartup
max_luminance: strategy = everyChange, restoreOnStartup
max_luminance_time: strategy = everyChange, restoreOnStartup
Hallway_Temp: strategy = everyChange, restoreOnStartup
nano_mote_quad_battery: strategy = everyChange, restoreOnStartup
}
Here is my mysql.config:
url=jdbc:mysql://localhost:3306/openhab
user=xxxxx
password=xxxxxx
mysql:sqltype.string=VARCHAR(20000)
I have the JDBC Persistence MySQL 1.13.0 persistence driver installed.