Eclipse Community Forums: BIRT » DBCP BIRT connection problem

Home » Archived » BIRT » DBCP BIRT connection problem

DBCP BIRT connection problem [message #176798]

Wed, 12 July 2006 10:26

Eclipse User

Hi. I'm having the following exceptions with the BIRT reports when I've
tryied to run them into production. It seams is a problem with the DB
connection. Can anybody tell me why's happening and how can I solve it?

Thank you.

DBCP object created 2006-07-09 11:20:09 by the following code was never
closed:

java.lang.Exception

at
org.apache.tomcat.dbcp.dbcp.AbandonedTrace.setStackTrace(Aba ndonedTrace.java:157)

at
org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject (AbandonedObjectPool.java:76)

at
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection( PoolingDataSource.java:95)

at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(Ba sicDataSource.java:540)

at
org.eclipse.birt.report.data.oda.subjdbc.SubOdaJdbcDriver.se tAppContext(SubOdaJdbcDriver.java:39)

at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDr iver.setAppContext(OdaDriver.java:355)

at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:121)

at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:154)

at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:147)

at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:150)

at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.ope nDataSource(PreparedQuery.java:838)

at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:661)

at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)

at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)

at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)

at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)

at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)

at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:122)

at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:187)

at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)

at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)

at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)

at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)

at
org.eclipse.birt.report.services.ReportEngineService.runAndR enderReport(Unknown
Source)

at
org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown
Source)

at
org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
Source)

at
org.eclipse.birt.report.viewer.servlet.ViewerServlet.doGet(U nknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)

at
net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:292)

at
net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor .invoke(FilterSecurityInterceptor.java:108)

at
net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter .doFilter(SecurityEnforcementFilter.java:197)

at
net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)

at
net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFi lter(BasicProcessingFilter.java:214)

at
net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)

at
net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(Ab stractProcessingFilter.java:324)

at
net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)

at
net.sf.acegisecurity.context.HttpSessionContextIntegrationFi lter.doFilter(HttpSessionContextIntegrationFilter.java:220)

at
net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)

at
net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterCh ainProxy.java:173)

at
net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterT oBeanProxy.java:120)

at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)

at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)

at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)

at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)

at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)

at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)

at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)

at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)

at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)

at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)

at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)

at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)

at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)

at java.lang.Thread.run(Thread.java:595)

Re: DBCP BIRT connection problem [message #176908 is a reply to message #176798]

Wed, 12 July 2006 11:38

Eclipse User

Why are you using this:
SubOdaJdbcDriver?
2.1 Supports using JNDI.
It appears that the SubOdaJdbcDriver is not closing the pool connection.
Do you have the code for SubOdaJdbcDriver that you are using?

Jason

"Cristian" <ceol.gael@gmail.com> wrote in message
news:68d52dd810254cd03a9203595059d305$1@www.eclipse.org...
> Hi. I'm having the following exceptions with the BIRT reports when I've
> tryied to run them into production. It seams is a problem with the DB
> connection. Can anybody tell me why's happening and how can I solve it?
>
> Thank you.
>
> DBCP object created 2006-07-09 11:20:09 by the following code was never
> closed:
>
> java.lang.Exception
>
> at
> org.apache.tomcat.dbcp.dbcp.AbandonedTrace.setStackTrace(Aba ndonedTrace.java:157)
>
> at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject (AbandonedObjectPool.java:76)
>
> at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection( PoolingDataSource.java:95)
>
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(Ba sicDataSource.java:540)
>
> at
> org.eclipse.birt.report.data.oda.subjdbc.SubOdaJdbcDriver.se tAppContext(SubOdaJdbcDriver.java:39)
>
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaDr iver.setAppContext(OdaDriver.java:355)
>
> at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:121)
>
> at
> org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:154)
>
> at
> org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:147)
>
> at
> org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:150)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.ope nDataSource(PreparedQuery.java:838)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:661)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
>
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
>
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:122)
>
> at
> org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:187)
>
> at
> org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
>
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
>
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
>
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
>
> at
> org.eclipse.birt.report.services.ReportEngineService.runAndR enderReport(Unknown
> Source)
>
> at
> org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown
> Source)
>
> at
> org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
> Source)
>
> at
> org.eclipse.birt.report.viewer.servlet.ViewerServlet.doGet(U nknown Source)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
>
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
>
> at
> net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:292)
>
> at
> net.sf.acegisecurity.intercept.web.FilterSecurityInterceptor .invoke(FilterSecurityInterceptor.java:108)
>
> at
> net.sf.acegisecurity.intercept.web.SecurityEnforcementFilter .doFilter(SecurityEnforcementFilter.java:197)
>
> at
> net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)
>
> at
> net.sf.acegisecurity.ui.basicauth.BasicProcessingFilter.doFi lter(BasicProcessingFilter.java:214)
>
> at
> net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)
>
> at
> net.sf.acegisecurity.ui.AbstractProcessingFilter.doFilter(Ab stractProcessingFilter.java:324)
>
> at
> net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)
>
> at
> net.sf.acegisecurity.context.HttpSessionContextIntegrationFi lter.doFilter(HttpSessionContextIntegrationFilter.java:220)
>
> at
> net.sf.acegisecurity.util.FilterChainProxy$VirtualFilterChai n.doFilter(FilterChainProxy.java:303)
>
> at
> net.sf.acegisecurity.util.FilterChainProxy.doFilter(FilterCh ainProxy.java:173)
>
> at
> net.sf.acegisecurity.util.FilterToBeanProxy.doFilter(FilterT oBeanProxy.java:120)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
>
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
>
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
>
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
>
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
>
> at java.lang.Thread.run(Thread.java:595)
>
>
>

Previous Topic:	promptext
Next Topic:	blank page on tomcat 5.5 birt-viewer

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 14 12:28:09 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter