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]> > À : [email protected] > 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<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. >
