Spring JDBCTemplate-并发调用

Question

在oracle.jdbc.driver.t4cttioer.ProcessErr(t4cttioer.java:450)在oracle.jdbc.driver.t4cttioer.processErr(t4cttioer.java:399)在oracle.jdbc.driver.t4c8oall.processErr(t4c8oall.java:1017)在oracle.jdbc.driver.t4cttifun.receive(t4cttifun.java:655)在C.driver.OraclePreparedStatementWrapper.ExecuteQuery（OraclePreparedStatementWrapper.java:1502)，位于org.springframework.jdbc.core.jdbcTemplate$1。doInPreparedStatement（jdbcTemplate.692)，位于org.springframework.jdbc.core.jdbcTemplate.execute（jdbcTemplate.633)...18其他

为了在parellel中执行该方法，我需要对此进行任何更改吗？

    @Repository
public class TransactionRespository {
    private static Logger LOG = LoggerFactory.getLogger(TransactionRespository.class);

    @Autowired
    private NamedParameterJdbcTemplate jdbcTemplate;

    private String transactionQuery = " query goes here";

    public TransactionDetails getTransactionResult(String serviceName, String operationName, Date startDate,
            Date endDate) {

        SqlParameterSource namedParameters = new MapSqlParameterSource("serviceName", serviceName)
                .addValue("operationName", operationName)
                .addValue("startDate", new DateTime(startDate).toString("yyyy-MM-dd HH:mm:ss"))
                .addValue("endDate", new DateTime(endDate).toString("yyyy-MM-dd HH:mm:ss"));

        try{
            return (TransactionDetails) this.jdbcTemplate.queryForObject(transactionQuery, namedParameters,(rs,rowNum)->{
                TransactionDetails transactionDetails = new TransactionDetails();
                TransactionResult result = new TransactionResult();
                transactionDetails.setStartDate(new DateTime(startDate).toString("yyyy-MM-dd HH:mm:ss"));
                transactionDetails.setEndDate(new DateTime(endDate).toString("yyyy-MM-dd HH:mm:ss"));
                result.setSuccessfulTransactions(rs.getInt(2));
                result.setFailedTransactions(rs.getInt(3));
                Map<String,TransactionResult> operationResult = new TreeMap<>();
                operationResult.put(operationName, result);
                transactionDetails.setOperationResult(operationResult);

                return transactionDetails;
            });         
        }  catch (EmptyResultDataAccessException e) {
            LOG.debug("start date :: {} , end date :: {} " , new DateTime(startDate).toString("yyyy-MM-dd HH:mm:ss"), new DateTime(endDate).toString("yyyy-MM-dd HH:mm:ss"));
            return null;
        }


    }

Answer 1

getTransactionResult（...）没有任何同步。容器可以管理东西，但它是由你来维持秩序。容器没有办法知道什么需要同步。

您可以使方法同步或遵循以下操作

同步方法还是使用spring@Transactional？