I updated my openhab istallation to 4.2
After the update I had to reinstall my sql Binding (MarinaDB).
All works fine, but I do not have an talbe hisotry any more.
How do I get this table again
This table contained timestamp, device, reading value over all devices.
This was a very simple way to show values of different devices.
I’m not sure if I understand the case. If you expect a database table history
, I’m not familiar with such a table to be part of openHAB jdbc persistence addon. Never seen it before. The documentation also doesn’t show anything like that. For reference: JDBC - Persistence Services | openHAB
I also don’t see how that table was dropped as part of an upgrade from openHAB. What version did you upgrade from?
You can create a view with the required columns /joins etc but it can become expensive depending on the item count and persistence strategy.
Sorry for the mistake.
I opend the wrong file where I stored my sql statements for data analyse.
I switched form fhem to openhab so this was the issue.
The problem is solved.