| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
|
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).Received on Tue Sep 30 2003 - 19:44:28 CDT
 |
 |