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 <[EMAIL PROTECTED]> À : 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> À : 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 <[EMAIL PROTECTED]> 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
