Eclipse Community Forums: Eclipse SmartHome » JDBC persistence service in ESH

Help

Home

Home » Archived » Eclipse SmartHome » JDBC persistence service in ESH(JDBC persistence service in ESH)

Show: Today's Messages :: Show Polls :: Message Navigator

JDBC persistence service in ESH [message #1776417]

Thu, 16 November 2017 10:03

Kiran Patil

Messages: 27
Registered: October 2015

Junior Member

Hi,

Is there a JDBC persistence service available in ESH ?

If it is available, which is the DB(sqlite, H2) to which we can configure with minimal effort and steps to achieve it.

Thanks.

Report message to a moderator

Re: JDBC persistence service in ESH [message #1776543 is a reply to message #1776417]

Fri, 17 November 2017 14:04

Stefan Triller

Messages: 29
Registered: April 2017

Junior Member

Hi Kiran,

PersistenceService's only exist in openHAB. We do not have them in ESH.

But there are plenty available as you can see here: https://github.com/openhab/openhab1-addons/tree/master/bundles/persistence

However if you want to use them in openHAB2/ESH you need the org.openhab.core.compat1x bundle with the org.openhab.core.persistence.PersistenceService interface.

Some documentation with examples on how to use them can be found here: http://docs.openhab.org/configuration/persistence.html

I do not know what you are planning to do with it but if you like to create nice graphs about item states I can recommend using the org.openhab.persistence.rrd4j service.

Regards,

Stefan

Report message to a moderator

Re: JDBC persistence service in ESH [message #1776590 is a reply to message #1776543]

Sat, 18 November 2017 07:03

Kiran Patil

Messages: 27
Registered: October 2015

Junior Member

Hi Stefan,

I would like to store item state for graphing purpose and as well as on restart all items should pick the last saved state.

I would like to know the steps to configure it to access DB, if anyone tried on ESH.

Thanks,
Kiran.

Report message to a moderator

Re: JDBC persistence service in ESH [message #1776714 is a reply to message #1776590]

Mon, 20 November 2017 17:22

Stefan Triller

Messages: 29
Registered: April 2017

Junior Member

Hi Kiran,

what you want is exactly what I described. You can store an item's state for graphing purposes or to restore it on a restart of the system via a persistence service.

But since ESH is just the framework it does not provide implementations for persistence services. If you need them, either implement your own or use a solution such as openHAB that bases on ESH and implements persistence services. I have linked the documentation in my post above.

Regards,

Stefan

Report message to a moderator