Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'abstractcontactinfo' in information_schema

[shrikant_nikam]

Problem Statement: Getting below SQL error while updating the hybris platform, post installing the My SQL 8.0 latest version.

Exception : Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'abstractcontactinfo' in information_schema

Local.properties: # Mysql Data Base Config## db.url=jdbc:mysql://localhost/your_schema?useConfigs=maxPerformance&characterEncoding=utf8 db.driver=com.mysql.jdbc.Driver

Technical Problem: Driver compatibility issue. Solved by replacing mysql-connector-java-8.0.13 with mysql-connector-java-5.1.15

[geffchang]

The Hybris 1808 3rd-party compatibility guide suggests to use mySQL 5.6 or 5.7: https://help.hybris.com/1808/hcd/8c71300f866910149b40c88dfc0de431.html

( You haven't specified what Hybris version you are using )

I don't know if there are any issues with mySQL 8, but it's probably best that you downgrade. When you use mySQL 5.7, the DB Driver would also have to be 5.1.x.