STS4中Spring Boot配置ORM后无法获取数据源问题求助

Hey there, let's work through why you're struggling to get your data source up and running in your Spring Boot ORM project on STS 4. Based on the configuration you shared, here are targeted checks and fixes to try:

1. Verify MySQL Driver Dependency & Compatibility #

Your config uses com.mysql.jdbc.Driver—that's the legacy driver for MySQL 5.x. If you're running MySQL 8.0 or newer, you'll need the updated driver class com.mysql.cj.jdbc.Driver instead. Also, make sure you've included the correct dependency in your pom.xml (Maven) or build.gradle (Gradle):

For Maven:

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>8.0.33</version> <!-- Use the latest stable version -->
</dependency>

Older projects might use mysql-connector-java, but mysql-connector-j is the official replacement for newer MySQL versions.

2. Validate Database Connection Basics #

• Check MySQL Service: Ensure your local MySQL server is running. You can verify this by trying to connect via the MySQL command line or a tool like DBeaver/Navicat with the same credentials (root + empty password) and database name basebanque.
• Database Existence: The spring.jpa.hibernate.ddl-auto=create setting creates tables, but it won't create the actual database. Double-check that basebanque exists in your MySQL instance—if not, create it manually first.
• Credentials & Port: Confirm there are no typos in your username/password (even an accidental space in the password field can break things) and that MySQL is listening on port 3306.

3. Update JPA/Hibernate Config for Modern MySQL #

Your current config has outdated settings for newer MySQL versions. Try updating these lines:

• Replace org.hibernate.dialect.MySQL5Dialect with org.hibernate.dialect.MySQL8Dialect (matches MySQL 8.x's syntax and features).
• Add timezone and SSL parameters to your JDBC URL to avoid common connection errors.

Here's a revised application.properties example:

spring.datasource.url=jdbc:mysql://localhost:3306/basebanque?useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=create
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

The serverTimezone=UTC fixes timezone mismatches between MySQL 8+ and your Spring Boot app, and useSSL=false disables SSL for local development (you can enable it in production if needed).

4. Ensure Configuration is Loaded Correctly #

• Make sure your application.properties is placed in the src/main/resources directory—this is the default location Spring Boot uses for config files. If it's in the wrong folder, your settings won't be picked up.
• Check your STS console for any logs containing "datasource" or "hibernate"—even partial logs can hint at issues like connection timeouts, invalid credentials, or missing dependencies.

5. Simplify to Isolate the Issue #

Temporarily remove non-essential config lines (like spring.jpa.database=MYSQL, which Spring Boot can auto-detect) to see if the connection works with a minimal setup. If it does, you can add back settings one by one to identify which line was causing the problem.

If none of these fixes work, try to grab the full error stack trace from the console—it will tell you exactly why the data source can't be created (e.g., "Connection refused", "Access denied for user 'root'@'localhost'") and help narrow down the root cause.

内容的提问来源于stack exchange，提问作者kawtousse