Continuing the discussion from Hildebrand Glowmarkt API Binding:
@DavidR - let’s continue in this thread to not hi-jack the Hildebrand Glowmark API Binding thread further.
There should be logged at least an attempt to store something. Since the tables list command is working now with:
the persistence service appears to be working and connected to SQLite. So now we can focus on why storing item values is not working.
Can you try from the console to simply update one of your items configured to be persisted? You can use command openhab:update <item> <state>. If this will show nothing in logs from JDBC persistence service, please check the configured policy and make sure the item is configured correctly to be persisted.
Changing the item state shows no log entry.
I changed the database to url=jdbc:sqlite:./testSqlite.db just in case the old database was corrupt in some way. That new file is successfully created in /var/lib/openhab/
I removed the jars from the addon directory and installed JDBC Persistence SQLite from the UI - to use M5
Still no log entry
I uninstalled JDBC Persistence SQLite using the UI
Put the jars back into addons
I’ve checked jdbc.persist for any hidden control characters. It still contains:
Strategies {
}
Items {
SmartMeter_* : strategy = everyChange
}
I created an Item just for testing
SmartMeter_test (Type=NumberItem, State=6, Label=SmartMeter_test, Category=)
which doesn’t have any links to the Glowmarkt Thing.
Still no log entry when changed.
Here is the log of jdbc startup:
2022-12-04 14:35:59.120 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : BundleComponentActivator : ComponentHolder created.
2022-12-04 14:35:59.125 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : BundleComponentActivator : ComponentHolder created.
2022-12-04 14:35:59.134 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : ConfigurableComponentHolder configuration updated for pid org.openhab.jdbc with change count 4
2022-12-04 14:35:59.137 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Dependency Manager created $000interface=org.openhab.core.items.ItemRegistry, filter=null, policy=static, cardinality=1..1, bind=null, unbind=null, updated=null, field=null, field-option=null, collection-type=null, parameter=0
2022-12-04 14:35:59.138 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Dependency Manager created $001interface=org.openhab.core.i18n.TimeZoneProvider, filter=null, policy=static, cardinality=1..1, bind=null, unbind=null, updated=null, field=null, field-option=null, collection-type=null, parameter=1
2022-12-04 14:35:59.139 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Component created: DS=DS14, implementation=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, immediate=false, default-enabled=true, factory=null, configuration-policy=optional, activate=activate, deactivate=deactivate, modified=null configuration-pid=[org.openhab.jdbc]
2022-12-04 14:35:59.141 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Component Services: scope=singleton, services=[org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService]
2022-12-04 14:35:59.142 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Component Properties: {service.config.label=JDBC Persistence Service, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.config.factory=false, service.pid=org.openhab.jdbc}
2022-12-04 14:35:59.143 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Querying state disabled
2022-12-04 14:35:59.145 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Querying state disabled
2022-12-04 14:35:59.146 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Component can not be activated since it is in state disabled
2022-12-04 14:35:59.148 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService] : Querying state disabled
2022-12-04 14:35:59.149 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Updating target filters
2022-12-04 14:35:59.150 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : No change in target property for dependency $000: currently registered: false
2022-12-04 14:35:59.152 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : No existing service listener to unregister for dependency $000
2022-12-04 14:35:59.153 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Setting target property for dependency $000 to null
2022-12-04 14:35:59.154 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : New service tracker for $000, initial active: false, previous references: {}, classFilter: (objectClass=org.openhab.core.items.ItemRegistry), initialReferenceFilter (objectClass=org.openhab.core.items.ItemRegistry)
2022-12-04 14:35:59.156 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $000 tracker reset (closed)
2022-12-04 14:35:59.159 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $000 tracking 1 SingleStatic added {org.openhab.core.items.ItemRegistry}={service.id=198, service.bundleid=149, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=33} (enter)
2022-12-04 14:35:59.161 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $000 tracking 1 SingleStatic active: false trackerOpened: false optional: false
2022-12-04 14:35:59.162 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $000 tracking 1 SingleStatic added {org.openhab.core.items.ItemRegistry}={service.id=198, service.bundleid=149, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=33} (exit)
2022-12-04 14:35:59.164 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $000 tracker opened
2022-12-04 14:35:59.165 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : registering service listener for dependency $000
2022-12-04 14:35:59.167 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : No change in target property for dependency $001: currently registered: false
2022-12-04 14:35:59.168 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : No existing service listener to unregister for dependency $001
2022-12-04 14:35:59.169 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Setting target property for dependency $001 to null
2022-12-04 14:35:59.171 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : New service tracker for $001, initial active: false, previous references: {}, classFilter: (objectClass=org.openhab.core.i18n.TimeZoneProvider), initialReferenceFilter (objectClass=org.openhab.core.i18n.TimeZoneProvider)
2022-12-04 14:35:59.172 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $001 tracker reset (closed)
2022-12-04 14:35:59.176 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $001 tracking 2 SingleStatic added {org.openhab.core.i18n.TranslationProvider, org.openhab.core.i18n.LocaleProvider, org.openhab.core.i18n.LocationProvider, org.openhab.core.i18n.TimeZoneProvider, org.openhab.core.i18n.UnitProvider}={location=51.45899074937884,-0.09990155696868898, service.id=185, service.bundleid=149, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=30, timezone=Europe/London, service.config.category=system, region=GB, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]} (enter)
2022-12-04 14:35:59.177 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $001 tracking 2 SingleStatic active: false trackerOpened: false optional: false
2022-12-04 14:35:59.179 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $001 tracking 2 SingleStatic added {org.openhab.core.i18n.TranslationProvider, org.openhab.core.i18n.LocaleProvider, org.openhab.core.i18n.LocationProvider, org.openhab.core.i18n.TimeZoneProvider, org.openhab.core.i18n.UnitProvider}={location=51.45899074937884,-0.09990155696868898, service.id=185, service.bundleid=149, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=30, timezone=Europe/London, service.config.category=system, region=GB, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]} (exit)
2022-12-04 14:35:59.180 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : dm $001 tracker opened
2022-12-04 14:35:59.182 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : registering service listener for dependency $001
2022-12-04 14:35:59.183 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Changed state from disabled to unsatisfiedReference
2022-12-04 14:35:59.184 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Component enabled
2022-12-04 14:35:59.186 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : ActivateInternal
2022-12-04 14:35:59.188 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.189 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.190 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Activating component from state unsatisfiedReference
2022-12-04 14:35:59.192 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.193 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.194 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Changed state from unsatisfiedReference to satisfied
2022-12-04 14:35:59.196 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : registration change queue [registered]
2022-12-04 14:35:59.211 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Checking constructor public org.openhab.persistence.jdbc.internal.JdbcPersistenceService(org.openhab.core.items.ItemRegistry,org.openhab.core.i18n.TimeZoneProvider)
2022-12-04 14:35:59.212 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : getReferenceClass: Looking for interface class org.openhab.core.items.ItemRegistry through loader of org.openhab.persistence.jdbc.internal.JdbcPersistenceService
2022-12-04 14:35:59.214 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : getParameterClass: Found class org.openhab.core.items.ItemRegistry
2022-12-04 14:35:59.215 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : getReferenceClass: Looking for interface class org.openhab.core.i18n.TimeZoneProvider through loader of org.openhab.persistence.jdbc.internal.JdbcPersistenceService
2022-12-04 14:35:59.217 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : getParameterClass: Found class org.openhab.core.i18n.TimeZoneProvider
2022-12-04 14:35:59.218 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Found constructor with 2 arguments : public org.openhab.persistence.jdbc.internal.JdbcPersistenceService(org.openhab.core.items.ItemRegistry,org.openhab.core.i18n.TimeZoneProvider)
2022-12-04 14:35:59.220 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : This thread collected dependencies
2022-12-04 14:35:59.221 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : getService (single component manager) dependencies collected.
2022-12-04 14:35:59.223 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Querying state satisfied
2022-12-04 14:35:59.224 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Querying state satisfied
2022-12-04 14:35:59.226 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : For dependency $000, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=198, service.bundleid=149, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=33}] service: [null]]]
2022-12-04 14:35:59.228 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : For dependency $001, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.i18n.TranslationProvider, org.openhab.core.i18n.LocaleProvider, org.openhab.core.i18n.LocationProvider, org.openhab.core.i18n.TimeZoneProvider, org.openhab.core.i18n.UnitProvider}={location=51.45899074937884,-0.09990155696868898, service.id=185, service.bundleid=149, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=30, timezone=Europe/London, service.config.category=system, region=GB, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [null]]]
2022-12-04 14:35:59.230 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : getting activate: activate
2022-12-04 14:35:59.231 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Locating method activate in class org.openhab.persistence.jdbc.internal.JdbcPersistenceService
2022-12-04 14:35:59.234 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Declared Method org.openhab.persistence.jdbc.internal.JdbcPersistenceService.activate([interface org.osgi.service.component.ComponentContext]) not found
2022-12-04 14:35:59.236 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Found activate method: public void org.openhab.persistence.jdbc.internal.JdbcPersistenceService.activate(org.osgi.framework.BundleContext,java.util.Map)
2022-12-04 14:35:59.237 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : invoking activate: activate: parameters [org.eclipse.osgi.internal.framework.BundleContextImpl, org.apache.felix.scr.impl.helper.ReadOnlyDictionary]
2022-12-04 14:35:59.239 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2022-12-04 14:35:59.241 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2022-12-04 14:35:59.248 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2022-12-04 14:35:59.250 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 8
2022-12-04 14:35:59.255 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - No jdbc:user parameter defined in jdbc.cfg
2022-12-04 14:35:59.256 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - No jdbc:password parameter defined in jdbc.cfg.
2022-12-04 14:35:59.258 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=null
2022-12-04 14:35:59.259 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? false
2022-12-04 14:35:59.261 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:sqlite:./testSqlite.db
2022-12-04 14:35:59.263 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'sqlite'
2022-12-04 14:35:59.264 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.internal.db.JdbcSqliteDAO'
2022-12-04 14:35:59.278 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2022-12-04 14:35:59.280 [DEBUG] [tence.jdbc.internal.db.JdbcSqliteDAO] - JDBC::initSqlQueries: 'JdbcSqliteDAO'
2022-12-04 14:35:59.282 [DEBUG] [tence.jdbc.internal.db.JdbcSqliteDAO] - JDBC::initSqlTypes: Initialize the type array
2022-12-04 14:35:59.283 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBDAO ClassName=org.openhab.persistence.jdbc.internal.db.JdbcSqliteDAO
2022-12-04 14:35:59.285 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
2022-12-04 14:35:59.287 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: load JDBC-driverClass was successful: 'org.sqlite.JDBC'
2022-12-04 14:35:59.289 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration complete. service=jdbc
2022-12-04 14:35:59.290 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB
2022-12-04 14:35:59.292 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection isDriverAvailable: true
2022-12-04 14:35:59.293 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2022-12-04 14:35:59.610 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::setDbConnected true
2022-12-04 14:35:59.611 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::initAfterFirstDbConnection: Initializing step, after db is connected.
2022-12-04 14:35:59.633 [DEBUG] [tence.jdbc.internal.utils.DbMetaData] - dbMajorVersion = '3'
2022-12-04 14:35:59.634 [DEBUG] [tence.jdbc.internal.utils.DbMetaData] - dbMinorVersion = '0'
2022-12-04 14:35:59.636 [DEBUG] [tence.jdbc.internal.utils.DbMetaData] - driverMajorVersion = '1'
2022-12-04 14:35:59.638 [DEBUG] [tence.jdbc.internal.utils.DbMetaData] - driverMinorVersion = '1'
2022-12-04 14:35:59.640 [DEBUG] [tence.jdbc.internal.utils.DbMetaData] - dbProductName = 'SQLite'
2022-12-04 14:35:59.644 [DEBUG] [tence.jdbc.internal.utils.DbMetaData] - dbProductVersion = '3.16.1'
2022-12-04 14:35:59.647 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::pingDB asking db for name as absolutely first db action, after connection is established.
2022-12-04 14:35:59.684 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::checkDBAcessability, first try connection: true
2022-12-04 14:35:59.689 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::createItemsTableIfNot
2022-12-04 14:35:59.691 [DEBUG] [tence.jdbc.internal.db.JdbcSqliteDAO] - JDBC::doCreateItemsTableIfNot sql=CREATE TABLE IF NOT EXISTS items (ItemId INTEGER PRIMARY KEY AUTOINCREMENT, ItemName VARCHAR(500) NOT NULL)
2022-12-04 14:35:59.694 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getItemIDTableNames
2022-12-04 14:35:59.696 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetItemIDTableNames sql=SELECT ItemId, ItemName FROM items
2022-12-04 14:35:59.702 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.704 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig: configuration complete for service=jdbc.
2022-12-04 14:35:59.706 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : invoked activate: activate
2022-12-04 14:35:59.709 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Set implementation object for component
2022-12-04 14:35:59.711 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(378)] : Changed state from satisfied to active
2022-12-04 14:35:59.714 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.716 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.717 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.720 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.723 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.725 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::getName: returning name 'jdbc' for queryable persistence service.
2022-12-04 14:35:59.728 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Dependency Manager created $000interface=org.openhab.core.persistence.PersistenceServiceRegistry, filter=null, policy=static, cardinality=1..1, bind=null, unbind=null, updated=null, field=null, field-option=null, collection-type=null, parameter=0
2022-12-04 14:35:59.730 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Component created: DS=DS14, implementation=org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension, immediate=false, default-enabled=true, factory=null, configuration-policy=optional, activate=activate, deactivate=deactivate, modified=null configuration-pid=[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension]
2022-12-04 14:35:59.732 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Component Services: scope=singleton, services=[org.openhab.core.io.console.extensions.ConsoleCommandExtension]
2022-12-04 14:35:59.734 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Component Properties: {}
2022-12-04 14:35:59.736 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Querying state disabled
2022-12-04 14:35:59.739 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Querying state disabled
2022-12-04 14:35:59.740 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Component can not be activated since it is in state disabled
2022-12-04 14:35:59.742 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension] : Querying state disabled
2022-12-04 14:35:59.745 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Updating target filters
2022-12-04 14:35:59.748 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : No change in target property for dependency $000: currently registered: false
2022-12-04 14:35:59.750 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : No existing service listener to unregister for dependency $000
2022-12-04 14:35:59.752 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Setting target property for dependency $000 to null
2022-12-04 14:35:59.754 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : New service tracker for $000, initial active: false, previous references: {}, classFilter: (objectClass=org.openhab.core.persistence.PersistenceServiceRegistry), initialReferenceFilter (objectClass=org.openhab.core.persistence.PersistenceServiceRegistry)
2022-12-04 14:35:59.756 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : dm $000 tracker reset (closed)
2022-12-04 14:35:59.761 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : dm $000 tracking 1 SingleStatic added {org.openhab.core.config.core.ConfigOptionProvider, org.openhab.core.persistence.PersistenceServiceRegistry}={service.id=345, service.bundleid=210, service.scope=bundle, service.config.label=Persistence, component.name=org.openhab.core.persistence.internal.PersistenceServiceRegistryImpl, component.id=235, service.config.factory=false, default=rrd4j, service.config.category=system, service.pid=[org.openhab.persistence, org.openhab.persistence], service.config.description.uri=system:persistence} (enter)
2022-12-04 14:35:59.763 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : dm $000 tracking 1 SingleStatic active: false trackerOpened: false optional: false
2022-12-04 14:35:59.765 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : dm $000 tracking 1 SingleStatic added {org.openhab.core.config.core.ConfigOptionProvider, org.openhab.core.persistence.PersistenceServiceRegistry}={service.id=345, service.bundleid=210, service.scope=bundle, service.config.label=Persistence, component.name=org.openhab.core.persistence.internal.PersistenceServiceRegistryImpl, component.id=235, service.config.factory=false, default=rrd4j, service.config.category=system, service.pid=[org.openhab.persistence, org.openhab.persistence], service.config.description.uri=system:persistence} (exit)
2022-12-04 14:35:59.766 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : dm $000 tracker opened
2022-12-04 14:35:59.768 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : registering service listener for dependency $000
2022-12-04 14:35:59.769 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Changed state from disabled to unsatisfiedReference
2022-12-04 14:35:59.771 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Component enabled
2022-12-04 14:35:59.772 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : ActivateInternal
2022-12-04 14:35:59.774 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.775 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.777 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Activating component from state unsatisfiedReference
2022-12-04 14:35:59.778 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.779 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Querying state unsatisfiedReference
2022-12-04 14:35:59.781 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Changed state from unsatisfiedReference to satisfied
2022-12-04 14:35:59.782 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : registration change queue [registered]
2022-12-04 14:35:59.790 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Checking constructor public org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(org.openhab.core.persistence.PersistenceServiceRegistry)
2022-12-04 14:35:59.792 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : getReferenceClass: Looking for interface class org.openhab.core.persistence.PersistenceServiceRegistry through loader of org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension
2022-12-04 14:35:59.793 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : getParameterClass: Found class org.openhab.core.persistence.PersistenceServiceRegistry
2022-12-04 14:35:59.795 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Found constructor with 1 arguments : public org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(org.openhab.core.persistence.PersistenceServiceRegistry)
2022-12-04 14:35:59.797 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : This thread collected dependencies
2022-12-04 14:35:59.798 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : getService (single component manager) dependencies collected.
2022-12-04 14:35:59.800 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Querying state satisfied
2022-12-04 14:35:59.801 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Querying state satisfied
2022-12-04 14:35:59.803 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : For dependency $000, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.config.core.ConfigOptionProvider, org.openhab.core.persistence.PersistenceServiceRegistry}={service.id=345, service.bundleid=210, service.scope=bundle, service.config.label=Persistence, component.name=org.openhab.core.persistence.internal.PersistenceServiceRegistryImpl, component.id=235, service.config.factory=false, default=rrd4j, service.config.category=system, service.pid=[org.openhab.persistence, org.openhab.persistence], service.config.description.uri=system:persistence}] service: [null]]]
2022-12-04 14:35:59.806 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : getting activate: activate
2022-12-04 14:35:59.808 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Locating method activate in class org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension
2022-12-04 14:35:59.811 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Declared Method org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension.activate([interface org.osgi.service.component.ComponentContext]) not found
2022-12-04 14:35:59.812 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Locating method activate in class org.openhab.core.io.console.extensions.AbstractConsoleCommandExtension
2022-12-04 14:35:59.814 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Declared Method org.openhab.core.io.console.extensions.AbstractConsoleCommandExtension.activate([interface org.osgi.service.component.ComponentContext]) not found
2022-12-04 14:35:59.816 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Locating method activate in class java.lang.Object
2022-12-04 14:35:59.817 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Declared Method java.lang.Object.activate([interface org.osgi.service.component.ComponentContext]) not found
2022-12-04 14:35:59.819 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : activate method [activate] not found, ignoring
2022-12-04 14:35:59.820 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Set implementation object for component
2022-12-04 14:35:59.822 [DEBUG] [nternal.console.JdbcCommandExtension] - bundle org.openhab.persistence.jdbc:3.4.0.202212041116 (306)[org.openhab.persistence.jdbc.internal.console.JdbcCommandExtension(379)] : Changed state from satisfied to active
Anything else to try?
I’ve just added a single item to the persist file, and it is successfully persisted.
Strategies {
}
Items {
Test1 : strategy = everyChange
SmartMeter_* : strategy = everyChange
}
So it seems that it is the SmartMeter_* that’s the problem
I’ll investigate further.
Yes, that will persist all members of the group “SmartMeter_”.
Can you try also with a DateTime item? I believe this was the original problem that I tried to fix, so it would be nice with a confirmation if it works.
So (as usual) it’s my misunderstanding.
I named all the items beginning with SmartMeter_ and expected SmartMeter_* to be the filter.
Having just read the docs more closely, this syntax is only for groups, as you pointed out.
Sorry.
I think the requirement from the Glowmarkt binding was “… persistence service
that supports updating of past Item data via ModifiablePersistenceService .”
But I have just tried a DateTime item. Named it TestTime, added it to jdbc.persist and changed the date.
It is stored in the database, as confirmed by API Explorer GET /persitence/items
but trying to GET the item results in a error:
GET /persitence/items/TestTime
"{\"error\":{\"message\":\"Date of type java.lang.Integer is not supported\",\"http-code\":500,\"exception\":{\"class\":\"java.lang.UnsupportedOperationException\",\"message\":\"Date of type java.lang.Integer is not supported\",\"localized-message\":\"Date of type java.lang.Integer is not supported\"}}}"
I really appreciate all the help.
My goal was to get the Glowmarkt binding working and I chose SQLite because it looked like the easiest option. I do not use SQLite for anything else.