How to fix NPE in hibernate config?

Question

@Autowired Environment env - always null.This is my HibernateConf.java:

@Configuration
@EnableTransactionManagement
@PropertySource({ "classpath:hibernate.properties" })
public class HibernateConf{

    @Autowired
    private Environment env;

    @Bean
    public LocalSessionFactoryBean sessionFactory() {
        final LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
        sessionFactory.setDataSource(dataSource());
        sessionFactory.setPackagesToScan(new String[]{"Enteties"});
        sessionFactory.setHibernateProperties(hibernateProperties());

        return sessionFactory;
    }

    @Bean
    public DataSource dataSource() {
        final BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName(Preconditions.checkNotNull(env.getProperty("com.mysql.cj.jdbc.Driver")));
        dataSource.setUrl(Preconditions.checkNotNull(env.getProperty("jdbc:mysql://localhost:3306/tutorialdb?createDatabaseIfNotExist=true")));
        dataSource.setUsername(Preconditions.checkNotNull(env.getProperty("root")));
        dataSource.setPassword(Preconditions.checkNotNull(env.getProperty("9339")));
        return dataSource;
    }

    @Bean
    public PlatformTransactionManager hibernateTransactionManager() {
        final HibernateTransactionManager transactionManager = new HibernateTransactionManager();
        transactionManager.setSessionFactory(sessionFactory().getObject());
        return transactionManager;
    }

    private final Properties hibernateProperties() {
        final Properties hibernateProperties = new Properties();
        hibernateProperties.setProperty("hibernate.hbm2ddl.auto", env.getProperty("create-drop"));
        hibernateProperties.setProperty("hibernate.dialect", env.getProperty("org.hibernate.dialect.MySQL5Dialect"));

        return hibernateProperties;
    }
}

So the main problem it is that this @Autowired private Environment env; always NPE but I don't know why because every example of this config class is the same as mine. How can I fix it?

Your properties aren't properties, but rather the actual value. — M. Deinum, Sep 09 '19 at 12:38
Please see the answer here: https://stackoverflow.com/questions/19421092/autowired-environment-is-null — Brooklyn99, Sep 09 '19 at 16:19
anyway i need to inject my environment, where i need to do it? — Arthur Dyachenko, Sep 09 '19 at 16:22
the class you are using to import the properties from Environment — Brooklyn99, Sep 09 '19 at 16:24
you need to do two things. First, implement the EnvironmentAware to the class and then override the setEnvironment() method and then you can load/fetch the properties from environment — Brooklyn99, Sep 09 '19 at 16:28
i mean public void setEnvironment(final Environment environment) where i need to inject this environment? — Arthur Dyachenko, Sep 09 '19 at 17:04
Possible duplicate of [What is a NullPointerException, and how do I fix it?](https://stackoverflow.com/questions/218384/what-is-a-nullpointerexception-and-how-do-i-fix-it) — Johannes Kuhn, Sep 09 '19 at 18:54
That link you added is about NPE at all my problem is different. — Arthur Dyachenko, Sep 09 '19 at 19:02
`env.getProperty("9339")` I highly doubt that `9339` is the name of a property. Also properties cannot be null so doing a `Preconditions.checkNotNull` isn't needed. — M. Deinum, Sep 10 '19 at 05:38
yep you right. I want to explain that you need use it without env.getProperty. — Arthur Dyachenko, Sep 10 '19 at 06:07

score 0 · Answer 1 · answered Nov 04 '19 at 09:09

(Posted on behalf of the question author to move it from the question to the answer space).

I found the solution to this problem. First you need to remove @Autowired private Environment env; and second dataSource.setPassword("9339") use it just with String parameters.

Thirdly, you need to have not 5.0...mysql-connector not 4.0... but this one:

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>8.0.17</version>
</dependency>

How to fix NPE in hibernate config?

1 Answers1