Re: AW: Experiences setting OPEN_CURSORS for Java applications

Hi,

I'm not sure about the Interceptor pattern.

Log4j is a great package and I make use of it within JDBC Expert. I started using the new logging API in JDK 1.4 but found most developers were using Log4j so I changed. Log4j seems like a much more mature package anyway.

I too think it would be a great tool to be used in the development cycle. Ideally I would like every developer to have it installed while they complete their development in the hope that a number of defects can be eliminated early.

In reality though, I find that senior developers and data administrators see the most benefits. Particularly database administrators, probably because they are the ones that are called upon to resolve the errors (such as ORA-1000) when they occur.

Let me know if you would like a copy, and I'll email it privately to you - its too big to send to the list.

Regards,
Craig Munday.

At 06:49 AM 1/10/2003 -0800, Stefan Jahnke wrote:
>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:cmunday_at_bigpond.net.au]
>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: 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: Stefan Jahnke
> INET: Stefan.Jahnke_at_bov.de
>
>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).