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(
at weblogic.transaction.internal.TransactionManagerImpl.setRollbackOnly(
at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(
at org.hibernate.ejb.QueryImpl.getResultList(
at org.springframework.orm.jpa.JpaTemplate$10.doInJpa(
at org.springframework.orm.jpa.JpaTemplate.findByNamedParams(
at com.tfs.beetel.common.dao.RolePrivilegeDAO.fetchAccessRoleScreenPrivileges(
at sun.reflect.GeneratedMethodAccessor7120.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
at $Proxy130.fetchAccessControlData(Unknown Source)
at com.tfs.beetel.faps.arch.web.SecurityFilter.doFilter(
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
at weblogic.servlet.internal.FilterChainImpl.doFilter(
at weblogic.servlet.internal.RequestEventsFilter.doFilter(
at weblogic.servlet.internal.WebAppServletContext$
at weblogic.servlet.internal.WebAppServletContext.execute(
<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
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(
at org.springframework.orm.jpa.JpaAccessor.translateIfNecessary(
at org.springframework.orm.jpa.JpaTemplate.execute(
Truncated. see log file for complete stacktrace
org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
at org.hibernate.exception.SQLStateConverter.convert(
at org.hibernate.exception.JDBCExceptionHelper.convert(
at org.hibernate.exception.JDBCExceptionHelper.convert(
at org.hibernate.jdbc.ConnectionManager.openConnection(
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(
at weblogic.jdbc.jta.DataSource.getConnection(
at weblogic.jdbc.jta.DataSource.connect(
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(
at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionP
Truncated. see log file for complete stacktrace


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