connections total > max capacity

[inumen]

I have some problem in my connection pool.

Enviroment: weblogic7.0.1, oracle9i 9.2.0.1.0

Some connection pools (total 11 connection pools, each have about 30 max
capacity, initial is 10) configured in my system, When I monitor the
jdbc, there is an error, open the error shows:

javax.management.InstanceNotFoundException:
mydomain:Name=testPool,Type=JDBCConnectionPool (admin server:true)
at
weblogic.management.internal.MBeanHomeImpl.getMBean(MBeanHomeImpl.java:142)
at
weblogic.management.internal.AdminMBeanHomeImpl.getMBean(AdminMBeanHomeImpl.
java:241)
at weblogic.management.console.utils.MBeans.getMBean(MBeans.java:1473)
at
weblogic.management.console.utils.MBeans.getConfigurationBeanFor(MBeans.java
:2389)
at
weblogic.management.console.info.MBeanParentAttribute.doGet(MBeanParentAttri
bute.java:96)
at
weblogic.management.console.tags.table.AttributeCellPrinter.doCellContents(A
ttributeCellPrinter.java:55)
at
weblogic.management.console.tags.table.TableTag.printTable(TableTag.java:554
)
at
weblogic.management.console.tags.table.TableTag.doEndTag(TableTag.java:342)
at
weblogic.management.console.webapp._domain.__jdbcconnectionpoolruntimetable.
_jspService(__jdbcconnectionpoolruntimetable.java:374)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:306)
at
weblogic.servlet.internal.RequestDispatcherImpl$ForwardAction.run(RequestDis
patcherImpl.java:341)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:744)
at
weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImp
l.java:251)
at weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:116)
at
weblogic.management.console.actions.ForwardAction.perform(ForwardAction.java
:35)
at
weblogic.management.console.actions.internal.ActionServlet.doAction(ActionSe
rvlet.java:171)
at
weblogic.management.console.actions.internal.ActionServlet.doGet(ActionServl
et.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(Servle
tStubImpl.java:1058)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:401)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:306)
at
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(W
ebAppServletContext.java:5412)
at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManage
r.java:744)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:3086)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:2544)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:153)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)


but the system can run normally. then some days passed, I monitor the
connection again, I found connection total > max capacity (36>30)

      JDBC Connection Pool Server Machine Connections High Wait Seconds High
Waiters Waiters High Connections Total Connections Driver Version Max
Capacity
       (error) myserver   10 0 0 3 36 0 oracle.jdbc.driver.OracleDriver 30

[Joe Weinstein]

Hi.
If you could please turn on jdbc logging, th jdbc log file would
have some interesting info about the first exception. Regarding total
> max, our docs *should* define 'total' to mean the number of connections
this pool has ever made. In other words, if a pool had nin=max=10, and
over the course of time, it's refresh/test of connections have found
5 connections that had died and had to be replaced, then 'total' would
be 15, where the current count would still be 10.
Joe

[inumen]

Thanks for your reply. I have turned on the jdbc log.
which increase quickly, in a short time it reached more than 100M, but I
could't find any information about error
or exception
"Joe Weinstein" <joeN...@bea.com> ???? news:3FF59F71...@bea.com...

[Joe Weinstein]

inumen wrote:

> Thanks for your reply. I have turned on the jdbc log.
> which increase quickly, in a short time it reached more than 100M, but I
> could't find any information about error
> or exception

Yes, it does grow quickly... So you saw no exceptions in the log? And
the total still got bigger than max?
Joe