ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric T. Blue" <ericblu...@gmail.com>
Subject Re: Re : Remove/trim spaces from generated SQL requests
Date Wed, 25 Jun 2008 22:37:45 GMT
Gilles,

Is your column datatype CHAR?  This may not be the issue, however you may
want to check out the differences between CHAR and VARCHAR2.  Ex:

http://www.databasesandlife.com/char-vs-varchar-and-varchar2/


On Wed, Jun 25, 2008 at 2:36 PM, Gilles Schlienger <s_gilou@yahoo.com>
wrote:

> Thanks,
> I actually don't really have any special space in the SQL.
>
> Is the behaviour of seeing many spaces in the logs only happening in the
> logs or also when the SQL request executed against the database ?
> If that's the case, I guess this can consume a lot of logs on the database
> side (binary logs etc...)
>
> Would any one have any advice on this ? Is anyone doing something special
> in Eclipse or with Maven 2 maybe to remove blank spaces ?
>
> Thanks again
> Gilles
>
> ----- Message d'origine ----
> De : Gwyn Evans <gwyn.evans@gmail.com>
> À : user-java@ibatis.apache.org
> Envoyé le : Mercredi, 25 Juin 2008, 17h55mn 58s
> Objet : Re: Remove/trim spaces from generated SQL requests
>
>
> Simplest way is surely to not to have the spaces in the sql in the first
> place?
>
> /Gwyn
>
> On Wed, Jun 25, 2008 at 9:56 AM, Gilles Schlienger <s_gilou@yahoo.com>
> wrote:
>
>> Hello,
>>
>> I can see in the logs that the SQL requests generated by iBATIS
>> (2.3.0.677) have a lot of spaces between some elements of the request.
>>
>> I feel it might be keeping blanks from the XML sql_map file ...?
>> Would there be a way to "trim" these requests to have more readable logs
>> please ?
>>
>> Thanks a lot in advance
>> Regards
>> Gilles
>>
>>
>>
>>
>>  _____________________________________________________________________________
>> Envoyez avec Yahoo! Mail. Une boite mail plus intelligente
>> http://mail.yahoo.fr
>>
>
>
> ------------------------------
> Envoyé avec Yahoo! Mail<http://us.rd.yahoo.com/mailuk/taglines/isp/control/*http://us.rd.yahoo.com/evt=52423/*http://fr.docs.yahoo.com/mail/overview/index.html>
> .
> Une boite mail plus intelligente.
>

Mime
View raw message