斷點(diǎn)

          每天進(jìn)步一點(diǎn)點(diǎn)!
          posts - 174, comments - 56, trackbacks - 0, articles - 21

          Caused by: weblogic.jdbc.extensions.PoolLimitSQLException

          Posted on 2010-07-04 11:05 斷點(diǎn) 閱讀(5020) 評(píng)論(0)  編輯  收藏 所屬分類(lèi): 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的連接池已滿(mǎn),需要重新設(shè)置或者重啟weblogic的AdminServer服務(wù)器進(jìn)行釋放連接。
          操作:進(jìn)入weblogic控制臺(tái),選擇:域-->Services-->JDBC-->Data Source-->點(diǎn)擊control-->選中AdminServer,對(duì)其重啟即可。

          主站蜘蛛池模板: 共和县| 成都市| 水富县| 沙湾县| 临澧县| 广河县| 南陵县| 于都县| 松溪县| 微山县| 武汉市| 北海市| 宜丰县| 延津县| 石柱| 上林县| 四平市| 巩留县| 惠安县| 石嘴山市| 浦北县| 柏乡县| 虞城县| 环江| 额尔古纳市| 浦东新区| 宁强县| 南投市| 万年县| 潮安县| 安康市| 台中市| 巴马| 称多县| 乌苏市| 绥江县| 温宿县| 拉萨市| 阳新县| 交城县| 达州市|