Is it possible to use the JDBC service to access MariaDB from a script

Setup, Configuration and Use Scripts & Rules
6

Thanks Rich! That looks promising to the max…

I’m able to read from the mariaDB hosted on my NAS using the jdbc service, using GET /persistence/items

image
image1648×932 24.8 KB

But when I’m trying to write with PUT /persistence/items/SpotPrice, I get HTTP 400 error wth a message: “Persistence service not modifiable: jdbc”

image
image1640×924 29.3 KB

It’s exactly the same issue than here: [SOLVED] REST API: "Persistence service not modifiable: influxdb" - #16 by wjaceh

  • The original poster tried to write to influxdb hosted on another server, I’m trying to write to a remote mariadb, but that should not be relevant
  • The original poster had misconfigured the influxdb so that it did not allow connections from another server and when they fixed that, their issue got resolved
  • That’s not my issue, because my MariaDB does allow connections from others hosts in the same LAN, as can be seen from the fact that I was able to query the GET /persistence/items endpoint…

scratching my head…

Any ideas?