search

twosigma / beakerx

Beaker Extensions for Jupyter Notebook
http://BeakerX.com
Apache License 2.0
2.8k stars 381 forks source link

Unknown system variable 'query_cache_size' #8063

Open Fredu7 opened 5 years ago

Fredu7 commented 5 years ago

Hello, I can use the beaker SQL Notebook to connect myself to a MySql Database with: %defaultDatasource jdbc:mysql://username:@hostname/dbnameserver?Timezone=Europe/Amsterdam But after trying a sql query "Select * from " I get the error: java.sql.SQLException: Unknown system variable 'query_cache_size' Apparently it is because the MySql Version 8 does not support 'query_cache_size' anymore and the jdbc connector ist too old. Is there a way to update the jdbc connector?

matheusmota commented 4 years ago

Same problem here. Does anybody has any suggestion?

Tried importing the jar file: %classpath add jar ../resources/jars/mysql-connector-java-8.0.17.jar

And loading it from maven: %classpath add mvn mysql mysql-connector-java 8.0.18

Both do not work.

Thanks