Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 80107 invoked from network); 25 Jun 2008 21:37:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Jun 2008 21:37:34 -0000 Received: (qmail 80024 invoked by uid 500); 25 Jun 2008 21:37:32 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 80007 invoked by uid 500); 25 Jun 2008 21:37:32 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 79996 invoked by uid 99); 25 Jun 2008 21:37:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jun 2008 14:37:32 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [209.191.125.107] (HELO web38901.mail.mud.yahoo.com) (209.191.125.107) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 25 Jun 2008 21:36:40 +0000 Received: (qmail 82977 invoked by uid 60001); 25 Jun 2008 21:36:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=L5c4hF9zU/7BFMP4/Lz1msOrZUjQUAxFm3xSm0H4n1f8fRUn42b51UYEP7Gb79NYbv5hY4+yC742/qzMXqgzkllF8J5FvMWhYOLVQQzos5ckyvPXhS/C5I3HCJ43Qpm0SiXuuKn8ATwGz+i7iQHfCC3Uq/u+L0zdO8KDMYMB0WM=; Received: from [82.229.146.179] by web38901.mail.mud.yahoo.com via HTTP; Wed, 25 Jun 2008 14:36:57 PDT X-Mailer: YahooMailRC/975.45 YahooMailWebService/0.7.199 Date: Wed, 25 Jun 2008 14:36:57 -0700 (PDT) From: Gilles Schlienger Subject: Re : Remove/trim spaces from generated SQL requests To: user-java@ibatis.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-99698808-1214429817=:82624" Message-ID: <28842.82624.qm@web38901.mail.mud.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-99698808-1214429817=:82624 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks,=0AI actually don't really have any special space in the SQL.=0A=0AI= s the behaviour of seeing many spaces in the logs only happening in the log= s or also when the SQL request executed against the database ?=0AIf that's = the case, I guess this can consume a lot of logs on the database side (bina= ry logs etc...)=0A=0AWould any one have any advice on this ? Is anyone doin= g something special in Eclipse or with Maven 2 maybe to remove blank spaces= ?=0A=0AThanks again=0AGilles=0A=0A=0A----- Message d'origine ----=0ADe : G= wyn Evans =0A=C3=80 : user-java@ibatis.apache.org=0AE= nvoy=C3=A9 le : Mercredi, 25 Juin 2008, 17h55mn 58s=0AObjet : Re: Remove/tr= im spaces from generated SQL requests=0A=0ASimplest way is surely to not to= have the spaces in the sql in the first place?=0A=0A/Gwyn=0A=0A=0AOn Wed, = Jun 25, 2008 at 9:56 AM, Gilles Schlienger wrote:=0A=0A= Hello,=0A=0AI 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.=0A= =0AI feel it might be keeping blanks from the XML sql_map file ...?=0AWould= there be a way to "trim" these requests to have more readable logs please = ?=0A=0AThanks a lot in advance=0ARegards=0AGilles=0A=0A=0A=0A=0A ______= _______________________________________________________________________=0AE= nvoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo= .fr=0A=0A=0A _________________________________________________________= ____________________ =0AEnvoyez avec Yahoo! Mail. Une boite mail plus intel= ligente http://mail.yahoo.fr --0-99698808-1214429817=:82624 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Thanks,
I actually don't really have any special sp= ace in the SQL.

Is the behaviour of seeing many spaces in the logs o= nly 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 o= n the database side (binary logs etc...)

Would any one have any advi= ce on this ? Is anyone doing something special in Eclipse or with Maven 2 m= aybe to remove blank spaces ?

Thanks again
Gilles

= ----- Message d'origine ----
De : Gwyn Evans <gwyn.evans@gmail.com>= ;
=C3=80 : user-java@ibatis.apache.org
Envoy=C3=A9 le : Mercredi, 25 = Juin 2008, 17h55mn 58s
Objet : Re: Remove/trim spaces from generated SQ= L requests

Simplest way is surely to not to have the spaces in the s= ql in the first place?

/Gwyn

On We= d, Jun 25, 2008 at 9:56 AM, Gilles Schlienger <s_gilou@yahoo.com> wrote:
=0A
Hello,
=0A
=0AI can see in the logs th= at the SQL requests generated by iBATIS (2.3.0.677) have a lot of spaces be= tween some elements of the request.
=0A
=0AI feel it might be keeping= blanks from the XML sql_map file ...?
=0AWould there be a way to "trim"= these requests to have more readable logs please ?
=0A
=0AThanks a l= ot in advance
=0ARegards
=0AGilles
=0A

=0A
=0A
=0A      ________= _____________________________________________________________________
= =0AEnvoyez avec Yahoo! Mail. Une boite mail plus intelligente http://mail.yahoo.fr=
=0A

=0A

=0A=0A=0A =
=0AEnvoy=C3=A9 avec Yahoo! Mail.
Une boite mail= plus intelligente. --0-99698808-1214429817=:82624--