RE: Log SQL statements ?

2004-11-30 Thread Nick Longinow
That sounds great, thanks Andy

-Original Message-
From: Andy Bowes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 30, 2004 6:18 AM
To: 'Slide Users Mailing List'
Subject: RE: Log SQL statements ?

Hi Nick

You might want to have a look at http://www.p6spy.com/.  Basically it allows
you to use a proxy in front of the true JDBC connection so that you can log
all of the SQL statements that are sent to a JDBC driver.  It's free and I
believe that it works with pretty much any JDBC driver.

Obviously it is useful for debugging and for test environments but it does
add a performance overhead.

This tool has proved v useful in a number of my previous projects.  Hope it
helps

Andy

-Original Message-
From: Nick Longinow [mailto:[EMAIL PROTECTED]
Sent: 29 November 2004 18:23
To: 'Slide Users Mailing List'
Subject: Log SQL statements ?


Hi

 

I am finding situations where there is a db error (Oracle) returning SQL
errors which show some sort of problem with the requested action.  In these
cases, its hard to tell what the requested action specifically was, but
having the SQL that preceded the error would help.  Is there a log setting
on the OracleAdapter or its base classes that would send that info to a log
?

Nick


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Log SQL statements ?

2004-11-30 Thread Andy Bowes
Shame.

The combination of P6Spy  IronEye SQL (http://www.irongrid.com) has helped
me out loads in the past.

P6Spy is open source, does anyone fancy having a look at extending it to
support the methods required by the Oracle Adapter ?

Andy

-Original Message-
From: Davide Savazzi [mailto:[EMAIL PROTECTED]
Sent: 30 November 2004 13:47
To: Slide Users Mailing List
Subject: Re: Log SQL statements ?


On Tuesday 30 November 2004 12:18, Andy Bowes wrote:

 You might want to have a look at http://www.p6spy.com/.  Basically it
 allows you to use a proxy in front of the true JDBC connection so that you
 can log all of the SQL statements that are sent to a JDBC driver.  It's
 free and I believe that it works with pretty much any JDBC driver.

The Oracle adapter in cvs uses Oracle JDBC extensions to manage blobs, so
this 
proxy will not work :(
 
-- 
Davide Savazzi

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]