Hi Just wondering: How did you implement the "transparancy" aspect ? Interceptor pattern (as in CORBA) ? Your tool seems to be a very good thing to use during dev-cycle to log certain aspects you're interested in (maybe log4j might do the job ?).
Stefan -----Ursprüngliche Nachricht----- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications 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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
