Spring Boot JPA和HikariCP维护活动连接

Question

简介：

null

问题是，在提交通过长时间运行的任务全程记录后，连接池使用“活动”连接。如果突发足够大，这可能会耗尽我拥有的任何大小的池。

我正在使用具有以下结构的spring boot：

1. 控制器-在“/”处响应，并使“服务”autowired。
2. 服务-包含与数据库交互的所有JPA存储库和@Transactional方法。

@Service
@Slf4j
class SubmissionService {

@Autowired
CompanyRepository companyRepository;

@Autowired
SubmissionRepository submissionRepository;

@Autowired
FailureRepository failureRepository;

@Autowired
DataSource dataSource

@Transactional(readOnly = true)
public Long getCompany(String apiToken){
    if(!apiToken){
        return null
    }
    return companyRepository.findByApiToken(apiToken)?.id
}

@Transactional
public void successSubmission(Long id) {
    log.debug("updating submission ${id} to success")
    def submissionInstance = submissionRepository.findOne(id)
    submissionInstance.message = "successfully analyzed."
    submissionInstance.success = true
    submissionRepository.save(submissionInstance)
}

@Transactional
public long createSubmission(Map properties) {
    log.debug("creating submission ${properties}")
    dataSource.pool.logPoolState()
    def submissionInstance = new Submission()
    for (key in properties.keySet()) {
        if(submissionInstance.hasProperty(key)){
            submissionInstance."${key}" = properties.get(key)
        }
    }
    submissionInstance.company = companyRepository.findOne(properties.companyId)
    submissionRepository.save(submissionInstance)
    return submissionInstance.id
}

@Transactional
public Long failureSubmission(Exception e, Object analysis, Long submissionId){
    //Track the failures
    log.debug("updating submission ${submissionId} to failure")
    def submissionInstance
    if (submissionId) {
        submissionInstance = submissionRepository.findOne(submissionId)
        submissionRepository.save(submissionInstance)
    }

    def failureInstance = new Failure(submission: submissionInstance, submittedJson: JsonOutput.toJson(analysis), errorMessage: e.message)

    failureRepository.save(failureInstance)

    return failureInstance.id
  }
}

Answer 1

事实证明@M.Deinum走上了正确的轨道。如果应用程序属性Spring.JPA.open_in_view设置为true，则Spring Boot JPA自动打开“OpenEntityManagerInViewFilter”（默认情况下为true）。我在JPA配置源中找到了这个。

将此设置为false后，数据库会话就不会继续了，我的问题也就消失了。