[jdbc-sqlite] Time series are improperly stored/read from

[obones]

Expected Behavior

When using bindings that store future values as a time series, one must use a persistence service.
Using JDBC is indicated in the documentation as a valid candidate and so JDBC SQLite should work out of the box

Current Behavior

Sadly, JDBC SQLite does not work because the queries generated to retrieve the future values do not match the actual content in the database, as explained here:
https://community.openhab.org/t/how-to-check-that-timeseries-are-properly-generated/154090/2

Possible Solution

Use another persistence service. In my case, I used JDBC MySQL

Steps to Reproduce (for Bugs)

1. Install JDBC SQLite
2. Install a timeseries binding like OpenWeatherMap
3. Configure the persistence mode to include forecast for any relevant items
4. Use the Analyze button
5. Move to the future
6. There is no data to be displayed

Context

This was discovered while creating an Open Meteo binding.

Your Environment

• Version used: 4.2 snapshot from 04/03/2024
• Environment name and version : VSCode + Firefox
• Operating System and version : Windows 10