IS MYSQL 80 COMPATIBLE IN KNOWAGE 7.1.5?

Question

Hi knowage team,

is mysql 80 compatible now in 7.1.5 version ?

i was trying to create datasource using mysql 80 but i got this error.

please advise how to fixed this thanks

-Fatima

Answer 1

You have to to put the jdbc connector for mysql 8 in the lib folder and restart Knowage. It is not included by default during installation. You can download the mysql 8 jdbc jar file here

https://jar-download.com/artifacts/mysql/mysql-connector-java/8.0.11

When you create the datasource, driver should be "com.mysql.cj.jdbc.Driver"

Comments

Hi Still getting this error.

---

You have to restart your knowage server after you put the jar file in your lib folder

---

I am able to run Common Table Expressions that are only supported in MySQL 8

---

Hi Darwin,

Thank you for this i was able to connect successfully in mysql80.

- Regards

Fatima

---

You're welcome Fatima. Glad to be of help.

---

Oh btw, if you are connecting to a MySQL or MariaDb database hosted in a remote linux server, you need to open a SSH tunnel before Knowage can connect to the dataource

---

are you y any chance working for TAP?

Answer 2

Hi Sir Darwin,

thanks for the info.

yes i am working in TAP services :)

-Regards

Comments

Great!. Good to know.

Regards!