I encountered an issue with my MySQL database. Previously, I utilized `dateadd` in my query, but it seems ineffective with MySQL. To address this, I tried incorporating the SpEL (Spring Expression Language) annotation. However, I faced an error stating 'Could not resolve bean reference against BeanFactory.'

Solution for Error: 'Could not resolve bean reference against BeanFactory'

When facing the error 'Could not resolve bean reference against BeanFactory', it usually indicates a problem with our Spring bean configuration or dependency injection. Let's address this issue together:

Step-by-Step Solution:

  1. Check Bean Definition: Firstly, we need to verify that the bean being referenced in our Spring application context actually exists and is correctly defined.
  2. Verify Bean Name: We should ensure that the bean name specified in our code or configuration matches the actual bean name defined in our Spring context.
  3. Confirm Dependency Injection: If we're injecting beans into other beans or components, we need to double-check that the injection is done correctly, using annotations like @Autowired or @Inject.
  4. Inspect Classpath and Dependencies: It's essential to review our project's classpath and ensure that all necessary dependencies are present, and there are no conflicts between different versions of libraries.
  5. Check Component Scanning: If we're using component scanning to automatically detect Spring beans, we should confirm that the packages being scanned include the package containing the bean we're trying to reference.
  6. Look for Typos or Naming Mistakes: Sometimes, errors like this can occur due to simple typos or naming mistakes in our code or configuration files. We should carefully review our code and configuration to catch any such issues.

In our case, we identified the main cause of the error "Spring BeanCreationException: cannot resolve reference to bean exception", and it's surprisingly straightforward.
Upon examining the class com.otv.model.Product, we noticed that the id field lacks the @Id annotation.

@Id annotation is crucial for marking the primary key field in an entity class. Without it, the framework (likely JPA or Hibernate) won't recognize the field as the identifier, leading to errors like the one we encountered.

By adding the @Id annotation above the id field in the Product class, we inform the persistence framework about the primary key, enabling proper mapping and resolving the issue we faced.

Solution to Solve Spring BeanCreationException

It typically means that Spring is unable to find a bean that your application is trying to reference.

Possible Reason:

  • Ensure that the bean name you're referring to in your code matches the name of the bean declared in your Spring configuration.Check if the bean definition is properly configured in your Spring XML or Java configuration files.
  • If you're using component scanning, verify that the package containing the referenced bean is included in the component scan base package.If the bean you're referring to depends on other beans, make sure those dependencies are correctly defined and available.


Let's say we have a Spring application where we've defined a service bean named UserService. Now, in another class or configuration, we're attempting to inject this UserService bean. However, due to a typo or missing bean definition, Spring cannot find the UserService bean, resulting in a BeanCreationException.

To find out the root problem of this issue, we need to carefully review our bean configurations and the code where the bean is referenced. Here's what we can do:

  1. Double-check the spelling and case sensitivity of the bean names.
  2. Ensure that all necessary bean definitions are present in the configuration files.
  3. If using component scanning, confirm that the package containing the bean is scanned.
  4. If the bean depends on other beans, verify that those dependencies are correctly defined.