Jdbc persistence as default on oh2

maydo · June 3, 2017, 10:37am

Hi,

how to setup jdbc as default on paperui ?

i have installed but it wont show in paperui, see screenshot

Dim · June 3, 2017, 10:44am

Have you configured it? With which database are you using jdbc?
http://docs.openhab.org/addons/persistence/jdbc/readme.html

Ps: What version of OH2 are you running? I don’t remember that “Maturity” setting in PaperUI

maydo · June 3, 2017, 10:57pm

hi, its working now (jdbc mysql), not sure what it was.
after a few restarts, it was possible to set jdbc as default.

but run in a new issue.

the persistence service is not able to create tables for (TIME, VALUE)

java.sql.SQLException: Table 'OPENHAB.item0150' doesn't exist Query: INSERT INTO item0150 (TIME, VALUE)

its affected to all “(TIME, VALUE)” items