Re: [Proxool-developer] SQL statement from the Connection

[xyz a. <vik...@ho...>]

Hi Bill,
Thanks for the information. Yes, onExecute() does display the SQL query.

In my case, the only reason I am interested in this method would be to 
monitor/investigate the DB Blocks. I would be interested in finding whoch 
query caused the DB blocks.
Unfortunately, onExecute() never "gets completed" if there is a DB Block.
Would it be more effective to split the onExecute() into 
onExecuteStart(String command) and onExecuteFinish(String command, long 
elapsedtime)?


>From: Bill Horsman <bi...@lo...>
>To: xyz abc <vik...@ho...>
>CC: Proxool <pro...@li...>
>Subject: Re: [Proxool-developer] SQL statement from the Connection
>Date: Thu, 13 Nov 2003 23:42:47 +0000
>
>Hi Vick,
>
>On Thu, 2003-11-13 at 19:56, xyz abc wrote:
>
> > I was looking at ConnectionListenerIF's onExecute method. The note says 
>that
> > command is not fully implemented at this stage. At some point it might
> > represent the SQL that is sent to the database (or the procedure call 
>that
> > was used).
>
>I'm pleased to say that the documentation is wrong. It *is* implemented
>:)
>
>The SQL should pretty accurately represent what was sent to the
>database. Almost like a journal. I say things like "should", and
>"pretty" and "almost" because it's not thoroughly tested. There are lots
>of ways of constructing statements and executing SQL in the JDBC API and
>we've have attempted to trap them all.
>
>So, my recommendation is: please use the onExecute() method and let us
>know if you have any problems. I have not come across any yet.
>
>The onExecute() method is the only way to extract the SQL from the
>connection. Note that it might contain a semicolon delimited list of
>queries if a batch execute was used.
>
>Regards.
>Bill Horsman
>
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: ApacheCon 2003,
>16-19 November in Las Vegas. Learn firsthand the latest
>developments in Apache, PHP, Perl, XML, Java, MySQL,
>WebDAV, and more! http://www.apachecon.com/
>_______________________________________________
>Proxool-developer mailing list
>Pro...@li...
>https://lists.sourceforge.net/lists/listinfo/proxool-developer

_________________________________________________________________
Concerned that messages may bounce because your Hotmail account is over 
limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es