SpringBoot找不到EntityManagerFactory，即使它已声明

Question

我有这个SpringBoot的代码。它加载mybatis和冬眠。我得到一个异常类型EntityManagerFactory不可用，但它是在这里定义。记录输出包含'xxx'全部打印。

package com.ritchey.timesheet;


import java.sql.SQLException;
import java.util.Arrays;
import java.util.Properties;

import javax.naming.NamingException;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.sql.DataSource;

import org.apache.ibatis.session.SqlSessionFactory;
import org.hibernate.SessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.solr.SolrAutoConfiguration;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Primary;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;
import org.springframework.jndi.JndiTemplate;
import org.springframework.orm.hibernate5.HibernateExceptionTranslator;
import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaDialect;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@EnableJpaRepositories(basePackages = "org.browsexml.timesheetjob")
@ComponentScan(basePackages = "org.browsexml.timesheetjob")
@MapperScan(basePackages = "com.ritchey.timesheet.mapper.TimeSheet", sqlSessionTemplateRef="TimeSheetSqlSessionTemplate")
@MapperScan(basePackages = "com.ritchey.timesheet.mapper.powercampus", sqlSessionTemplateRef="powercampusSqlSessionTemplate")
@SpringBootApplication()
public class Timesheet  {
    private static final Logger LOGGER = LoggerFactory.getLogger(Timesheet.class);
    
    static public String version = "77777";

        
    public static void main(String[] args) throws NamingException {
        SpringApplication application = new SpringApplication(Timesheet.class);

        LOGGER.info("RUN TIMESHEET ");
        ApplicationContext ctx = application.run();
        LOGGER.info("messages TIMESHEET");
        String basename = ctx.getEnvironment().getProperty("spring.messages.basename", "messages");
        LOGGER.info("basename = " + basename);
        LOGGER.info("Let's inspect the beans provided by Spring Boot:");

        String[] beanNames = ctx.getBeanDefinitionNames();
        Arrays.sort(beanNames);
        for (String beanName : beanNames) {
            LOGGER.info(beanName);
        }
        
    }
    
    @Bean
    public DataSource getCampusDatasource() throws NamingException {
        JndiTemplate jndiTemplate = new JndiTemplate();
        DataSource ds = null;
        ds = (DataSource) jndiTemplate.lookup("java:comp/env/jdbc/powerCampus");
        return ds;
    }

    
    @Bean
    @Primary
    public DataSource getTimeSheetDatasource() throws NamingException {
        JndiTemplate jndiTemplate = new JndiTemplate();
        DataSource ds = null;
        ds = (DataSource) jndiTemplate.lookup("java:comp/env/jdbc/TimeSheet");
        return ds;
    }
    
    @Bean
    public SqlSessionFactory TimeSheetSqlSessionFactory() throws Exception {
      SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
      factoryBean.setDataSource(getTimeSheetDatasource());
      return factoryBean.getObject();
    }
    
    @Bean
    @Primary
    public SqlSessionFactory powercampusSqlSessionFactory() throws Exception {
      SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
      factoryBean.setDataSource(getCampusDatasource());
      return factoryBean.getObject();
    }
    
    @Bean
    @Primary
    public SqlSessionTemplate TimeSheetSqlSessionTemplate(@Qualifier("TimeSheetSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
    
    @Bean
    @Primary
    public SqlSessionTemplate powercampusSqlSessionTemplate(@Qualifier("powercampusSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
    
    
    @Bean
    @Primary
    public SessionFactory sessionFactory() throws Exception {
        LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();
      factoryBean.setDataSource(getTimeSheetDatasource());
      factoryBean.setMappingResources("org/browsexml/timesheetjob/model/Awards.hbm.xml",
              "org/browsexml/timesheetjob/model/HoursWorked.hbm.xml",
              "org/browsexml/timesheetjob/model/Job.hbm.xml",
              "org/browsexml/timesheetjob/model/PeopleProperties.hbm.xml",
              "org/browsexml/timesheetjob/model/CodeTerm.hbm.xml",
              "org/browsexml/timesheetjob/model/Holiday.hbm.xml",
              "org/browsexml/timesheetjob/model/PayPer.hbm.xml",
              "org/browsexml/timesheetjob/model/Awarded.hbm.xml",
              "org/browsexml/timesheetjob/model/Agreements.hbm.xml",
              "org/browsexml/timesheetjob/model/Timesheets.hbm.xml",
              "org/browsexml/timesheetjob/model/FulltimeAgreements.hbm.xml",
              "org/browsexml/timesheetjob/model/Supervisor.hbm.xml"
              );
      factoryBean.setAnnotatedClasses(org.browsexml.timesheetjob.model.WorkCode.class
              , org.browsexml.timesheetjob.model.ProcessErrors.class
              , org.browsexml.timesheetjob.model.UserLog.class
              , org.browsexml.timesheetjob.model.Properties.class
              , org.browsexml.timesheetjob.model.AuditTrail.class
              , org.browsexml.timesheetjob.model.PositionCode.class
              , org.browsexml.timesheetjob.model.Position.class
              , org.browsexml.timesheetjob.model.CodeRegions.class);
      
      Properties p = new Properties();
     
      p.setProperty("hibernate.dialect", "org.browsexml.dialect.SQLServerDialect");
      p.setProperty("hibernate.hbm2ddl.auto", "validate");
      p.setProperty("hibernate.query.substitutions", "true 1; false 0; yes 'Y'; no 'N'; year dbo.year");
      p.setProperty("hibernate.show_sql", "true");

      factoryBean.setHibernateProperties(p);
      return factoryBean.getObject();
    }
    
    @Bean
    public SessionFactory pcSessionFactory() throws Exception {
        LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();
      factoryBean.setDataSource(getCampusDatasource());
      factoryBean.setMappingResources(
              "org/browsexml/timesheetjob/model/PeopleBasic.hbm.xml",
              "org/browsexml/timesheetjob/model/Address.hbm.xml"
              );
      
      Properties p = new Properties();
         
      p.setProperty("hibernate.dialect", "org.browsexml.dialect.SQLServerDialect");
      p.setProperty("hibernate.hbm2ddl.auto", "validate");
      p.setProperty("hibernate.query.substitutions", "true 1; false 0; yes 'Y'; no 'N'; year dbo.year");
      p.setProperty("hibernate.show_sql", "true");

      factoryBean.setHibernateProperties(p);
      
      return factoryBean.getObject();
    }
    
    @Bean(name="entityManagerFactory")
    public EntityManagerFactory entityManagerFactory() throws SQLException, NamingException {
        LOGGER.debug("xxx entity manager factory");
        HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        vendorAdapter.setShowSql(true);
        vendorAdapter.setGenerateDdl(true);
        
        HibernateJpaDialect jpd = new HibernateJpaDialect();

        LocalContainerEntityManagerFactoryBean factory = new LocalContainerEntityManagerFactoryBean();
        factory.setJpaVendorAdapter(vendorAdapter);
        factory.setJpaDialect(jpd);
        factory.setPackagesToScan("org.browsexml.timesheetjob.model");
        factory.setDataSource(getTimeSheetDatasource());
        factory.afterPropertiesSet();

        EntityManagerFactory ret = factory.getObject();
        LOGGER.debug("xxx entity manager factory  " + ret);
        return ret;
    }

    @Bean
    public EntityManager entityManager(@Qualifier("entityManagerFactory") EntityManagerFactory entityManagerFactory) {
        LOGGER.debug("xxx entity manager");
        EntityManager ret = entityManagerFactory.createEntityManager();
        LOGGER.debug("xxx entity manager  " + ret);
        return ret;
    }

    @Bean
    public PlatformTransactionManager transactionManager() throws SQLException, NamingException {
        JpaTransactionManager txManager = new JpaTransactionManager();
        txManager.setEntityManagerFactory(entityManagerFactory());
        return txManager;
    }

    @Bean
    public HibernateExceptionTranslator hibernateExceptionTranslator() {
        return new HibernateExceptionTranslator();
    }
    
}

在SpringBoot中，我遇到了以下异常：

Answer 1

通过设置application.properties绕过此错误：

 spring.jpa.open-in-view=false

不知道这里发生了什么。