<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    JAVA日志

    JAVA日志

     

    請大家?guī)兔?關(guān)于異常:org.springframework.transaction.TransactionSystemException

    最近在項目中間遇到一個棘手的問題,希望有經(jīng)驗的朋友能幫幫小弟,感激不盡。
    具體問題是:在工程部署到tomcat,然后啟動tamcat,登錄工程,無任何問題,但是問題出在大概一個小時以后,重新訪問工程,登錄時拋出如下異常:

     1Exception Type: org.springframework.transaction.TransactionSystemException 
     2
     3網(wǎng)絡(luò)正忙,請稍候再試!(RT) (Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed)
     4 
     5org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
     6org.hibernate.TransactionException: JDBC rollback failed
     7    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
     8    at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:603)
     9    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:583)
    10    at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:560)
    11    at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:284)
    12    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
    13    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
    14    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
    15    at $Proxy13.adminLogin(Unknown Source)
    16    at com.imart.web.servlet.AdminLoginServlet.onLogin(AdminLoginServlet.java:56)
    17    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    18    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    19    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    20    at java.lang.reflect.Method.invoke(Method.java:585)
    21    at com.imart.web.core.servlet.AbstractServlet.invokeMethodDispatcher(AbstractServlet.java:298)
    22    at com.imart.web.core.servlet.AbstractServlet.doGet(AbstractServlet.java:210)
    23    at com.imart.web.core.servlet.AbstractServlet.doPost(AbstractServlet.java:614)
    24    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    25    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    26    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    27    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    28    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    29    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    30    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    31    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    32    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    33    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    34    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    35    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    36    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    37    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    38    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    39    at java.lang.Thread.run(Thread.java:595)
    40Caused by: java.sql.SQLException: Couldn't perform the operation rollback: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
    41    at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
    42    at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
    43    at oracle.jdbc.internal.ClientDataSupport$$EnhancerByCGLIB$$772388fb.rollback()
    44    at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
    45    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
    46     32 more
    47 
    48
    不知這是否和spring的事務管理器配置有關(guān)
    配置如下:
      1<bean id="dataSource"
      2        class="org.logicalcobwebs.proxool.ProxoolDataSource">
      3        <property name="driver">
      4            <value>${jdbc.driver}</value>
      5        </property>
      6        <property name="driverUrl">
      7            <value>${jdbc.url}</value>
      8        </property>
      9        <property name="user">
     10            <value>${jdbc.username}</value>
     11        </property>
     12        <property name="password">
     13            <value>${jdbc.password}</value>
     14        </property>
     15        <property name="alias">
     16            <value>${proxool.alias}</value>
     17        </property>
     18        <property name="houseKeepingSleepTime">
     19            <value>${proxool.houseKeepingSleepTime}</value>
     20        </property>
     21        <property name="minimumConnectionCount">
     22            <value>${proxool.minimumConnectionCount}</value>
     23        </property>
     24        <property name="maximumConnectionCount">
     25            <value>${proxool.maximumConnectionCount}</value>
     26        </property>
     27        <property name="prototypeCount">
     28            <value>${proxool.prototypeCount}</value>
     29        </property>
     30        <property name="trace">
     31            <value>${proxool.trace}</value>
     32        </property>
     33        <property name="verbose">
     34            <value>${proxool.verbose}</value>
     35        </property>
     36    </bean>
     37
     38
     39    <!-- Hibernate, ORM and common Interceptors -->
     40    <bean id="sessionFactory"
     41        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
     42        <property name="configurationClass">
     43            <value>org.hibernate.cfg.AnnotationConfiguration</value>
     44        </property>
     45        <property name="configLocation">
     46            <value>/WEB-INF/${hibernate.cfg}</value>
     47        </property>
     48        <property name="hibernateProperties">
     49            <props>
     50                <prop key="hibernate.dialect">
     51                    ${hibernate.dialect}
     52                </prop>
     53                <prop key="hibernate.show_sql">${jdbc.showsql}</prop>
     54                <prop key="hibernate.use_outer_join">true</prop>
     55                <prop key="hibernate.format_sql">
     56                    ${jdbc.formate_sql}
     57                </prop>
     58                <prop key="hibernate.jdbc.batch_size">15</prop>
     59                <prop key="hibernate.jdbc.fetch_size">5</prop>
     60                <prop key="hibernate.default_batch_fetch_size">8</prop>
     61                <prop key="hibernate.connection.release_mode">
     62                    auto
     63                </prop>
     64            </props>
     65        </property>
     66        <property name="dataSource">
     67            <ref bean="dataSource" />
     68        </property>
     69
     70    </bean>
     71
     72
     73    <bean id="hibernateInterceptor"
     74        class="org.springframework.orm.hibernate3.HibernateInterceptor">
     75        <property name="sessionFactory">
     76            <ref bean="sessionFactory" />
     77        </property>
     78    </bean>
     79
     80    <bean id="transactionInterceptor"
     81        class="org.springframework.transaction.interceptor.TransactionInterceptor">
     82        <property name="transactionManager">
     83            <ref bean="transactionManager" />
     84        </property>
     85        <property name="transactionAttributeSource">
     86            <bean
     87                class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource" />
     88        </property>
     89    </bean>
     90
     91    <bean id="transactionManager"
     92        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
     93        <property name="sessionFactory">
     94            <ref local="sessionFactory"></ref>
     95        </property>
     96    </bean>
     97
     98    <bean id="abstractTxDefinition"
     99        class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"
    100        lazy-init="true">
    101        <property name="transactionManager">
    102            <ref bean="transactionManager" />
    103        </property>
    104        <property name="transactionAttributeSource">
    105            <bean
    106                class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource">
    107            </bean>
    108        </property>
    109    </bean>
    110
    111
    112    <!-- DAO -->
    113    <bean id="adminDAO" class="com.imart.model.dao.AdminDAO">
    114        <property name="sessionFactory">
    115            <ref bean="sessionFactory" />
    116        </property>
    117    </bean>
    118
    119
    120    <bean id="adminService" parent="abstractTxDefinition">
    121        <property name="proxyInterfaces">
    122            <value>com.imart.model.service.AdminService</value>
    123        </property>
    124        <property name="target">
    125            <bean class="com.imart.model.service.spi.AdminServiceImpl"
    126                init-method="init">
    127            </bean>
    128        </property>
    129    </bean>

    proxool配置如下
    #proxool setting
    proxool.alias
    =imart-sim
    proxool.houseKeepingSleepTime
    =30000
    proxool.minimumConnectionCount
    =5
    proxool.maximumConnectionCount
    =1000
    proxool.prototypeCount
    =5
    proxool.trace
    =false
    proxool.verbose
    =false
    proxool.maximumActiveTime
    =300000
    proxool.maximumConnectionLifetime
    =3060000000

    posted on 2007-12-15 11:54 小木 閱讀(19216) 評論(4)  編輯  收藏

    評論

    # re: 請大家?guī)兔?關(guān)于異常:org.springframework.transaction.TransactionSystemException 2008-04-11 16:37 liutr

    怎么解決的呀,,我也碰到了同樣的問題!!  回復  更多評論   

    # re: ?????æ ????????org.springframework.transaction.TransactionSystemException 2008-08-01 08:59 xuej

    怎么解決的呀,,我也碰到了同樣的問題!!   回復  更多評論   

    # re: 請大家?guī)兔?關(guān)于異常:org.springframework.transaction.TransactionSystemException 2008-12-08 10:42 wrong1111

    最近也碰到樓主的問題,正頭疼。。不知道樓主是怎么解決的??
    或者樓主有好的解決方法請 email :wrong1111@126.com
    或msn: woshixiaowangyong@163.com  回復  更多評論   

    # re: 請大家?guī)兔?關(guān)于異常:org.springframework.transaction.TransactionSystemException [未登錄] 2013-04-26 11:31 simon

    查詢語句出錯,或者是查詢參數(shù)有問題,導致超時,導致spring報上述錯誤。  回復  更多評論   


    只有注冊用戶登錄后才能發(fā)表評論。


    網(wǎng)站導航:
     

    導航

    統(tǒng)計

    常用鏈接

    留言簿(1)

    隨筆檔案

    相冊

    搜索

    最新評論

    閱讀排行榜

    評論排行榜

    主站蜘蛛池模板: 亚洲国产高清人在线| 一本色道久久综合亚洲精品蜜桃冫| 一级毛片免费观看不卡的| 亚洲国产中文在线视频| 永久免费观看的毛片的网站| 国产免费MV大全视频网站| 91亚洲国产成人精品下载| 又粗又大又长又爽免费视频| 免费a级毛片无码a∨免费软件| a级午夜毛片免费一区二区| 亚洲一级在线观看| 亚洲美女高清一区二区三区 | 亚洲一区二区三区写真| 国产午夜亚洲精品国产成人小说| 无套内谢孕妇毛片免费看看 | 日韩毛片一区视频免费| 亚洲美女aⅴ久久久91| 亚洲国产成人精品91久久久| 最近中文字幕完整免费视频ww | 亚洲国产日韩a在线播放| 亚洲国产一成人久久精品| 成人性生免费视频| 2022久久国产精品免费热麻豆| 免费看内射乌克兰女| 亚洲国产精品一区二区久| 亚洲乱亚洲乱妇无码麻豆| 国产成人免费a在线视频色戒| 99久久免费精品视频| 一级毛片免费在线| 亚洲狠狠婷婷综合久久| 亚洲高清在线mv| 亚洲AV无码久久精品成人| 亚洲精品尤物yw在线影院| 香蕉高清免费永久在线视频 | 四虎影永久在线高清免费 | 亚洲av日韩av高潮潮喷无码| 久久久青草青青国产亚洲免观 | 亚洲精品视频免费看| 黄桃AV无码免费一区二区三区| 亚洲国产精品线在线观看| 国产亚洲一区区二区在线|