Spring框架中Bean method 'dataSource'未加载问题求助

Hey there! Let's figure out why you're running into the Bean method 'dataSource' not loaded error when trying to connect MySQL to your Spring application. I'll walk through the most common fixes and Java 9-specific quirks below:

Spring won't auto-configure a DataSource unless you include the necessary starters and MySQL connector in your pom.xml. Here's what you need:

<!-- Use this if you're using JPA/Hibernate (most common for Spring apps) -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<!-- Or use this if you only need basic JDBC without JPA -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

<!-- MySQL Connector (for MySQL 8+, use this groupId; older versions use 'mysql' instead of 'com.mysql') -->
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>

Pro tip: Double-check that your Spring Boot version is compatible with Java 9—Spring Boot 2.1+ has solid Java 9 support, so avoid older versions if possible.

Incorrect database config is a super common culprit. Make sure your file has all the required fields, and that they match your MySQL setup:

# Core DataSource Config
spring.datasource.url=jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC
spring.datasource.username=your_db_username
spring.datasource.password=your_db_password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# Optional JPA/Hibernate Settings (if using spring-boot-starter-data-jpa)
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

Important notes:

• For MySQL 8+, you must use com.mysql.cj.jdbc.Driver (the old com.mysql.jdbc.Driver is deprecated).
• The serverTimezone parameter is mandatory in Java 9+ to avoid timezone mismatch errors.
• Double-check that your MySQL server is running on port 3306, and that the database exists with the name you specified.

Your AdminPortalApplication.java needs the @SpringBootApplication annotation to trigger auto-configuration (including the DataSource bean). Here's a correct example:

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class AdminPortalApplication {
    public static void main(String[] args) {
        SpringApplication.run(AdminPortalApplication.class, args);
    }
}

If you've added custom @ComponentScan or @EnableAutoConfiguration annotations, make sure they aren't excluding the auto-configured DataSource beans. Stick with plain @SpringBootApplication unless you have a specific reason to customize it.

Java 9 introduced the module system, which can block Spring from accessing necessary classes if not configured right:

• If your project uses a module-info.java, you need to declare dependencies on the required modules and open your packages to Spring:

module your.admin.portal {
    requires spring.boot;
    requires spring.boot.autoconfigure;
    requires spring.data.jpa;
    requires mysql.connector.j;
    
    // Open your base package to Spring's reflection
    opens com.yourpackage.adminportal to spring.core, spring.beans;
}

• If you're not using modules, add these JVM arguments when running your app to ensure Spring can access required Java modules:
  --add-modules java.sql,java.naming
  These modules are optional in Java 9+, so Spring might not load them automatically otherwise.

• Confirm MySQL is running, and that your username/password has permission to access the target database.
• If you have custom DataSource beans in your code, make sure they don't conflict with Spring's auto-configured one (either remove yours or use @Primary to mark which one to use).
• Clear your Maven cache (mvn clean install -U) to fix any corrupted dependencies that might be blocking class loading.

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