Remove suffix from tablename not working :-(

,
1

Hello everybody,

I’ve set my jdbc.cfg as following:

url=jdbc:mariadb://127.0.0.1:3306/openhab?serverTimezone=Europe/Berlin
user=myuser
password=mypassword
rebuildTableNames=false
tableIdDigitCount=0
tableUseRealItemNames=true

But though I’ve set tableIdDigitCount to 0 openhab adds a _# (p.e. _1, _2, etc.) to the table’s name. How can I avoid this?

2

should be ok according to the docs.
Did you restart the OH service ?

3

Looks like this already was reported in december 2021 on github but not fixed/changed yet although a proposal was made:

4

For anyone landing here, please follow this thread for further updates: JDBC persistence with tableUseRealItemNames and tableIdDigitCount=0

5

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.