Hi,
I’m trying to use jdbc persistence service with MariaDB in openHAB2. When installing the service via Paper UI I get the following exception:
2017-04-17 12:21:40.962 [ERROR] [g.eclipse.smarthome.core.persistence] - [org.eclipse.smarthome.core.persistence.persistencemanager(35)] The addPersistenceService method has thrown an exception
java.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.String
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.getState(JdbcBaseDAO.java:504)
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.doGetHistItemFilterQuery(JdbcBaseDAO.java:343)
at org.openhab.persistence.jdbc.internal.JdbcMapper.getHistItemFilterQuery(JdbcMapper.java:154)
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.query(JdbcPersistenceService.java:201)
at org.openhab.core.persistence.internal.QueryablePersistenceServiceDelegate.query(QueryablePersistenceServiceDelegate.java:47)
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.initialize(PersistenceManagerImpl.java:250)
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.startEventHandling(PersistenceManagerImpl.java:365)
at org.eclipse.smarthome.core.persistence.internal.PersistenceManagerImpl.addPersistenceService(PersistenceManagerImpl.java:95)
A few seconds later the service is deinstalled again:
2017-04-17 12:21:49.108 [INFO ] [core.karaf.internal.FeatureInstaller] - Uninstalled 'openhab-persistence-jdbc-mariadb'
Configuration file jdbc.cfg is defined. Driver mariadb-java-client-1.4.6.jar is placed under “/opt/openhab2/runtime/lib/boot” and it seems to be loaded correctly before:
2017-04-17 12:21:39.862 [INFO ] [persistence.jdbc.internal.JdbcMapper] - JDBC::openConnection: Driver is available::Yank setupDataSource
Does anyone have an idea for a solution?
Thanks and best regards,
Marc