Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to eliminate DB Connection leakage error

 
arullis michaelraj
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • 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 ]
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • 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.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65340
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
arrulis, read this.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic