Re: Experiences setting OPEN_CURSORS for Java applications

Thanks for the answer.
Yep, it seems more like JDBC proxy with analyzing capabilities than a regular traffic analyzer which sits aside & sniffs some packets. May I ask, how much time have you spent on writing such thing?

I'm planning to write something similar, but on SQL*Net level...

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 01, 2003 3:44 AM

> Tanel,
>
> I've implemented it as a JDBC driver that is installed as a layer between
> your application and the vendor driver that you are using (eg. Oracle,
> Postgress, SQL Server, etc.)
>
> [Java application] - Layer 1
> [JDBC Expert] - Layer 2
> [Oracle Thin Driver] - Layer 3
> |
> network
> |
> [Oracle Server] - Layer 4
>
>
> It does not parse Java source code and is not a code analyzer, however the
> tool will intercept all calls that an application makes on the JDBC API,
> analyze them and forward them onto the vendor driver. In this way the
tool
> is transparent to the application and can be installed or removed without
> modification to the application code.
>
> I would not call it a traffic analyzer because to me that term implies
that
> it sits on a network and analyzes network traffic much like an Intrusion
> Detection System might do.
>
> Regards,
> Craig Munday.
>
>
>
>
>
>
> At 04:11 AM 30/09/2003 -0800, you wrote:
> > > I've encountered this problem so often that I decided to write a tool
> > > (called JDBC Expert) that would help us DBAs (and developers) detect
> > > Statement and ResultSet "leaks" in Java applications. I've found
this
> > > tool so useful and effective at finding resource leaks that I insist
any
> >in
> > > house developed or third party Java applications are tested with it
before
> > > we release them.
> >
> >Just interested, how have you implemented it? Is it a code or traffic
> >analyzer?
> >
> >Tanel.
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Tanel Poder
> > INET: tanel.poder.003_at_mail.ee
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Craig Munday
> INET: cmunday_at_bigpond.net.au
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).