1
0
-1

Hi Avoka Team,


We are using MySQL 8 for DB access and lately we have been encountering this error:

java.sql.SQLException: Unknown system variable 'query_cache_size'
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3833)
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3283)

When I googled this error it seems that the query cached is removed from SQL 8. 

https://stackoverflow.com/questions/43044193/datagrip-reports-unknown-system-variable-query-cache-type-when-connecting-to

Do we have the latest driver/connector on TM?

Please advise.

Thanks.



    CommentAdd your comment...