4 Replies Latest reply: May 21, 2012 9:43 AM by Joe Weinstein-Oracle RSS

    <Error> <HTTP> <BEA-101020> <[weblogic.servlet.internal.WebAppServletContex

    818997
      JDBC Connection Pool in WebLogic grtting full.

      The server WLS10.3 is configured with 1Gb JVM and JRockit jrrt-4.0.0-1.6.0 on solaris platform
      MEM_ARGS="-Xms1g -Xmx1g -Xgcprio:throughput -Xverbose:gc -XX:+HeapDumpOnOutO
      fMemoryError -XXcompressedRefs:enable=true"

      We are using the following settings for the JDBC-Connection:
      initial capacity = 1
      max. capacity = 15
      Capacity increment = 1
      Statement cache type = LRU
      Statement cache size = 10
      Test connections on reserve = true
      Test frequency = 120
      Test table name = "sql select 1 from dual"
      seconds to trust an idle pool connection = 10
      shrink frequency = 900
      connection creation retry frequency = 0
      login delay = 0
      incative connection timeout = 0
      max. waiting for connection = 2147483647
      connection reserve timeout= = 10
      Ignare in-use connections = true
      pinned-to-thread = false
      remove infected connections enabled = true

      Does anyone have an idea how to track/solve this issue?

      <Jan 02, 2011 3:36:11 PM PST> <Warning> <Socket> <BEA-000449> <Closing socket as no data read from it during the configu
      red idle timeout of 5 secs>
      15:36:15,565 WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: null
      15:36:23,226 ERROR JDBCExceptionReporter:78 - Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.Re
      sourceLimitException: No resources currently available in pool beetel Data Source to allocate to applications, please i
      ncrease the size of the pool and retry..
      <Jan 02, 2011 3:36:34 PM PST> <Warning> <Socket> <BEA-000449> <Closing socket as no data read from it during the configu
      red idle timeout of 5 secs>
      15:36:34,594 ERROR AbstractEntityManagerImpl:592 - Unable to mark for rollback on PersistenceException:
      java.lang.IllegalStateException: Transaction does not exist
      at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:314)
      at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(TransactionManagerImpl.java:309)
      at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(AbstractEntityManagerImpl.java:433)
      at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:588)
      at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:630)
      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
      at org.springframework.orm.jpa.JpaTemplate$10.doInJpa(JpaTemplate.java:333)
      at org.springframework.orm.jpa.JpaTemplate.findByNamedParams(JpaTemplate.java:325)
      at com.tfs.beetel.common.dao.RolePrivilegeDAO.fetchAccessRoleScreenPrivileges(RolePrivilegeDAO.java:213)
      at com.tfs.beetel.faps.domain.business.RolePrivilegeBusinessManager.fetchAccessControlData(RolePrivilegeBusiness
      Manager.java:271)
      at sun.reflect.GeneratedMethodAccessor7120.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
      at $Proxy130.fetchAccessControlData(Unknown Source)
      at com.tfs.beetel.faps.domain.app.RolePrivilegeAppManager.fetchAccessControlData(RolePrivilegeAppManager.java:10
      9)
      at com.tfs.beetel.faps.arch.web.SecurityFilter.doFilter(SecurityFilter.java:116)
      at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
      at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:176)
      at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:168)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:43)
      at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      <Jan 02, 2011 3:36:42 PM PST> <Warning> <Socket> <BEA-000449> <Closing socket as no data read from it during the configu
      red idle timeout of 5 secs>
      <Jan 02, 2011 3:37:24 PM PST> <Error> <HTTP> <BEA-101020> <[weblogic.servlet.internal.WebAppServletContext@1b5f61fe - ap
      pName: 'faps-app', name: 'faps', context-path: '/faps', spec-version: '2.5'] Servlet failed with Exception
      org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL
      [???]; SQL state [null]; error code [0]; Cannot open connection; nested exception is org.hibernate.exception.GenericJDB
      CException: Cannot open connection
      at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.ja
      va:642)
      at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:
      95)
      at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:212)
      at org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(JpaAccessor.java:152)
      at org.springframework.orm.jpa.JpaTemplate.execute(JpaTemplate.java:189)
      Truncated. see log file for complete stacktrace
      org.hibernate.exception.GenericJDBCException: Cannot open connection
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
      at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:424)
      Truncated. see log file for complete stacktrace
      java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: N
      o resources currently available in pool beetel Data Source to allocate to applications, please increase the size of the
      pool and retry..
      at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1311)
      at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:425)
      at weblogic.jdbc.jta.DataSource.connect(DataSource.java:382)
      at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:338)
      at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionP
      rovider.java:47)
      Truncated. see log file for complete stacktrace