raspberry pi OPENHABIAN 3.1.0
I am tring to understand if it is possible to sent data to mssql sever with JDBC Persistence? I tried to do it with jdbc driver but no success. I find posts 3 years ago but …
I will appreciateany help
thnx in advance
Share a bit more information about your configuration like
- what is the name of the jar file that you installed ?
- is it active ?
- how does your JDBC configuration look like ?
- is there any ( error ) message related to JDBC in the openhab.log file ?
I installed JDBC Persistence MySQL
I dont know if it is active
jdbc.cfg looks like:
url=jdbc:mysql://my_IP:1433/database_name
user=username
password=mypassword
tableNamePrefix=Item
jdbc.persist:
// persistence strategies have a name and a definition and are referred to in the "Items" section
Strategies {
// if no strategy is specified for an item entry below, the default list will be used
everyHour : "0 0 * * * ?"
everyDay : "0 0 0 * * ?"
every5Minutes : "0 0/5 * 1/1 * ? *"
default = everyChange
}
Items {
// persist all items once a day and on every change and restore them from the db at startup
* : strategy = everyChange, everyDay, restoreOnStartup
// additionally, persist all temperature and weather values every hour
pcroom_sensor_tm* : strategy = everyChange, restoreOnStartup
}
in runtime.cfg i added this line
org.openhab.core.persistence:default=jdbc
The only message that I can see in log view is when I make changes in jdbc.cfg and save it.
2021-07-09 01:05:01.529 [ERROR] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (294)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(322)] : The activate method has thrown an exception
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2021-07-09 01:04:01.322 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
2021-07-09 01:04:01.327 [WARN ] [.zaxxer.hikari.util.DriverDataSource] - Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
From the title of this thread and your initial post my understanding is that you would like to connect to Microsoft SQL server.
According to
you installed the MySQL JDBC jar file. I think that will not work. I am not an expert on that stuff but as far as I understand the JDBC jar files for the different database providers contain provider specific information on how to connect to a db and other specific stuff.
So you need to install the Microsoft specific one.
I would try this one: Download - JDBC Driver for SQL Server | Microsoft Learn and put the Java 11 related file ( mssql-jdbc-9.2.1.jre11.jar ) into the /usr/share/openhab/addons folder.
( then a restart of openhab may be required ).
During restart a set of errors is shown in the openhab.log file like:
2021-07-09 07:16:05.644 [WARN ] [org.apache.felix.fileinstall ] - Error while starting bundle: file:/usr/share/openhab/addons/mssql-jdbc-9.2.1.jre11.jar
org.osgi.framework.BundleException: Could not resolve module: com.microsoft.sqlserver.mssql-jdbc [220]
Unresolved requirement: Import-Package: com.azure.core.credential; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.core.http; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.core.http.policy; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.core.util; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.identity; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.security.keyvault.keys; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.security.keyvault.keys.cryptography; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.security.keyvault.keys.cryptography.models; resolution:="optional"
Unresolved requirement: Import-Package: com.azure.security.keyvault.keys.models; resolution:="optional"
Unresolved requirement: Import-Package: com.microsoft.aad.msal4j; version="[1.7.0,2.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.antlr.v4.runtime; version="[4.7.0,5.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.antlr.v4.runtime.atn; version="[4.7.0,5.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.antlr.v4.runtime.dfa; version="[4.7.0,5.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.bouncycastle.jce.provider; version="[1.65.0,2.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.bouncycastle.openssl; version="[1.65.0,2.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.bouncycastle.openssl.jcajce; version="[1.65.0,2.0.0)"; resolution:="optional"
Unresolved requirement: Import-Package: org.osgi.service.jdbc; version="[1.0.0,2.0.0)"
at org.eclipse.osgi.container.Module.start(Module.java:444) ~[org.eclipse.osgi-3.12.100.jar:?]
at org.eclipse.osgi.internal.framework.EquinoxBundle.start(EquinoxBundle.java:383) ~[org.eclipse.osgi-3.12.100.jar:?]
at org.apache.felix.fileinstall.internal.DirectoryWatcher.startBundle(DirectoryWatcher.java:1260) [bundleFile:3.6.4]
at org.apache.felix.fileinstall.internal.DirectoryWatcher.startBundles(DirectoryWatcher.java:1233) [bundleFile:3.6.4]
at org.apache.felix.fileinstall.internal.DirectoryWatcher.startAllBundles(DirectoryWatcher.java:1221) [bundleFile:3.6.4]
at org.apache.felix.fileinstall.internal.DirectoryWatcher.doProcess(DirectoryWatcher.java:515) [bundleFile:3.6.4]
at org.apache.felix.fileinstall.internal.DirectoryWatcher.process(DirectoryWatcher.java:365) [bundleFile:3.6.4]
at org.apache.felix.fileinstall.internal.DirectoryWatcher.run(DirectoryWatcher.java:316) [bundleFile:3.6.4]
Because of the optional at the end I would interprete this as depending on what you would like to do resp. depending on what is required for your database instance it might be not a problem or it will be a problem. That then means that further jar files need to be put into that folder.
Log in to the openhab console ( openhab-cli console ). And enter
list | grep -i microsoft
State could be installed if it is found but not active yet.
To make it active it also needs to be configured.
With regard to configure the JDBC connection string have a look to
295 x Active x 80 x 9.2.1 x Microsoft JDBC Driver for SQL Server
I added the jar files and i took the same erros in logview with you. Also i unistall mysql persistence.
Should I rename my jdbc.persist file with stategies and the jdbc.cfg files?
I follow the microsoft documention and edited as follow:
url=jdbc:sqlserver://192.168.1.100:1433;databaseName=mydatabase;user=myusername;password=mypassword
that i have to do next?
You need to use these names. The content have to reflect the sqlserver parameter.
Set log level for org.openhab.binding.jdbc to DEBUG and have a look to the openhab.log file.
So when save my config file i get this error
2021-07-11 00:40:45.443 [WARN ] [ence.internal.PersistenceManagerImpl] - bundle org.openhab.core.persistence:3.1.0 (210)[org.openhab.core.persistence.internal.PersistenceManagerImpl(213)] : Could not get service from ref {org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService}={service.id=563, service.bundleid=302, service.scope=bundle, user=myusername, tableNamePrefix=Item, url=jdbc:sqlserver://192.168.1.100:1433, tableIdDigitCount=0, component.name=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, service.config.label=JDBC Persistence Service, component.id=320, service.config.factory=false, password=mypass, tableUseRealItemNames=false, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.pid=[org.openhab.jdbc, org.openhab.jdbc]}
2021-07-11 00:40:45.445 [WARN ] [ence.internal.PersistenceManagerImpl] - bundle org.openhab.core.persistence:3.1.0 (210)[org.openhab.core.persistence.internal.PersistenceManagerImpl(213)] : DependencyManager : invokeBindMethod : Service not available from service registry for ServiceReference {org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService}={service.id=563, service.bundleid=302, service.scope=bundle, user=myusername, tableNamePrefix=Item, url=jdbc:sqlserver://192.168.1.100:1433, tableIdDigitCount=0, component.name=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, service.config.label=JDBC Persistence Service, component.id=320, service.config.factory=false, password=mypass, tableUseRealItemNames=false, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.pid=[org.openhab.jdbc, org.openhab.jdbc]} for reference PersistenceService
2021-07-11 00:40:45.449 [ERROR] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : The activate method has thrown an exception
java.lang.StringIndexOutOfBoundsException: begin 0, end -1, length 0
at java.lang.String.checkBoundsBeginEnd(String.java:3319) ~[?:?]
at java.lang.String.substring(String.java:1874) ~[?:?]
at org.openhab.persistence.jdbc.utils.StringUtilsExt.stringBeforeSubstr(StringUtilsExt.java:220) ~[?:?]
at org.openhab.persistence.jdbc.utils.StringUtilsExt.parseJdbcURL(StringUtilsExt.java:165) ~[?:?]
at org.openhab.persistence.jdbc.utils.StringUtilsExt.parseJdbcURL(StringUtilsExt.java:65) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.updateConfig(JdbcConfiguration.java:92) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.<init>(JdbcConfiguration.java:73) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.updateConfig(JdbcPersistenceService.java:218) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.activate(JdbcPersistenceService.java:83) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:244) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:685) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:529) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:318) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:308) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:354) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:115) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:1000) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:973) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:918) [bundleFile:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse$1.run(ServiceFactoryUse.java:216) [org.eclipse.osgi-3.16.200.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.factoryGetService(ServiceFactoryUse.java:213) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.getService(ServiceFactoryUse.java:114) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceConsumer$2.getService(ServiceConsumer.java:48) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.getService(ServiceRegistrationImpl.java:547) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.getService(ServiceRegistry.java:533) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.getService(BundleContextImpl.java:656) [org.eclipse.osgi-3.16.200.jar:?]
at org.apache.felix.scr.impl.manager.SingleRefPair.getServiceObject(SingleRefPair.java:88) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BindMethod.getServiceObject(BindMethod.java:675) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.getServiceObject(DependencyManager.java:2556) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.doInvokeBindMethod(DependencyManager.java:2075) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.invokeBindMethod(DependencyManager.java:2058) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.invokeBindMethod(SingleComponentManager.java:443) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.addedService(DependencyManager.java:333) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.addedService(DependencyManager.java:301) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1200) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1121) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:928) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:864) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1152) [bundleFile:?]
at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:114) [bundleFile:?]
at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:120) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:957) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:234) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:151) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:936) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:873) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:141) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:261) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:496) [org.eclipse.osgi-3.16.200.jar:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:929) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.register(AbstractComponentManager.java:915) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:133) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.registerService(AbstractComponentManager.java:984) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:752) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.reconfigure(SingleComponentManager.java:750) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.reconfigure(SingleComponentManager.java:684) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ConfigurableComponentHolder.configurationUpdated(ConfigurableComponentHolder.java:437) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegionConfigurationSupport.configurationEvent(RegionConfigurationSupport.java:347) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegionConfigurationSupport$2.configurationEvent(RegionConfigurationSupport.java:115) [bundleFile:?]
at org.apache.felix.cm.impl.ConfigurationManager$FireConfigurationEvent.sendEvent(ConfigurationManager.java:1720) [bundleFile:?]
at org.apache.felix.cm.impl.ConfigurationManager$FireConfigurationEvent.run(ConfigurationManager.java:1662) [bundleFile:?]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:122) [bundleFile:?]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:84) [bundleFile:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
Can you try with a minimal connection string and put username and password on extra entries
Did you set log level for org.openhab.binding.jdbc to DEBUG ?
In this command in console there is no error
log:set DEBUG org.openhab.binding.jdbc
But in list -s I cant find it.
295 │ Active │ 80 │ 9.2.1 │ com.microsoft.sqlserver.mssql-jdbc
296 │ Active │ 80 │ 1.0.0.201505202023 │ org.osgi.service.jdbc
300 │ Active │ 80 │ 8.0.22 │ com.mysql.cj
301 │ Active │ 80 │ 3.27.0.GA │ javassist
302 │ Waiting │ 80 │ 3.1.0 │ org.openhab.persistence.jdbc
303 │ Active │ 80 │ 3.1.0 │ org.openhab.binding.exec
Try to set org.openhab.persistence.jdbc to DEBUG. May be org.osgi.service.jdbc, too.
I am not an expert in this area. If that does not help to identify the root cause I am out of ideas.
It could be that the binding/service needs to be enhanced for mssql DB.
thnx for your help but Is a chaos for me
2021-07-11 13:47:25.499 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : ConfigurableComponentHolder configuration updated for pid org.openhab.jdbc with change count 26
2021-07-11 13:47:25.502 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.503 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.505 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : No modified method, cannot update dynamically
2021-07-11 13:47:25.507 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Deactivating and Activating to reconfigure class="afterFrom marked"> from configuration
2021-07-11 13:47:25.509 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.510 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Deactivating component
2021-07-11 13:47:25.512 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : registration change queue [unregistered]
2021-07-11 13:47:25.515 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : This thread collected dependencies
2021-07-11 13:47:25.516 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : getService (single component manager) dependencies collected.
2021-07-11 13:47:25.518 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.519 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.521 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : For dependency $000, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=191, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=25}] service: [org.openhab.core.internal.items.ItemRegistryImpl@3be7cf33]]]
2021-07-11 13:47:25.523 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : 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=37.93372643148088,23.637750148773197, service.id=178, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=22, timezone=Europe/Athens, service.config.category=system, region=GR, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [org.openhab.core.internal.i18n.I18nProviderImpl@435d1320]]]
2021-07-11 13:47:25.525 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : invoking activate: activate: parameters [org.eclipse.osgi.internal.framework.BundleContextImpl, org.apache.felix.scr.impl.helper.ReadOnlyDictionary]
2021-07-11 13:47:25.527 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2021-07-11 13:47:25.528 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2021-07-11 13:47:25.529 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2021-07-11 13:47:25.531 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 14
2021-07-11 13:47:25.532 [ERROR] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : The activate method has thrown an exception
java.lang.StringIndexOutOfBoundsException: begin 0, end -1, length 0
at java.lang.String.checkBoundsBeginEnd(String.java:3319) ~[?:?]
at java.lang.String.substring(String.java:1874) ~[?:?]
at org.openhab.persistence.jdbc.utils.StringUtilsExt.stringBeforeSubstr(StringUtilsExt.java:220) ~[?:?]
at org.openhab.persistence.jdbc.utils.StringUtilsExt.parseJdbcURL(StringUtilsExt.java:165) ~[?:?]
at org.openhab.persistence.jdbc.utils.StringUtilsExt.parseJdbcURL(StringUtilsExt.java:65) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.updateConfig(JdbcConfiguration.java:92) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.<init>(JdbcConfiguration.java:73) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.updateConfig(JdbcPersistenceService.java:218) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.activate(JdbcPersistenceService.java:83) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:244) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:685) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:529) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:318) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:308) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:354) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:115) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:1000) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:973) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:918) [bundleFile:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse$1.run(ServiceFactoryUse.java:216) [org.eclipse.osgi-3.16.200.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.factoryGetService(ServiceFactoryUse.java:213) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.getService(ServiceFactoryUse.java:114) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceConsumer$2.getService(ServiceConsumer.java:48) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.getService(ServiceRegistrationImpl.java:547) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.getService(ServiceRegistry.java:533) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.getService(BundleContextImpl.java:656) [org.eclipse.osgi-3.16.200.jar:?]
at org.apache.felix.scr.impl.manager.SingleRefPair.getServiceObject(SingleRefPair.java:88) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BindMethod.getServiceObject(BindMethod.java:675) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.getServiceObject(DependencyManager.java:2556) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.invokeUnbindMethod(DependencyManager.java:2201) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.invokeUnbindMethod(SingleComponentManager.java:466) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.removedService(DependencyManager.java:395) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.removedService(DependencyManager.java:301) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerRemoved(ServiceTracker.java:1226) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerRemoved(ServiceTracker.java:1121) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.untrack(ServiceTracker.java:981) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1160) [bundleFile:?]
at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:114) [bundleFile:?]
at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:120) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:957) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:234) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:151) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:936) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:873) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.unregister(ServiceRegistrationImpl.java:241) [org.eclipse.osgi-3.16.200.jar:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.unregister(AbstractComponentManager.java:952) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.unregister(AbstractComponentManager.java:915) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:140) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.unregisterService(AbstractComponentManager.java:994) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.doDeactivate(AbstractComponentManager.java:844) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.deactivateInternal(AbstractComponentManager.java:825) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.reconfigure(SingleComponentManager.java:738) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.reconfigure(SingleComponentManager.java:684) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ConfigurableComponentHolder.configurationUpdated(ConfigurableComponentHolder.java:437) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegionConfigurationSupport.configurationEvent(RegionConfigurationSupport.java:347) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegionConfigurationSupport$2.configurationEvent(RegionConfigurationSupport.java:115) [bundleFile:?]
at org.apache.felix.cm.impl.ConfigurationManager$FireConfigurationEvent.sendEvent(ConfigurationManager.java:1720) [bundleFile:?]
at org.apache.felix.cm.impl.ConfigurationManager$FireConfigurationEvent.run(ConfigurationManager.java:1662) [bundleFile:?]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:122) [bundleFile:?]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:84) [bundleFile:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
2021-07-11 13:47:25.544 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : DependencyManager: $001 close component unbinding from org.apache.felix.scr.impl.manager.ComponentContextImpl@373d64d3 at tracking count 2 refpairs: [[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=37.93372643148088,23.637750148773197, service.id=178, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=22, timezone=Europe/Athens, service.config.category=system, region=GR, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [org.openhab.core.internal.i18n.I18nProviderImpl@435d1320]]]
2021-07-11 13:47:25.546 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : DependencyManager: $000 close component unbinding from org.apache.felix.scr.impl.manager.ComponentContextImpl@373d64d3 at tracking count 1 refpairs: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=191, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=25}] service: [org.openhab.core.internal.items.ItemRegistryImpl@3be7cf33]]]
2021-07-11 13:47:25.547 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Failed creating the component instance; see log for reason
2021-07-11 13:47:25.549 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.550 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Changed state from satisfied to satisfied
2021-07-11 13:47:25.554 [WARN ] [ence.internal.PersistenceManagerImpl] - bundle org.openhab.core.persistence:3.1.0 (210)[org.openhab.core.persistence.internal.PersistenceManagerImpl(213)] : Could not get service from ref {org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService}={service.id=567, service.bundleid=302, service.scope=bundle, user=myusername, tableNamePrefix=Item, url=jdbc:sqlserver://myip:1433, tableIdDigitCount=0, component.name=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, service.config.label=JDBC Persistence Service, component.id=320, service.config.factory=false, password=mypass, databaseName=mydatabase, tableUseRealItemNames=true, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.pid=[org.openhab.jdbc, org.openhab.jdbc]}
2021-07-11 13:47:25.556 [WARN ] [ence.internal.PersistenceManagerImpl] - bundle org.openhab.core.persistence:3.1.0 (210)[org.openhab.core.persistence.internal.PersistenceManagerImpl(213)] : DependencyManager : invokeUnbindMethod : Service not available from service registry for ServiceReference {org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService}={service.id=567, service.bundleid=302, service.scope=bundle, user=myusername, tableNamePrefix=Item, url=jdbc:sqlserver://myip:1433, tableIdDigitCount=0, component.name=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, service.config.label=JDBC Persistence Service, component.id=320, service.config.factory=false, password=mypass, databaseName=mydatabase, tableUseRealItemNames=true, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.pid=[org.openhab.jdbc, org.openhab.jdbc]} for reference PersistenceService
2021-07-11 13:47:25.558 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : This thread collected dependencies
2021-07-11 13:47:25.559 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : getService (single component manager) dependencies collected.
2021-07-11 13:47:25.560 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.562 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 13:47:25.564 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : For dependency $000, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=191, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=25}] service: [org.openhab.core.internal.items.ItemRegistryImpl@3be7cf33]]]
2021-07-11 13:47:25.565 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : 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=37.93372643148088,23.637750148773197, service.id=178, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=22, timezone=Europe/Athens, service.config.category=system, region=GR, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [org.openhab.core.internal.i18n.I18nProviderImpl@435d1320]]]
2021-07-11 13:47:25.568 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : invoking activate: activate: parameters [org.eclipse.osgi.internal.framework.BundleContextImpl, org.apache.felix.scr.impl.helper.ReadOnlyDictionary]
2021-07-11 13:47:25.569 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2021-07-11 13:47:25.570 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2021-07-11 13:47:25.572 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2021-07-11 13:47:25.573 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 14
2021-07-11 13:47:25.575 [ERROR] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : The activate method has thrown an exception
This is an extract from the source code ( just a snippet; code continues after the last line of code:
public JdbcConfiguration(Map<Object, Object> configuration) {
logger.debug("JDBC::JdbcConfiguration");
valid = updateConfig(configuration);
}
private boolean updateConfig(Map<Object, Object> config) {
configuration = config;
logger.debug("JDBC::updateConfig: configuration size = {}", configuration.size());
String user = (String) configuration.get("user");
String password = (String) configuration.get("password");
// mandatory url
String url = (String) configuration.get("url");
if (url == null) {
logger.error("Mandatory url parameter is missing in configuration!");
return false;
}
Properties parsedURL = StringUtilsExt.parseJdbcURL(url);
if (user == null || user.isBlank()) {
logger.debug("No jdbc:user parameter defined in jdbc.cfg");
}
if (password == null || password.isBlank()) {
logger.debug("No jdbc:password parameter defined in jdbc.cfg.");
}
if (url.isBlank()) {
logger.debug(
"JDBC url is missing - please configure in jdbc.cfg like 'jdbc:<service>:<host>[:<port>;<attributes>]'");
return false;
}
if ("false".equalsIgnoreCase(parsedURL.getProperty("parseValid"))) {
Enumeration<?> en = parsedURL.propertyNames();
String enstr = "";
for (Object key : Collections.list(en)) {
enstr += key + " = " + parsedURL.getProperty("" + key) + "\n";
}
logger.warn(
"JDBC url is not well formatted: {}\nPlease configure in openhab.cfg like 'jdbc:<service>:<host>[:<port>;<attributes>]'",
enstr);
return false;
}
logger.debug("JDBC::updateConfig: user={}", user);
logger.debug("JDBC::updateConfig: password exists? {}", password != null && !password.isBlank());
logger.debug("JDBC::updateConfig: url={}", url);
In your openhab.log output we can see
JDBC::updateConfig: configuration size = 14
but not the next one:
"JDBC::updateConfig: user="
So I think the exception is raised somewhere in between.
I make some progress and get some extra debug messages
2021-07-11 16:10:07.777 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : ConfigurableComponentHolder configuration updated for pid org.openhab.jdbc with change count 52
2021-07-11 16:10:07.779 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.781 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.783 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : No modified method, cannot update dynamically
2021-07-11 16:10:07.784 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Deactivating and Activating to reconfigure class="afterFrom marked"> from configuration
2021-07-11 16:10:07.786 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.787 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Deactivating component
2021-07-11 16:10:07.790 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : registration change queue [unregistered]
2021-07-11 16:10:07.807 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : This thread collected dependencies
2021-07-11 16:10:07.809 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : getService (single component manager) dependencies collected.
2021-07-11 16:10:07.811 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.813 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.816 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : For dependency $000, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=194, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=25}] service: [org.openhab.core.internal.items.ItemRegistryImpl@4bde279b]]]
2021-07-11 16:10:07.819 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : 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=37.93372643148088,23.637750148773197, service.id=181, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=22, timezone=Europe/Athens, service.config.category=system, region=GR, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [org.openhab.core.internal.i18n.I18nProviderImpl@1f9e5808]]]
2021-07-11 16:10:07.822 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : invoking activate: activate: parameters [org.eclipse.osgi.internal.framework.BundleContextImpl, org.apache.felix.scr.impl.helper.ReadOnlyDictionary]
2021-07-11 16:10:07.824 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2021-07-11 16:10:07.827 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2021-07-11 16:10:07.829 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2021-07-11 16:10:07.832 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 14
2021-07-11 16:10:07.835 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=myusername
2021-07-11 16:10:07.837 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? true
2021-07-11 16:10:07.839 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:sqlserver://192.168.1.100:1433/databaseName=mydatabase
2021-07-11 16:10:07.841 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'sqlserver'
2021-07-11 16:10:07.843 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.db.JdbcSqlserverDAO'
2021-07-11 16:10:07.847 [WARN ] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: no Configuration for serviceName 'sqlserver' found. ClassNotFoundException: org.openhab.persistence.jdbc.db.JdbcSqlserverDAO cannot be found by org.openhab.persistence.jdbc_3.1.0
2021-07-11 16:10:07.849 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: using default Database Configuration: JdbcBaseDAO !!
2021-07-11 16:10:07.851 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2021-07-11 16:10:07.854 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlQueries: 'JdbcBaseDAO'
2021-07-11 16:10:07.856 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBConfig done
2021-07-11 16:10:07.858 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableNamePrefix=Item
2021-07-11 16:10:07.860 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableUseRealItemNames=false
2021-07-11 16:10:07.862 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableIdDigitCount=0
2021-07-11 16:10:07.864 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
2021-07-11 16:10:07.868 [ERROR] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : The activate method has thrown an exception
java.lang.NullPointerException: null
at java.lang.Class.forName0(Native Method) ~[?:?]
at java.lang.Class.forName(Class.java:315) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.testJDBCDriver(JdbcConfiguration.java:287) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.updateConfig(JdbcConfiguration.java:221) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcConfiguration.<init>(JdbcConfiguration.java:73) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.updateConfig(JdbcPersistenceService.java:218) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.activate(JdbcPersistenceService.java:83) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:244) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:685) ~[bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:529) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:318) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:308) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:354) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:115) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:1000) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:973) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:918) [bundleFile:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse$1.run(ServiceFactoryUse.java:216) [org.eclipse.osgi-3.16.200.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.factoryGetService(ServiceFactoryUse.java:213) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceFactoryUse.getService(ServiceFactoryUse.java:114) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceConsumer$2.getService(ServiceConsumer.java:48) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.getService(ServiceRegistrationImpl.java:547) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.getService(ServiceRegistry.java:533) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.getService(BundleContextImpl.java:656) [org.eclipse.osgi-3.16.200.jar:?]
at org.apache.felix.scr.impl.manager.SingleRefPair.getServiceObject(SingleRefPair.java:88) [bundleFile:?]
at org.apache.felix.scr.impl.inject.methods.BindMethod.getServiceObject(BindMethod.java:675) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.getServiceObject(DependencyManager.java:2556) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager.invokeUnbindMethod(DependencyManager.java:2201) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.invokeUnbindMethod(SingleComponentManager.java:466) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.removedService(DependencyManager.java:395) [bundleFile:?]
at org.apache.felix.scr.impl.manager.DependencyManager$MultipleDynamicCustomizer.removedService(DependencyManager.java:301) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerRemoved(ServiceTracker.java:1226) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerRemoved(ServiceTracker.java:1121) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.untrack(ServiceTracker.java:981) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1160) [bundleFile:?]
at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:114) [bundleFile:?]
at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:120) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:957) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:234) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:151) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:936) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:873) [org.eclipse.osgi-3.16.200.jar:?]
at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.unregister(ServiceRegistrationImpl.java:241) [org.eclipse.osgi-3.16.200.jar:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.unregister(AbstractComponentManager.java:952) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager$3.unregister(AbstractComponentManager.java:915) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegistrationManager.changeRegistration(RegistrationManager.java:140) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.unregisterService(AbstractComponentManager.java:994) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.doDeactivate(AbstractComponentManager.java:844) [bundleFile:?]
at org.apache.felix.scr.impl.manager.AbstractComponentManager.deactivateInternal(AbstractComponentManager.java:825) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.reconfigure(SingleComponentManager.java:738) [bundleFile:?]
at org.apache.felix.scr.impl.manager.SingleComponentManager.reconfigure(SingleComponentManager.java:684) [bundleFile:?]
at org.apache.felix.scr.impl.manager.ConfigurableComponentHolder.configurationUpdated(ConfigurableComponentHolder.java:437) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegionConfigurationSupport.configurationEvent(RegionConfigurationSupport.java:347) [bundleFile:?]
at org.apache.felix.scr.impl.manager.RegionConfigurationSupport$2.configurationEvent(RegionConfigurationSupport.java:115) [bundleFile:?]
at org.apache.felix.cm.impl.ConfigurationManager$FireConfigurationEvent.sendEvent(ConfigurationManager.java:1720) [bundleFile:?]
at org.apache.felix.cm.impl.ConfigurationManager$FireConfigurationEvent.run(ConfigurationManager.java:1662) [bundleFile:?]
at org.apache.felix.cm.impl.UpdateThread.run0(UpdateThread.java:122) [bundleFile:?]
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:84) [bundleFile:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
2021-07-11 16:10:07.886 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : DependencyManager: $001 close component unbinding from org.apache.felix.scr.impl.manager.ComponentContextImpl@749ab7bc at tracking count 2 refpairs: [[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=37.93372643148088,23.637750148773197, service.id=181, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=22, timezone=Europe/Athens, service.config.category=system, region=GR, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [org.openhab.core.internal.i18n.I18nProviderImpl@1f9e5808]]]
2021-07-11 16:10:07.889 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : DependencyManager: $000 close component unbinding from org.apache.felix.scr.impl.manager.ComponentContextImpl@749ab7bc at tracking count 1 refpairs: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=194, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=25}] service: [org.openhab.core.internal.items.ItemRegistryImpl@4bde279b]]]
2021-07-11 16:10:07.891 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Failed creating the component instance; see log for reason
2021-07-11 16:10:07.893 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.896 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Changed state from satisfied to satisfied
2021-07-11 16:10:07.903 [WARN ] [ence.internal.PersistenceManagerImpl] - bundle org.openhab.core.persistence:3.1.0 (210)[org.openhab.core.persistence.internal.PersistenceManagerImpl(213)] : Could not get service from ref {org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService}={service.id=533, service.bundleid=302, service.scope=bundle, user=274484, tableNamePrefix=Item, url=jdbc:sqlserver://192.168.1.100:1433/databaseName=mydatabase, tableIdDigitCount=0, component.name=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, service.config.label=JDBC Persistence Service, component.id=320, service.config.factory=false, password=mypass1, databaseName=mydatabase, tableUseRealItemNames=false, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.pid=[org.openhab.jdbc, org.openhab.jdbc]}
2021-07-11 16:10:07.906 [WARN ] [ence.internal.PersistenceManagerImpl] - bundle org.openhab.core.persistence:3.1.0 (210)[org.openhab.core.persistence.internal.PersistenceManagerImpl(213)] : DependencyManager : invokeUnbindMethod : Service not available from service registry for ServiceReference {org.openhab.core.persistence.PersistenceService, org.openhab.core.persistence.QueryablePersistenceService}={service.id=533, service.bundleid=302, service.scope=bundle, user=274484, tableNamePrefix=Item, url=jdbc:sqlserver://192.168.1.100:1433/databaseName=mydatabase, tableIdDigitCount=0, component.name=org.openhab.persistence.jdbc.internal.JdbcPersistenceService, service.config.label=JDBC Persistence Service, component.id=320, service.config.factory=false, password=mypass1, databaseName=mydatabase, tableUseRealItemNames=false, service.config.category=persistence, service.config.description.uri=persistence:jdbc, service.pid=[org.openhab.jdbc, org.openhab.jdbc]} for reference PersistenceService
2021-07-11 16:10:07.909 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : This thread collected dependencies
2021-07-11 16:10:07.910 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : getService (single component manager) dependencies collected.
2021-07-11 16:10:07.912 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.915 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : Querying state satisfied
2021-07-11 16:10:07.917 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : For dependency $000, optional: false; to bind: [[RefPair: ref: [{org.openhab.core.items.ItemRegistry}={service.id=194, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.items.ItemRegistryImpl, component.id=25}] service: [org.openhab.core.internal.items.ItemRegistryImpl@4bde279b]]]
2021-07-11 16:10:07.920 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : 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=37.93372643148088,23.637750148773197, service.id=181, service.bundleid=154, service.scope=bundle, component.name=org.openhab.core.internal.i18n.I18nProviderImpl, language=en, service.config.label=Regional Settings, component.id=22, timezone=Europe/Athens, service.config.category=system, region=GR, service.config.description.uri=system:i18n, service.pid=[org.openhab.i18n, org.openhab.i18n]}] service: [org.openhab.core.internal.i18n.I18nProviderImpl@1f9e5808]]]
2021-07-11 16:10:07.923 [DEBUG] [jdbc.internal.JdbcPersistenceService] - bundle org.openhab.persistence.jdbc:3.1.0 (302)[org.openhab.persistence.jdbc.internal.JdbcPersistenceService(320)] : invoking activate: activate: parameters [org.eclipse.osgi.internal.framework.BundleContextImpl, org.apache.felix.scr.impl.helper.ReadOnlyDictionary]
2021-07-11 16:10:07.925 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated
2021-07-11 16:10:07.927 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig
2021-07-11 16:10:07.929 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::JdbcConfiguration
2021-07-11 16:10:07.931 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: configuration size = 14
2021-07-11 16:10:07.934 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: user=myusername
2021-07-11 16:10:07.936 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: password exists? true
2021-07-11 16:10:07.938 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: url=jdbc:sqlserver://192.168.1.100:1433/databaseName=mydatabase
2021-07-11 16:10:07.940 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: found serviceName = 'sqlserver'
2021-07-11 16:10:07.942 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: Init Data Access Object Class: 'org.openhab.persistence.jdbc.db.JdbcSqlserverDAO'
2021-07-11 16:10:07.945 [WARN ] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: no Configuration for serviceName 'sqlserver' found. ClassNotFoundException: org.openhab.persistence.jdbc.db.JdbcSqlserverDAO cannot be found by org.openhab.persistence.jdbc_3.1.0
2021-07-11 16:10:07.947 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: using default Database Configuration: JdbcBaseDAO !!
2021-07-11 16:10:07.950 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlTypes: Initialize the type array
2021-07-11 16:10:07.952 [DEBUG] [nhab.persistence.jdbc.db.JdbcBaseDAO] - JDBC::initSqlQueries: 'JdbcBaseDAO'
2021-07-11 16:10:07.955 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: dBConfig done
2021-07-11 16:10:07.958 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableNamePrefix=Item
2021-07-11 16:10:07.960 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableUseRealItemNames=false
2021-07-11 16:10:07.963 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: tableIdDigitCount=0
2021-07-11 16:10:07.966 [DEBUG] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: enableLogTime false
I thing that the problem is somewhere in
2021-07-11 16:10:07.945 [WARN ] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: no Configuration for serviceName 'sqlserver' found. ClassNotFoundException: org.openhab.persistence.jdbc.db.JdbcSqlserverDAO cannot be found by org.openhab.persistence.jdbc_3.1.0
Looks like you are right.
First I thought that the db/*DAO.java files just define default settings but as you can see in the following code extract they also define the db service related JDBC driver that is to be loaded:
db/JdbcDerbyDAO.java: databaseProps.setProperty("driverClassName", "org.apache.derby.jdbc.EmbeddedDriver");
db/JdbcH2DAO.java: databaseProps.setProperty("driverClassName", "org.h2.Driver");
db/JdbcHsqldbDAO.java: databaseProps.setProperty("driverClassName", "org.hsqldb.jdbcDriver");
db/JdbcMariadbDAO.java: databaseProps.setProperty("driverClassName", "org.mariadb.jdbc.Driver");
db/JdbcMysqlDAO.java: databaseProps.setProperty("driverClassName", "com.mysql.jdbc.Driver");
db/JdbcPostgresqlDAO.java: databaseProps.setProperty("driverClassName", "org.postgresql.Driver");
db/JdbcSqliteDAO.java: databaseProps.setProperty("driverClassName", "org.sqlite.JDBC");
As far as I understand that means to be able to use the mssql server jdbc driver the bundle org.openhab.persistence.jdbc needs to be recompiled.