Statements and ResultSets shown as open even though closed

Thread View: borland.public.optimizeit.servertrace

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Kiran Rajapur Wed, 17 May 2006 15:32

#25

Author: Kiran Rajapur
Date: Wed, 17 May 2006 15:32

13 lines
1480 bytes

We are using ServerTrace 3.0 with Weblogic 8.1 Server and we are getting Error Connections closed with open resources

It shows as the line where the CallableStament is created as where the statemnt object is created.

We are using Sybase JDBC driver and connection pooling in Weblgic. Is it possible that server Trace is reporting somehing incorrect that the statements are not closed even though they are closed.

We also monitored on the Sybase Database  itself by running some queries and it showed that everything is closed.

Can someone please provide clarity on how to read these Server snapshots which shows that JDBC resources are not closed.

Thanks
Kiran

Re: Statements and ResultSets shown as open even though closed

#26

Author: William Louth
Date: Sat, 10 Jun 2006 11:24

28 lines
2314 bytes

Hi Kiran,

You should really try JXInsight which was the first application performance management solution on the market to offering JDBC resource tracking as well as detailed transactional resource execution patterns. Our JDBC transaction analysis is unmatched in the industry of course now we provide much more information including distributed component tracing and configuration management for details problem resolution as well as business transaction semantic verification and testing.

Kind regards,

William Louth
JXInsight Product Architect
JInspired

"JEE tuning, testing, tracing and monitoring with JXInsight"
http://www.jinspired.com

"Kiran Rajapur" <kiran_rajapur@ssga.com> wrote:
>
>We are using ServerTrace 3.0 with Weblogic 8.1 Server and we are getting Error Connections closed with open resources
>
>It shows as the line where the CallableStament is created as where the statemnt object is created.
>
>We are using Sybase JDBC driver and connection pooling in Weblgic. Is it possible that server Trace is reporting somehing incorrect that the statements are not closed even though they are closed.
>
>We also monitored on the Sybase Database  itself by running some queries and it showed that everything is closed.
>
>Can someone please provide clarity on how to read these Server snapshots which shows that JDBC resources are not closed.
>
>Thanks
>Kiran

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads