Confluence - error setting up mysql database : Illegal operation on empty result set.

[Jude Kim]

Problem connecting to your database

SQLState - S1000
java.sql.SQLException: Illegal operation on empty result set.

Error occurs at 'Set up your database" step, does anybody know the solution?

Environment is as following : 

- MySQL 8.0

- ojdbc8.jar

- mysql-connector-java-5.1.46.jar

- mysql-connector-java-5.1.46-bin.jar

[Nic Brough -Adaptavist- · Accepted solution]

Start by using a supported database - the latest versions of Confluence only support MySQL 5.6 and 5.7

[Jude Kim]

Oh, I'll check with it then!

Thank you! :)

[Jude Kim]

Now it works well!!

Thank you!!