As already discussed in this thread: https://community.openhab.org/t/wrong-results-for-some-persistence-functions-with-jdbc/14233/6 I am testing the JDBC persistence service with SQLite.

With the 1.8.3 version of the binding openhab starts without an error, with the latest 1.9.0 snapshot I get the following error when starting openhab:

2016-09-18 20:21:25.311 INFO o.o.p.jdbc.internal.JdbcMapper[:170]- JDBC::openConnection: Driver is available::Yank setupDataSource
2016-09-18 20:21:25.559 ERROR org.knowm.yank.Yank[:668]- Error in SQL query!!!
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: DATABASE) Query: SELECT DATABASE() 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.queryScalar(Yank.java:273)
at org.knowm.yank.Yank.queryScalar(Yank.java:253)
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.doGetDB(JdbcBaseDAO.java:261)

I checked the commits after the release of the 1.8.3 version of the binding and noticed, that a "select database()" querry has been added.

My suspicion is, that SQLite does not support such a querry and therefore the error is thrown