Good Tutorial On Persistence (RRD4J and JDBC-MYSQL)?

[NCO (E. Gerland)]

@rlkoshak

You can look at SQLite which is also an embedded DB (i.e. no separate server to set up) though others have had some problems getting JDBC working and I’ve yet to figure out why people are having problems or how to help.

Yes, I am one of them - see here:

Openhab2 JDBC Persistence SQLite

Hi @WayneStronach, thanks for your response. I have checked the website you mentioned. sqlite3 is installed on my raspi and I generated a db. This time it seems to work: JDBC::openConnection: Driver is available::Yank setupDataSource However, the documentation in jdbc.cfg mentiones: If no database is available it will be created, for example the url 'jdbc:h2:./testH2' creates a new DB in OpenHab Folder. So it’s strange, but it’s fixed somehow. Thanks a lot for your help!!!

I followed your recommendation about (3 Tier aproach).
I even tried H2 with the same result.
Thanks for your help, though.