Hi,
I would like to run JDBC Persistence with Postgres or MariaDB. After the connection to the db server has been established, I’m getting the following error message
"Error in SQL query".
2017-03-05 09:06:02.195 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getItemTables
2017-03-05 09:06:02.197 [DEBUG] [ersistence.jdbc.db.JdbcPostgresqlDAO] - JDBC::doGetItemTables sql=SELECT table_name FROM information_schema.tables WHERE table_type=‘BASE TABLE’ AND table_schema=‘public’ AND NOT table_name=items
2017-03-05 09:06:02.222 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: ERROR: column “items” does not exist
Position: 125 Query: SELECT table_name FROM information_schema.tables WHERE table_type=‘BASE TABLE’ AND table_schema=‘public’ AND NOT table_name=items Parameters: []
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:289)
at org.knowm.yank.Yank.queryBeanList(Yank.java:429)
at org.knowm.yank.Yank.queryBeanList(Yank.java:409)
at org.openhab.persistence.jdbc.db.JdbcPostgresqlDAO.doGetItemTables(JdbcPostgresqlDAO.java:128)
at org.openhab.persistence.jdbc.internal.JdbcMapper.getItemTables(JdbcMapper.java:110)
I’ve already tried severaly things, but nothing helped. Maybe someone can help me to solve this issue.
Regards,
Robert