Hi. I’m trying to get jdbc mysql persistence working in OH3. It works for most of my Items, but I have a few temperature sensors for which I changed the type during the upgrade (from just Number to Number:Temperature) and for these Items I get the following error in the log every time they change v…

After some Googling I found this , but from what I can understand that particular problem was solved in october. Could @cweitkamp share more light on this? edit: I’ve now noticed that this goes for all Items that have a type Number:something, same error in the log for all of them. I don’t know if th…

Hi, did you define an alternative data type for numbers? By default this is a double value. You can find the configuration in your jdbc.cfg file around line 48: 48 #sqltype.NUMBER = DOUBLE

[image] cweitkamp: did you define an alternative data type for numbers? I posted my entire jdbc.cfg above (the grep I used is only for removing comment lines). So no, nothing like that.

Alright. Then we have to create another small path to change this line of code: bundles/org.openhab.persistence.jdbc/src/main/java/org/openhab/persistence/jdbc/db/JdbcBaseDAO.java beacec311 vo.setValue(item.getState().toString()); } else if ("NUMB…

[image] cweitkamp: Then we have to create another small path to change this line of code Ok. Will you do a PR on that? I don’t really understand though, wouldn’t this happen to anyone trying to persist a QuantityType value using jdbc? Just wondering why I seem to be the only one affected…

[image] DanielMalmgren: Just wondering why I seem to be the only one affected… It happens, I also have problems with influxDB disease, but it seems, except me, no one experiences them.

[image] DanielMalmgren: Will you do a PR on that? Done. [jdbc] Fixed ClassCastException main ← cweitkamp:bugfix-jdbc-cce opened 04:03PM - 08 Dec 20 UTC (UTC) …

I ran into similar problems: 2020-12-28 16:44:57.771 [WARN ] [org.openhab.core.items.GenericItem ] - failed notifying listener 'org.openhab.core.persistence.internal.PersistenceManagerImpl@7ceca5' about state update of item AutoBedtime: class java.lang.Integer cannot be cast to class java.lang.Lon…

Hi Stephan, Your issue looks a little bit different. The CCE is thrown in a different line of code. Can you provide a DEBUG log? Would be nice to know if your connection is really working. Do you see something like this in your log file: JDBC::openConnection: Driver is available::Yank setupDataSo…

Hi Christoph! Here’s what my log shows if I set the loglevel of the jdbc binding to DEBUG: 14:31:12.639 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC::activate: persistence service activated 14:31:12.647 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC::updateConfig 14:31:12.661 [DE…

openHAB Community

Problem with persistence in OH3

Add-ons Persistence Services

Olymp (Sergey M) December 8, 2020, 6:17am 7

It happens, I also have problems with influxDB disease, but it seems, except me, no one experiences them.