內(nèi)蒙古java團隊

          j2se,j2ee開發(fā)組
          posts - 139, comments - 212, trackbacks - 0, articles - 65
            BlogJava :: 首頁 :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理
          大家?guī)兔纯词鞘裁磫栴},總出現(xià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)閉的語句
          java.sql.SQLException:?關(guān)閉的語句
          ????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)


          評論

          # re: proxool--- java.sql.SQLException: 關(guān)閉的語句? [未登錄]  回復  更多評論   

          2009-11-25 09:27 by 帥子
          問題已經(jīng)解決,導致這個錯誤原因是在于,連接池用完導致的。
          在使用proxool的時候一定要注意,在它啟動的時候已經(jīng)初始化連接池,我們在它上層所作的操作,如上層連接池,一定要實例化,并在每次操作完成后一定要關(guān)閉對應的連接對象,否則得話連接池很快被消耗完。或者是kill線程。
          主站蜘蛛池模板: 白玉县| 金坛市| 荆门市| 阳山县| 毕节市| 乌鲁木齐市| 梁平县| 桐庐县| 平阴县| 习水县| 莱西市| 凤城市| 都江堰市| 米易县| 望江县| 永登县| 濮阳市| 蚌埠市| 洛南县| 余江县| 万宁市| 甘南县| 陆河县| 井陉县| 奉新县| 湘阴县| 化隆| 桦南县| 利辛县| 汕头市| 麻阳| 肥乡县| 乾安县| 淮南市| 嘉兴市| 永年县| 锦屏县| 青阳县| 融水| 宾阳县| 获嘉县|