You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Erik Weber <er...@mindspring.com> on 2005/02/16 15:12:30 UTC

[OT] Re: SQL

I don't know if there is an easier or more driver-independent way, but 
some JDBC drivers have a debug mode that can be enabled. Sorry, I don't 
have any specifics for you.

Erik


CRANFORD, CHRIS wrote:

>This may be slightly off-topic but I'm sure others may have ran into this issue.  If I have created a CallableStatement object using a SQL string, is there anyway to retreive that SQL string from the CallableStatement object ?
>
>_______________________________________________________
>Chris Cranford
>Programmer/Developer
>SETECH Inc. & Companies
>6302 Fairview Rd, Suite 201
>Charlotte, NC  28210
>Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 
>Email: chris.cranford@setechusa.com
>
>
>  
>

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


Re: [OT] Re: SQL

Posted by Martin Gainty <mg...@hotmail.com>.
I concur with Erik..
The only thing I can add is to Trap the SQL Statement and store in session 
variable or bean property before you do the CallableStatement.execute..that 
way you can reference the string later on.
HTH,
Martin-
----- Original Message ----- 
From: "Erik Weber" <er...@mindspring.com>
To: "Struts Users Mailing List" <us...@struts.apache.org>
Sent: Wednesday, February 16, 2005 9:12 AM
Subject: [OT] Re: SQL


>I don't know if there is an easier or more driver-independent way, but some 
>JDBC drivers have a debug mode that can be enabled. Sorry, I don't have any 
>specifics for you.
>
> Erik
>
>
> CRANFORD, CHRIS wrote:
>
>>This may be slightly off-topic but I'm sure others may have ran into this 
>>issue.  If I have created a CallableStatement object using a SQL string, 
>>is there anyway to retreive that SQL string from the CallableStatement 
>>object ?
>>
>>_______________________________________________________
>>Chris Cranford
>>Programmer/Developer
>>SETECH Inc. & Companies
>>6302 Fairview Rd, Suite 201
>>Charlotte, NC  28210
>>Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 Email: 
>>chris.cranford@setechusa.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