內(nèi)蒙古java團(tuán)隊(duì)

          j2se,j2ee開(kāi)發(fā)組
          posts - 139, comments - 212, trackbacks - 0, articles - 65
            BlogJava :: 首頁(yè) :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理
          大家?guī)兔纯词鞘裁磫?wèn)題,總出現(xiàn)這個(gè)問(wèn)題。

          370313?[HouseKeeper]?WARN?proxool.admin??-?#0001?was?active?for?302484?milliseconds?and?has?been?removed?automaticaly.?The?Thread?responsible?was?named?'ExecuteThread:?'14'?for?queue:?'weblogic.kernel.Default''.
          386469?[ExecuteThread:?'10'?for?queue:?'weblogic.kernel.Default']?ERROR?DBcon_Platform??-?Query:select?*?from?org_users?where?user_account=?'admin'?---關(guān)閉的語(yǔ)句
          java.sql.SQLException:?關(guān)閉的語(yǔ)句
          ????at?oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
          ????at?oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
          ????at?oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
          ????at?oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:3249)
          ????at?oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1106)
          ????at?sun.reflect.NativeMethodAccessorImpl.invoke0(Native?Method)
          ????at?sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          ????at?sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          ????at?java.lang.reflect.Method.invoke(Method.java:324)
          ????at?org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
          ????at?org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$1a4cadea.executeQuery(<generated>)
          ????at?org.ws.jbpm.framework.db.DBConnection.executeQuery(DBConnection.java:165)
          ????at?org.ws.jbpm.framework.db.DBBusinessServices.executeQuery(DBBusinessServices.java:35)
          ????at?org.ws.jbpm.framework.db.dao.impl.User.getuserbyaccount(User.java:71)
          ????at?com.ws.jbpm.strtus.config.Security.providers.dao.jdbcDaoImpl.loadUserByUsername(jdbcDaoImpl.java:49)
          ????at?net.sf.acegisecurity.providers.dao.DaoAuthenticationProvider.getUserFromBackend(DaoAuthenticationProvider.java:390)
          ????at?net.sf.acegisecurity.providers.dao.DaoAuthenticationProvider.authenticate(DaoAuthenticationProvider.java:225)
          ????at?net.sf.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:159)
          ????at?net.sf.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:49)
          ????at?net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:372)
          ????at?net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:81)
          ????at?net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter(SecurityEnforcementFilter.java:182)
          ????at?net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
          ????at?net.sf.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:153)
          ????at?net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
          ????at?net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:305)
          ????at?net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
          ????at?net.sf.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:226)
          ????at?net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
          ????at?net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
          ????at?net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:125)
          ????at?weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
          ????at?weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6724)
          ????at?weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
          ????at?weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
          ????at?weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
          ????at?weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
          ????at?weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
          ????at?weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)


          評(píng)論

          # re: proxool--- java.sql.SQLException: 關(guān)閉的語(yǔ)句? [未登錄](méi)  回復(fù)  更多評(píng)論   

          2009-11-25 09:27 by 帥子
          問(wèn)題已經(jīng)解決,導(dǎo)致這個(gè)錯(cuò)誤原因是在于,連接池用完導(dǎo)致的。
          在使用proxool的時(shí)候一定要注意,在它啟動(dòng)的時(shí)候已經(jīng)初始化連接池,我們?cè)谒蠈铀鞯牟僮鳎缟蠈舆B接池,一定要實(shí)例化,并在每次操作完成后一定要關(guān)閉對(duì)應(yīng)的連接對(duì)象,否則得話連接池很快被消耗完。或者是kill線程。
          主站蜘蛛池模板: 永定县| 西乌| 沁阳市| 玛曲县| 汝城县| 上杭县| 祁阳县| 尼木县| 鄯善县| 正安县| 庆城县| 景宁| 大余县| 海安县| 澄迈县| 鄂州市| 湖南省| 河源市| 绍兴市| 木兰县| 山阳县| 尼玛县| 南昌市| 阿克苏市| 高阳县| 拜城县| 中西区| 顺昌县| 鸡泽县| 延川县| 锦州市| 山丹县| 海安县| 遂溪县| 屏边| 绥棱县| 玛纳斯县| 建湖县| 滁州市| 三门峡市| 织金县|