Could not open JPA EntityManager for transaction

Question

I'm trying to setup a JPA connection to via hibernate but i don't get what's the problem with my code.

My Configuration:

@EnableTransactionManagement
public class JPAConfig {
    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
        LocalContainerEntityManagerFactoryBean localContainerEntityManagerFactoryBean =
                new LocalContainerEntityManagerFactoryBean();

        JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        localContainerEntityManagerFactoryBean.setJpaVendorAdapter(vendorAdapter);

        DriverManagerDataSource driverManagerDataSource =
                new DriverManagerDataSource();
        driverManagerDataSource.setUsername("root");
        driverManagerDataSource.setPassword("");
        driverManagerDataSource.setUrl("jdbc:mysql://localhost:3306/odontology");
        driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");

        localContainerEntityManagerFactoryBean.setDataSource(driverManagerDataSource);

        Properties properties = new Properties();
        properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
        properties.setProperty("hibernate.show_sql", "true");
        properties.setProperty("hibernate.hbm2ddl.auto", "update");
        localContainerEntityManagerFactoryBean.setJpaProperties(properties);
        localContainerEntityManagerFactoryBean.setPackagesToScan("org.odontology.models");

        return localContainerEntityManagerFactoryBean;
    }

    @Bean
    public JpaTransactionManager transactionManager(EntityManagerFactory entityManagerFactory){
        return new JpaTransactionManager(entityManagerFactory);
    }
}

This is the error i get:

    org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection

Is your database running (properly)? Can you connect to it from a shell or something else? — niekname
– niekname, Commented Mar 5, 2017 at 18:38

Community · Accepted Answer · 2017-05-23 11:46:18Z

0

I think you are setting "" as password. Try without invoking driverManagerDataSource.setPassword or with driverManagerDataSource.setPassword(null)

Also, check this question: Mysql Connection with out password using corejava program

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Mar 6, 2017 at 16:54

niekname

2,6461 gold badge17 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Could not open JPA EntityManager for transaction

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related