If I'm reading it correctly, the OP is concerned about the /logging/ output
that can be seen if you enable the various jdbc logging categories, not the
actual functionality. We'd need to see some examples to be sure, but my
guess is that they're seeing something like
Executing Statement: SELECT id, name FROM table
WHERE val=?
which will result from a sqlmap such as:
<select ...>
SELECT id, name
FROM table
WHERE
val=?
</select>
If so, then remove the excess spaces & line-breaks, but really, without
specific examples, it's just guessing...
/Gwyn
On Wed, Jun 25, 2008 at 11:37 PM, Eric T. Blue <[EMAIL PROTECTED]> wrote:
> 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.
>>
>
>
