spring boot应用程序jpa在一个控制器中工作而不在另一个控制器中工作

Question

不工作的控制器：

@RestController
@RequestMapping("/demographic")
@SuppressWarnings("rawtypes")
public class VerificationController {

    @Autowired
    EntityManager entityManager;

    public final Logger logger = LoggerFactory.getLogger(this.getClass());


    @Autowired
    private UserRepository userRepo;
    @Autowired
    private RoleRepository roleRepo;
    @Autowired
    private VerificationRepository veRepository;

    @PostMapping(value = "/validate")
    @ResponseBody
    public ResponseDTO Verification(@RequestBody VerificationModel verificationModel) throws IOException {
        logger.info("-----Start of Method------ ");
        logger.info("verify");
        logger.debug("Request  :" + verificationModel);

        ResponseDTO responseDTO = new ResponseDTO();
        VerificationLog verificationLog = new VerificationLog();

        // General Elements
        verificationLog.setAadharNumber("290567459087");
        verificationLog.setVerificationType("pi");
        verificationLog.setVerifiedBy("superadmin");
        verificationLog.setUploadedDate(new Date());
        verificationLog.setIsBulkUpload(false);

        // Default Values
        verificationLog.setAge(0);
        verificationLog.setMatchPercentage(0);

        logger.debug("Request to be Added :" + verificationLog);
        VerificationLog verificationLog1 = veRepository.save(verificationLog);

        logger.debug("Request to be Added :" + verificationLog1);

工作控制器：

@RestController
@RequestMapping("/user")
@SuppressWarnings("rawtypes")
public class UserController {

    @Autowired
    EntityManager entityManager;

    public final Logger logger = LoggerFactory.getLogger(this.getClass());

@PostMapping(value = "/createadmin")
    @ResponseBody
    public ResponseDTO createAdminUser(@RequestBody User user) {
        logger.info("-----Start of Method------ ");
        logger.info("createadmin");
        logger.debug("Request  :" + user);
        ResponseDTO responseDto = new ResponseDTO();

        try {
            Object object = userRepo.findAdminUser(user.getUserName());
            if (object == null) {
                user.setIsActive(true);
                User createdUser = userRepo.save(user);         

                UserRole newUserRole = new UserRole();
                newUserRole.setUserName(createdUser.getUserName());
                newUserRole.setRole("ROLE_ADMIN");
                roleRepo.save(newUserRole);

                responseDto.setResult("Created");

                List list = userRepo.findAllAdminUsers();
                List<UserResponseDTO> admins = new ArrayList<UserResponseDTO>();
                for (int i = 0; i < list.size(); i++) {
                    Object[] row = (Object[]) list.get(i);
                    admins.add(new UserResponseDTO((String) row[0], (String) row[1], (Boolean) row[2]));
                }
                responseDto.setData(admins);
            } else {
                responseDto.setResult("Already Exists");
            }
        } catch (Exception e) {
            logger.error("Exception :" + e.getMessage());
            logger.warn("Stack Trace :" + e.getStackTrace());
        }
        logger.debug("Response :" + responseDto);
        logger.info("-----End of Method------ ");
        return responseDto;
    }

@Configuration
@EnableMBeanExport(registration = RegistrationPolicy.IGNORE_EXISTING)
public class BeanConfig {

    @SuppressWarnings("deprecation")
    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
        LocalContainerEntityManagerFactoryBean lemb = new LocalContainerEntityManagerFactoryBean();
        lemb.setDataSource(getJndiObjectFactoryBean());
        lemb.setJpaVendorAdapter(jpaVendorAdapter());
        lemb.setJpaDialect(new HibernateJpaDialect());
        // lemb.setJ
        Properties prop = new Properties();
        prop.put(org.hibernate.cfg.Environment.RELEASE_CONNECTIONS, ConnectionReleaseMode.AFTER_STATEMENT);
        // prop.put(org.hibernate.cfg.annotations.IdBagBinder.)
        lemb.setJpaProperties(prop);
        lemb.setPackagesToScan(new String[] { ("com.aadhaar.verify.model"), ("com.aadhaar.verify.response") });
        return lemb;

    }

    public JpaVendorAdapter jpaVendorAdapter() {
        HibernateJpaVendorAdapter jpaVendorAdapter = new HibernateJpaVendorAdapter();
        jpaVendorAdapter.setShowSql(false);
        jpaVendorAdapter.setGenerateDdl(false);
        // jpaVendorAdapter.setDatabase(Database.MYSQL);
        return jpaVendorAdapter;
    }

    @Bean
    public DataSource getJndiObjectFactoryBean() {
        // ComboPooledDataSource datasource = new ComboPooledDataSource();;
        // try {
        // datasource.setDriverClass("oracle.jdbc.driver.OracleDriver");
        // } catch (PropertyVetoException e) {
        // // TODO Auto-generated catch block
        // e.printStackTrace();
        // }

        // datasource.setMinPoolSize(5);
        // datasource.setMaxIdleTime(2000);
        // datasource.setMaxPoolSize(20);
        // datasource.setMaxStatements(2000);
        // return datasource;
        JndiObjectFactoryBean jobjFac = new JndiObjectFactoryBean();
        jobjFac.setJndiName("jdbc/AppzillonServerDS");
        try {
            jobjFac.setResourceRef(true);
            jobjFac.setProxyInterface(DataSource.class);
            jobjFac.afterPropertiesSet();
        } catch (IllegalArgumentException | NamingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();        
        }
        return (DataSource) jobjFac.getObject();
        /*
         * JndiDataSourceLookup dataSourceLookup = new JndiDataSourceLookup();
         * DataSource dataSource =
         * dataSourceLookup.getDataSource("jdbc/AppzillonServerDS"); return
         * dataSource;
         */
    }

Answer 1

尝试添加此属性

Properties prop = new Properties();
prop.put("hibernate.connection.release_mode", "auto");
prop.put("hibernate.connection.handling_mode", "DELAYED_ACQUISITION_AND_RELEASE_AFTER_STATEMENT");