Why do executed statements of ibatis log not wrap?

[Kurt Xu]

I configured the log4j.xml making ibatis' executed sql statement
printed out, the same log configuration, statements defined in some
sql map files are shown in multiple lines normally, ones in others,
don't wrap. Why is it?

[Eduardo Macarron]

Could you post a sample?

El día 24 de abril de 2012 17:23, Kurt Xu <[hidden email]> escribió:
> I configured the log4j.xml making ibatis' executed sql statement
> printed out, the same log configuration, statements defined in some
> sql map files are shown in multiple lines normally, ones in others,
> don't wrap. Why is it?

[Kurt Xu]

Hi buddy:
   the bad output sample is like:

/* hangameadmin-top:getThreadList */         SELECT         *
FROM
(             SELECT                                                       /
*+ INDEX_DESC(CCHAT_THREAD CCHAT_THREAD_PK)
*/                                  ROWNUM AS RN,
THREADNO,                 CONTENTTXT,
USERID,                 AVATARID,
SERVICEJOINNO,                 COMMENTCNT,
SVCNO,                 VALIDFLG,
VIEWCNT,                 ADMFLG,                 REGDT
FROM                 CCHAT_THREAD             WHERE
THREADNO>0                 AND
VALIDFLG='Y'
AND ROWNUM<=224                        )         WHERE
RN>=221

they are alll in the same line.
On 4月24日, 下午1时13分, Eduardo Macarron <[hidden email]>
wrote:

> Could you post a sample?
>
> El día 24 de abril de 2012 17:23, Kurt Xu <[hidden email]> escribió:
>
>
>
>
>
>
>
> > I configured the log4j.xml making ibatis' executed sql statement
> > printed out, the same log configuration, statements defined in some
> > sql map files are shown in multiple lines normally, ones in others,
> > don't wrap. Why is it?

[Eduardo Macarron]

Ok, understood. MyBatis removes all the line breaks from the SQL.

El día 25 de abril de 2012 03:27, Kurt Xu <[hidden email]> escribió:

> Hi buddy:
>   the bad output sample is like:
>
> /* hangameadmin-top:getThreadList */         SELECT         *
> FROM
> (             SELECT                                                       /
> *+ INDEX_DESC(CCHAT_THREAD CCHAT_THREAD_PK)
> */                                  ROWNUM AS RN,
> THREADNO,                 CONTENTTXT,
> USERID,                 AVATARID,
> SERVICEJOINNO,                 COMMENTCNT,
> SVCNO,                 VALIDFLG,
> VIEWCNT,                 ADMFLG,                 REGDT
> FROM                 CCHAT_THREAD             WHERE
> THREADNO>0                 AND
> VALIDFLG='Y'
> AND ROWNUM<=224                        )         WHERE
> RN>=221
>
> they are alll in the same line.
> On 4月24日, 下午1时13分, Eduardo Macarron <[hidden email]>
> wrote:
>> Could you post a sample?
>>
>> El día 24 de abril de 2012 17:23, Kurt Xu <[hidden email]> escribió:
>>
>>
>>
>>
>>
>>
>>
>> > I configured the log4j.xml making ibatis' executed sql statement
>> > printed out, the same log configuration, statements defined in some
>> > sql map files are shown in multiple lines normally, ones in others,
>> > don't wrap. Why is it?