This discussion is archived
4 Replies Latest reply: May 21, 2012 7:43 AM by Joe Weinstein RSS

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

818997 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points