SSH项目中隔天访问的JDBC rollback failed

Question

RT，在我隔天尝试登录SSH web项目时，总会发生JDBC rollback failed的问题，log如图，按照网上各种线索（修改连接池、配置）均未能够解决，不知道是我的配置文件有问题（附在题尾）还是说应该换一个连接池呢？


配置文件如下

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.0.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method="close">
        <property name="driverClass" value="oracle.jdbc.driver.OracleDriver" />
        <property name="jdbcUrl" value="jdbc:oracle:thin:@ip:ORCL" /> 
        <property name="user" value="user" />
        <property name="password" value="passwd" /> 
    </bean>
    <bean id="nativeJdbcExtractor" lazy-init="true"
        class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" />
        
    <bean id="lobHandler" lazy-init="false"
        class="org.springframework.jdbc.support.lob.OracleLobHandler">
        <property name="nativeJdbcExtractor">
            <ref bean="nativeJdbcExtractor" />
        </property>
    </bean>
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
        <property name="lobHandler" ref="lobHandler" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.OracleDialect
                </prop>
                <prop key="hibernate.connection.release_mode">auto</prop>
                <prop key="hibernate.max_fetch_depth">0</prop>
                <prop key="hibernate.generate_statistics">true</prop>
                <prop key="hibernate.cache.use_query_cache">true</prop>
                <prop key="hibernate.jdbc.batch_size">50</prop>
                <prop key="hibernate.cache.use_second_level_cache">true</prop>
                <prop key="cglib.use_reflection_optimizer">false</prop>
                <prop key="hibernate.cache.provider_class">
                    org.hibernate.cache.HashtableCacheProvider
                </prop>
                <prop key="hibernate.query.factory_class">
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                </prop>
                <prop key="hibernate.show_sql">false</prop>
                <prop key="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop>
                <prop key="hibernate.c3p0.min_size">8</prop>
                <prop key="hibernate.c3p0.max_size">200</prop>
                <prop key="hibernate.c3p0.timeout">600</prop>
                <prop key="hibernate.c3p0.max_statements">0</prop>
                <prop key="hibernate.c3p0.idle_test_period">60</prop>
                <prop key="hibernate.c3p0.acquire_increment">2</prop>
                <prop key="hibernate.c3p0.validate">true</prop>
            </props>
        </property>
        <property name="mappingResources">
        </property>
    </bean>
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
    <aop:aspectj-autoproxy proxy-target-class="true" />
    <tx:annotation-driven transaction-manager="transactionManager" />
</beans>

Answer 1

出现这个问题的原因很简单rollback 操作需要jdbc连接存放,就是说,连接上mysql后得到一个jdbc连接,这个连接不关闭才可以进行rollback操作
通过的截图开看,你在执行rollback连接是时候jdbc连接已经关闭了