ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: get the statement
Date Thu, 09 Mar 2006 15:04:17 GMT
Lurtz,

As of right now I don't believe that ibatis can do this.  Feel free  
to open a JIRA request for this type of enhancement.

Nathan
On Mar 9, 2006, at 1:15 AM, Lurtz Ugluk wrote:

> I've see the log, and It's fine, but I want to store
> some especial INSERTS, UPDATES and DELETES that the
> application is executing, to create a file with that
> especial statements.
>
> Have I read the log and get lines from it? hummmm
>
> Example
>
> select * from table
> <dynamic WHERE>
> <isNull prepend = AND > FIELD = #field# </isNull>
> </dynamic>
>
> iBatis knows if the FIELD is null and then the SQL may
> be
> select * from table
> or
> select * from table where FIELD  = ?
>
> I want to know the sql in the implementation
> (sqlmapdao) after the execution (or before, I don't
> mind).
> Now I'm seeing if the parameters are null and doing
> the sql string by myself, but if I could get the sql
> from iBatis..... much better ;-)
>
> Thanks and excuse my english ;)
>
>
>  --- Nathan Maves <Nathan.Maves@Sun.COM> escribió:
>
>> The logging will give you all the information that
>> you need.
>>
>> Ex.
>>
>> select * from table where id = #id#
>>
>> The logging will show you the PS
>>
>> select * from table where id = ?
>>
>> And then show you the parameters.  You will be able
>> to see just what
>> is being called.  The only gotcha is that you can
>> not copy and paste
>> the sql in one shot.  You have to do the
>> substitution for the
>> parameters yourself.
>>
>> Give it a try :)
>>
>>
>> Nathan
>>
>>
>> On Mar 8, 2006, at 10:09 AM, Lurtz Ugluk wrote:
>>
>>> I've look the link above and I read "Why? Because
>> the
>>> only information we have available is the
>>> PreparedStatement and the parameters."
>>> That's that I need (I think ;-) ), with the
>>> preparedStatement I can get the SQL that I will
>>> execute, can't I?
>>> How can I get that PreparedStatement and its
>>> parameters at runtime ?
>>>
>>> More thanks
>>>
>>>  --- Nathan Maves <Nathan.Maves@Sun.COM> escribió:
>>>
>>>> Not really sure if you truly want to save the sql
>> or
>>>> just look at if
>>>> for debugging purposes.
>>>>
>>>> If you are just trying to debug the look at
>> setting
>>>> up logging for
>>>> your application.  The following page on the wiki
>>>> should help you set
>>>> that up.
>>>>
>>>>
>>>
>>
> http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do
>>>>
>>>> +I+get+SqlMapClient+to+log+SQL+statements
>>>>
>>>> Nathan
>>>>
>>>> On Mar 8, 2006, at 9:39 AM, Lurtz Ugluk wrote:
>>>>
>>>>>  How Can I get the sql statement that de iBatis
>>>>> execute?
>>>>> I need the sql statement at runtime to create a
>>>>> String and save it.
>>>>>
>>>>>  Thanks.
>>>>>
>>>>>
>>>>> 		
>>>>> ______________________________________________
>>>>> LLama Gratis a cualquier PC del Mundo.
>>>>> Llamadas a fijos y móviles desde 1 céntimo por
>>>> minuto.
>>>>> http://es.voice.yahoo.com
>>>>
>>>>
>>>
>>>
>>>
>>> 		
>>> ______________________________________________
>>> LLama Gratis a cualquier PC del Mundo.
>>> Llamadas a fijos y móviles desde 1 céntimo por
>> minuto.
>>> http://es.voice.yahoo.com
>>
>>
>
>
>
> 		
> ______________________________________________
> LLama Gratis a cualquier PC del Mundo.
> Llamadas a fijos y móviles desde 1 céntimo por minuto.
> http://es.voice.yahoo.com


Mime
View raw message