You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@struts.apache.org by Research labs <re...@yahoo.co.uk> on 2004/07/25 16:53:39 UTC

debugging prepared statements...view built SQl...Newbe?

Is there anything in Struts that will enable me view
the SQL query that has been built by a prepared
statement?

Thank you.


	
	
		
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!  http://www.allnewmessenger.com

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@struts.apache.org
For additional commands, e-mail: dev-help@struts.apache.org


Re: debugging prepared statements...view built SQl...Newbe?

Posted by Research labs <re...@yahoo.co.uk>.
Thank for your very prompt response, I will
investigate MySQl db.

Ola.


--- Peng Tuck Kwok <pe...@gmail.com> wrote: > Nope,
don't think so. 
> If you are preparing your own sql statements you can
> print them out
> through a logger (tedious I know but still
> workable).
> Some database drivers do support jdbc logging, where
> statements
> executed against the database will be logged to a
> text file. You'll
> probably need to look in to the documentation for
> your driver to work
> it out.
> 
> 
> On Mon, 26 Jul 2004 05:13:45 +0100 (BST), Research
> labs
> <re...@yahoo.co.uk> wrote:
> > Is there anything in Struts that will enable me
> view
> > the SQL query that has been built by a prepared
> > statement?
> > 
> > Thank you.
> > 
> >
>
___________________________________________________________ALL-NEW
> Yahoo! Messenger - all new features - even more fun!
>  http://www.allnewmessenger.com
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> user-unsubscribe@struts.apache.org
> > For additional commands, e-mail:
> user-help@struts.apache.org
> > 
> >
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> user-unsubscribe@struts.apache.org
> For additional commands, e-mail:
> user-help@struts.apache.org
> 
>  


	
	
		
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!  http://www.allnewmessenger.com

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Re: debugging prepared statements...view built SQl...Newbe?

Posted by Peng Tuck Kwok <pe...@gmail.com>.
Nope, don't think so. 
If you are preparing your own sql statements you can print them out
through a logger (tedious I know but still workable).
Some database drivers do support jdbc logging, where statements
executed against the database will be logged to a text file. You'll
probably need to look in to the documentation for your driver to work
it out.


On Mon, 26 Jul 2004 05:13:45 +0100 (BST), Research labs
<re...@yahoo.co.uk> wrote:
> Is there anything in Struts that will enable me view
> the SQL query that has been built by a prepared
> statement?
> 
> Thank you.
> 
> ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!  http://www.allnewmessenger.com
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


debugging prepared statements...view built SQl...Newbe?

Posted by Research labs <re...@yahoo.co.uk>.
Is there anything in Struts that will enable me view
the SQL query that has been built by a prepared
statement?

Thank you.




	
	
		
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!  http://www.allnewmessenger.com

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org