斷點

          每天進步一點點!
          posts - 174, comments - 56, trackbacks - 0, articles - 21

          Caused by: weblogic.jdbc.extensions.PoolLimitSQLException

          Posted on 2010-07-04 11:05 斷點 閱讀(5027) 評論(0)  編輯  收藏 所屬分類: WebLogic
          increase the size of the pool and retry..] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          PCIS[2010-07-01 12:51:47,456]>> WARN>> [SQL Error: 0, SQLState: null] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          PCIS[2010-07-01 12:51:47,456]>>ERROR>> [Cannot obtain connection: driverURL = jdbc:weblogic:pool:pcis_ts, props = {EmulateTwoPhaseCommit=false, connectionPoolID=pcis_ts, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=pcis_ts}] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          PCIS[2010-07-01 12:51:47,456]>> WARN>> [SQL Error: 0, SQLState: null] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          PCIS[2010-07-01 12:51:47,456]>>ERROR>> [weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool pcis_ts to allocate to applications, please increase the size of the pool and retry..] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          PCIS[2010-07-01 12:51:47,456]>> WARN>> [SQL Error: 0, SQLState: null] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          PCIS[2010-07-01 12:51:47,456]>>ERROR>> [Cannot obtain connection: driverURL = jdbc:weblogic:pool:pcis_ts, props = {EmulateTwoPhaseCommit=false, connectionPoolID=pcis_ts, jdbcTxDataSource=true, LoggingLastResource=false, dataSourceName=pcis_ts}] - [org.hibernate.util.JDBCExceptionReporter] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kerne
          l.Default (self-tuning)']
          [com.pcis.premium.service.PremiumService] -950125750 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] 
          org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool pcis_ts to allocate to applications, please increase the size of the pool and retry..; nested exception is weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool pcis_ts to allocate to applications, please increase the size of the pool and retry..
                  at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
                  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
                  at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
                  at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
                  at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:379)
                  at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:872)
                  at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:868)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
                  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
                  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
                  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
                  at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:168)
                  at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:183)
                  at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
                  at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:99)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
                  at com.isoftstone.iaeap.web.filter.SetCharacterEncodingFilter.doFilter(Unknown Source)
                  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
                  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3393)
                  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                  at weblogic.security.service.SecurityManager.runAs(Unknown Source)
                  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
                  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
                  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
                  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
                  at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
          Caused by: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool pcis_ts to allocate to applications, please increase the size of the pool and retry..
                  at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:242)
                  at weblogic.jdbc.pool.Driver.connect(Driver.java:160)
                  at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:642)
                  at weblogic.jdbc.jts.Driver.connect(Driver.java:124)
                  at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:339)
                  at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
                  at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
                  at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
                  at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
                  at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
                  at org.hibernate.loader.Loader.doQuery(Loader.java:673)
                  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
                  at org.hibernate.loader.Loader.doList(Loader.java:2213)
                  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
                  at org.hibernate.loader.Loader.list(Loader.java:2099)
                  at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
                  at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
                  at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
                  at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
                  at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
                  at org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:881)
                  at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:374)
                  ... 31 more

          原因:主要是weblogic的連接池已滿,需要重新設置或者重啟weblogic的AdminServer服務器進行釋放連接。
          操作:進入weblogic控制臺,選擇:域-->Services-->JDBC-->Data Source-->點擊control-->選中AdminServer,對其重啟即可。

          主站蜘蛛池模板: 桃江县| 锡林浩特市| 霸州市| 兴文县| 金寨县| 峨边| 定陶县| 汉沽区| 泰宁县| 巴中市| 彰化市| 五大连池市| 三门峡市| 镇宁| 运城市| 徐州市| 阿坝| 荆州市| 澄迈县| 苗栗县| 边坝县| 绥阳县| 安化县| 嵊泗县| 山阳县| 资阳市| 凉城县| 武山县| 株洲市| 孟村| 平江县| 尚义县| 茶陵县| 库伦旗| 马山县| 彰化市| 金坛市| 永安市| 咸宁市| 汶上县| 获嘉县|