Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

How to eliminate DB Connection leakage error

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi friends,

I am getting DB Connection leakage error.

What is the solution for DB connection leakage .
What are all ways to eliminate DB connection leakage.
please reply immediately.


<001074>
at weblogic.jdbc.pool.Connection.(Connection.java:62)
at weblogic.jdbc.pool.Driver.allocateConnection(Driver.java:289)
at weblogic.jdbc.pool.Driver.connect(Driver.java:205)
at com.atroad.util.GenericConnectionPool.getConnection(Unknown Source)
at com.atroad.adm.asap.util.ConnectionPool.getConnection(Unknown Source)
at examples.jsp._adm._asap.__CustomerEdit._jspService(__CustomerEdit.java:463)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:20)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5451)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:780)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3105)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2588)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:213)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:189)
>
<001074>
at weblogic.jdbc.pool.Connection.(Connection.java:62)
at weblogic.jdbc.pool.Driver.allocateConnection(Driver.java:289)
at weblogic.jdbc.pool.Driver.connect(Driver.java:205)
at com.atroad.util.GenericConnectionPool.getConnection(Unknown Source)
at com.atroad.adm.asap.util.DBUtil.getConnection(Unknown Source)
at com.atroad.adm.asap.util.DBUtil.getConnection(Unknown Source)
at com.atroad.adm.asap.feature.customerservice.CustomerServiceHelper.getServiceProfileInfo(Unknown Source)
at com.atroad.adm.asap.feature.customerservice.CustomerServiceHelper.getServiceProfileList(Unknown Source)
at examples.jsp._adm._asap._feaInc.__41_inc._jspService(__41_inc.java:304)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:20)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:546)
at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:369)
at weblogic.servlet.jsp.PageContextImpl.include(PageContextImpl.java:136)
at examples.jsp._adm._asap.__FeatureEdit._jspService(__FeatureEdit.java:2701)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:27)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1058)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:401)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:20)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5451)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:780)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3105)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2588)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:213)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:189)
[ June 29, 2005: Message edited by: Bear Bibeault ]
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Arullis,
I presume the packages whose names start with "com.atroad" (that appear in the stack trace you provided) are your classes (as opposed to WebLogic's classes). If that is correct, then I suggest you compile your classes with the "-g" flag. Then, in the stack trace, instead of "Unknown source", you will see the name and line-number of the offending source code. This may make it easier for you to debug your code.

Secondly, since you didn't post the part of your code that is causing the error, I can only suggest the obvious: are you closing your "ResultSet"s, "Statement"s and [database] "Connection"s?

Good Luck,
Avi.
 
Sheriff
Posts: 67592
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
arrulis, read this.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic