AW: AW: Experiences setting OPEN_CURSORS for Java applications

Hi Craig

The whole point of an interceptor is basically to add functionality to a certain type or protocol without changing the interface the client works with. In Java, this is usually accomplished by implementing an extra interface to add things like security or billing based on transactions etc. (I've seen this in CORBA first, hence the reference to it). The developer continues working with the same types she/he used to work with. It often comes along with the factory pattern, where a certain object is created and returned to the calling object. The calling object uses the interface of the type it wanted, not being aware of any additional things.

I hope that was confusing enough ;)

Right now, we just implemented some "common" PL/SQL packages to deal with logging and error handling etc., but I have to say, the idea to add an extra layer to the JDBC architecture is a great idea. Helps DBAs spotting problems real easy, as you said.

Regards,
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Tel.: +49 201/45 13-289
mailto:stefan.jahnke_at_nospam.bov.de
http://www.bov.de
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews

Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:andrea.palluck_at_bov.de.

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above.

-----Ursprüngliche Nachricht-----
Von: Craig Munday [mailto:cmunday_at_bigpond.net.au] Gesendet: Donnerstag, 2. Oktober 2003 15:20 An: Multiple recipients of list ORACLE-L Betreff: 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).


 
-- 
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).