The following exception is saying that I didn't close my connection.  I added printouts to my code everytime a db connection was created, reused, and closed.

It is interesting that JBOSS is reporting the error before my close connection is actually called (See end of stack trace).

 

Any ideas?

 

13:11:32,493 INFO  [STDOUT] Creating new connection

13:11:32,493 INFO  [STDOUT] 13:11:32,493,LightSpeed        [DEBUG] - query():Exec SQL: =>select sum ( totalrooms ) from accom where hot

13:11:32,543 INFO  [STDOUT] Returning previously created connection

13:11:32,553 INFO  [STDOUT] 13:11:32,553,LightSpeed        [DEBUG] - query():Exec SQL: =>select * from housesell where hotelnum = 20 AN

13:11:32,593 INFO  [STDOUT] Returning previously created connection

13:11:32,603 INFO  [STDOUT] 13:11:32,603,LightSpeed        [DEBUG] - query():Exec SQL: =>select sum ( roomsused ), sum ( nbrarrivals )

13:11:32,603 INFO  [STDOUT] Returning previously created connection

13:11:32,603 INFO  [STDOUT] 13:11:32,603,LightSpeed        [DEBUG] - query():Exec SQL: =>select sum ( roomsused ), sum ( nbrarrivals )

13:11:32,613 INFO  [CachedConnectionManager] Could not find a close method on alleged connection objects.  Please close your own connec

java.lang.Exception: Stack Trace

        at org.jboss.resource.connectionmanager.CachedConnectionManager.closeAll(CachedConnectionManager.java:357)

        at org.jboss.resource.connectionmanager.CachedConnectionManager.popMetaAwareObject(CachedConnectionManager.java:199)

        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:190)

        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)

        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:108)

        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:216)

        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)

        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)

        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:208)

        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:154)

        at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)

        at org.jboss.ejb.Container.invoke(Container.java:652)

        at java.lang.reflect.Method.invoke(Native Method)

        at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)

        at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)

        at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)

        at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)

        at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)

        at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:109)

        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)

        at $Proxy110.getAvailabilityResponse(Unknown Source)

        at com.lightspeed.xml.helper.HotelAvailService.execute(HotelAvailService.java:39)

        at com.lightspeed.xml.helper.BaseService.process(BaseService.java:53)

        at com.lightspeed.xml.transform.BaseXmlHandler.doPost(BaseXmlHandler.java:145)

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

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

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

        at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:509)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)

        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)

        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)

        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)

        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)

        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)

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

13:11:34,366 INFO  [STDOUT] Connection Closed

This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged.
The information is intended only for the use of the individual(s) or entity named above.  If you are not the intended recipient, be
aware that any disclosure, copying or distribution or use of the contents of this information is prohibited.  If you have received
this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.

Reply via email to