spring，使用HikariCP VS c3p0，相同的代码，不同的结果

Question

环境

HikariCP version: HikariCP-java7 2.4.13
JDK version     : 1.7.0_080
Database        : PostgreSQL
Driver version  : 9.1-901.jdbc3

  @Transactional
   public Integer enableItem(Long id){

       //change item status from 0 to 1
       Integer result = itemDao.enableItem(id);

       //load item

       //if c3p0 , item status is new value 1
       // but Hikari, item status still is 0
       Item item = itemDao.findItemById(id);
       return result;
   }

    <property name="driverClassName" value="#{meta['dataSource.driverClassName']}" />
    <property name="jdbcUrl" value="#{meta['dataSource.url']}" />
    <property name="username" value="#{meta['dataSource.username']}" />
    <property name="password" value="#{meta['dataSource.password']}" />
    <property name="readOnly" value="false" />

    <property name="idleTimeout" value="#{meta['dataSource.maxIdleTime']}" />
    <property name="connectionTimeout" value="30000" />
    <property name="maxLifetime" value="1800000" /> 
    <property name="maximumPoolSize" value="#{meta['dataSource.maxPoolSize']}" />

    <property name="minimumIdle" value="#{meta['dataSource.minPoolSize']}" />
</bean>

Answer 1

这两个连接池可能具有不同的事务隔离级别默认值。

尝试添加