Re : Re : Remove/trim spaces from generated SQL requests

[Gilles Schlienger <s_...@yahoo.com>]

Thanks, but this happens for any type of column in my SQL maps.

This happens when I use dynamic elements in the xml file

Thanks again
Gilles


----- Message d'origine ----
De : Eric T. Blue <er...@gmail.com>
À : user-java@ibatis.apache.org
Envoyé le : Jeudi, 26 Juin 2008, 0h37mn 45s
Objet : Re: Re : Remove/trim spaces from generated SQL requests

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_...@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 <gw...@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_...@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.
Une boite mail plus intelligente. 



      _____________________________________________________________________________ 
Envoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr