Connect to the repository by using the database resource library!

Connect to the repository by using the database resource library!

The following is a screenshot of the overall error report

The following is a screenshot of the overall error report

Since you can connect to the database locally, the first thing you think of after reporting this error is MySQL connector- java.jar Is 5.7.27 not supported?After replacing several jar packages, it’s fruitless…
Immediately added a few groups to ask, or fruitless…

In the end, I had no choice but to debug by myself… ing…

When debugging to this step, the exception appears. Then put its SQL into the tool to execute, and report an error that the table does not exist. Finally, it is found that the table name in the database is lowercase while the table name of the query statement is uppercase.
OK. Found the problem…

Solution: find [mysqld] and add a line below it: lower_ case_ table_ Names = 1, (1 means ignore case, 0 means resolve case). As shown in the figure below

Restart mysql. That’s it. I’m afraid I’ll forget this pit.

Read More: