Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.Mon Nov 15 20:44:52 CST 2021
There was an unexpected error (type=lnternal Server Error, status=500).
Could not open JPA Entity/Manager for transacton, nested exception is org.hibernate.exceptionGenericDBCException:
Unable to acquireJDBCConnection
During the debugging of idea, I encountered a problem on the browser side. I found it for many days and finally solved it. That is, the JDBC version of the connection between idea and MySQL does not match. Let’s share the method below
if you see an error, it is probably a JDBC connection problem. First, check the configured MySQL user name, password and URL
After making sure that everything is correct, check whether my MySQL version corresponds to the idea version. Before I made an error, the MySQL jar package in the idea is 5.0, but my idea version is higher than mysql, so I can’t connect. Then I go to the MySQL 8.0 jar package under the official website, import it into the idea, and then change the JDBC version in pom.xml
- In the higher version of JDBC, spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver is generally added with a cj.
This is the previous
this is the current
later, there will be no JDBC connection problem when running on the server side! This is my problem solved, others may have more situations. Here only represents my own solution!
Read More:
- [Solved] Manifest merger failed: Apps targeting Android 12 and higher are required to specify an explicit va
- MYSQL Safe Upgraded Error: You are using safe update mode and you tried to update
- [Solved] Description: Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded
- MySQL Change password failure prompt: ERROR 1064(42000):You have an error in your SQL syntax: check the corresponds to your M
- [Solved] java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
- mysqli_ Error() has no return value (Fixed)
- MySQL installation error: error while loading shared libraries: libaio.so .1: cannot open shared object file: No such
- [Solved] sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, “You have an error in your SQ
- MYSQL Use cmd to change root password error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- Error 1418 (HY000): this function has none of deterministic, no SQL
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
- [Solved] mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this opera
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata
- Error running ‘Application‘: Command line is too long [How to Solve]
- [Solved Perfectly] MySQL ERROR 1064 (42000): You have an error in your SQL syntax;
- MySQL Build table error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id