Re: How to "audit" without auditing ?

<davide_at_yahoo.com> wrote:

> Ok, I admit that the subject is quite confusing, so I will try to be
> a little clear (at the expenses of to be logorroic): we are developing
> a web application using Dynamo as Application Server, Dynamo uses a
> sort-of internal connection system to talk to an Oracle database.
> Unfortunately, doing this, the developer does not have any clue about
> the "real" SQL instruction sent to the database, just the error (in case)
> returned.
>
> I was asking to find a way to "inspect" the SQL instruction when they are
> received by Oracle.

You could also enable logging on the various connection pools that Dynamo uses to communicate with the database, and maybe compare side-by-side the queries (the ones that Dynamo is sending and the ones that Oracle is receiving) to pinpoint problems in the JDBC code.

The logged SQL queries can be inspected by looking at the dynamo.log file (warning: the log grows rapidly in this fashion!)

Regards
Sebastiano Pilla Received on Sun Nov 04 2001 - 09:14:08 CST