Return-Path: 
 <user-java-return-19132-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 54852 invoked from network); 14 Apr 2010 05:35:38 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 14 Apr 2010 05:35:38 -0000
Received: (qmail 4738 invoked by uid 500); 14 Apr 2010 05:35:37 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 4632 invoked by uid 500); 14 Apr 2010 05:35:37 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 4625 invoked by uid 99); 14 Apr 2010 05:35:36 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Apr 2010 05:35:36 +0000
X-ASF-Spam-Status: No, hits=0.7 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [91.199.21.18] (HELO mxa.xchangemail.de) (91.199.21.18)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Apr 2010 05:35:29 +0000
Received: from VAVP1E1C.vavp0m.de (10.40.201.2) by mxa.xchangemail.de
 (10.41.8.201) with Microsoft SMTP Server (TLS) id 8.1.393.1; Wed, 14 Apr 2010
 07:35:04 +0200
Received: from VAVP0E7A.vavp0m.de ([10.46.1.70]) by VAVP1E1C.vavp0m.de
 ([10.41.0.5]) with mapi; Wed, 14 Apr 2010 07:35:07 +0200
From: Stephen Friedrich <stephen.friedrich@fortis-it.eu>
To: "user-java@ibatis.apache.org" <user-java@ibatis.apache.org>
Date: Wed, 14 Apr 2010 07:35:02 +0200
Subject: AW: Enabling iBatis 3 logging
Thread-Topic: Enabling iBatis 3 logging
Thread-Index: AcrbX5/RXsa4FvsjTeylrKo/mBDg6wANG9Ww
Message-ID: <60454457CBDFBD4DB30D4F4A5B193DED02997B8475@VAVP0E7A.vavp0m.de>
References: <4BC4FB7F.8040309@bbs.darktech.org>
In-Reply-To: <4BC4FB7F.8040309@bbs.darktech.org>
Accept-Language: en-US, de-DE
Content-Language: de-DE
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US, de-DE
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Checked: Checked by ClamAV on apache.org

Using this log4j configuration I am getting all sql statements added to the=
 "sql"
appender:

    <!--
            iBatis
    -->
    <category name=3D"com.ibatis" additivity=3D"false">
        <priority value=3D"debug"/>
        <appender-ref ref=3D"sql"/>
    </category>

    <!-- iBatis also uses standard java.sql classes as log categories -->

    <!-- Log query results -->
    <category name=3D"java.sql.ResultSet" additivity=3D"false">
        <priority value=3D"error"/>
        <appender-ref ref=3D"sql"/>
    </category>
   =20
    <!-- Log connections, prepared statements etc.  -->
    <category name=3D"java.sql" additivity=3D"false">
        <priority value=3D"debug"/>
        <appender-ref ref=3D"sql"/>
    </category>



-----Urspr=FCngliche Nachricht-----
Von: cowwoc [mailto:cowwoc@bbs.darktech.org]=20
Gesendet: Mittwoch, 14. April 2010 01:17
An: user-java@ibatis.apache.org
Betreff: Enabling iBatis 3 logging

Hi,

     I'm getting this exception:

[snip]
    operation: setValue
    org.apache.ibatis.exceptions.IbatisException:
    ### Error updating database.  Cause:=20
org.postgresql.util.PSQLException: ERROR: syntax error at or near "WHERE"
      Position: 68
[snip]

     The annoying thing is I can't find an easy way to find out what=20
postiion 68 refers to. I wish that iBatis would include the SQL=20
statement in the exception message.

     I remember seeing iBatis log SQL statements when I first started=20
playing with it last week. I suppressed them somehow and I forget how.=20
Could someone please help me figure out how to re-enable them?

PS: I am using "ibaguice", Guice 2.0, and iBatis 3 annotations (no xml=20
files at all).

Thanks,
Gili

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org