Return-Path: 
 <user-java-return-18852-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 13069 invoked from network); 7 Mar 2010 15:13:53 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Mar 2010 15:13:53 -0000
Received: (qmail 51553 invoked by uid 500); 7 Mar 2010 15:13:32 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 51509 invoked by uid 500); 7 Mar 2010 15:13:32 -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 51502 invoked by uid 99); 7 Mar 2010 15:13:32 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Mar 2010 15:13:32 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of bhaarat.s@gmail.com designates
 209.85.219.222 as permitted sender)
Received: from [209.85.219.222] (HELO mail-ew0-f222.google.com)
 (209.85.219.222)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Mar 2010 15:13:24 +0000
Received: by ewy22 with SMTP id 22so3528743ewy.26
        for <user-java@ibatis.apache.org>;
 Sun, 07 Mar 2010 07:13:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:date:message-id:subject
         :from:to:content-type;
        bh=EwVHa3sSsDx3zDwcrYqqhlkKgEIGVcUBW0bjKs9JYKk=;
        b=KFYqYbeOHu3pFqRJuEXm06ZYvrCbHp9INFwvkQjkE7cBIZLdgfD/fX8o3atq5dha1n
         gRySxnNkvvCoyV6eF+NOMafZs5iU0LXkM66zN8XI0lkWtTbrNAHpe3aXUOPt6S32uSip
         AmBQP/4r0cTtOXMptoXid2pJ+KRa5O2Rr+CvU=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=B8MgWkUDyg35FPCROMRUOOu3yd/yjU3I+CYHM0P3192jT1A/XrZ/5/YDevIQ5X/P0w
         dLah3Dt1dBUSY6E8MRw9j3eFFqBHPcnpZKp6926T9Qb3zIZlWAm3BYgPsChB+H64lXxL
         cRB/p7ghqZsIZovvrlrYcKlRoLImA7DPHqXR8=
MIME-Version: 1.0
Received: by 10.213.26.138 with SMTP id e10mr2279564ebc.80.1267974784127;
 Sun,
	07 Mar 2010 07:13:04 -0800 (PST)
Date: Sun, 7 Mar 2010 10:13:04 -0500
Message-ID: <491bd2b51003070713p4710d169k559558af03beec0a@mail.gmail.com>
Subject: How to do logging in iBatis + Spring
From: Bhaarat Sharma <bhaarat.s@gmail.com>
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=0015174be8bc9795f4048137620a
X-Virus-Checked: Checked by ClamAV on apache.org

--0015174be8bc9795f4048137620a
Content-Type: text/plain; charset=ISO-8859-1

We use iBatis + Spring and make use of stored procedures to fetch
information from Oracle DB.  To find out what parameters (HashMap) is sent
to the stored procedure we have to actually set debug points.  We'd like
this information to go to a log. Basically print out name of the Stored Proc
+ all that a HashMap contains (before calling the Stored procedure).

Our setup is as below:

Mapping:
    <procedure id="getReportData" parameterMap="getReportDataCall">
       {call get_rpt (?,?,?,?)}
    </procedure>

      <parameterMap id="getReportDataCall" class="map">
        <parameter property="type" jdbcType="String"
javaType="java.lang.String" mode="IN"/>
        <parameter property="month" jdbcType="Int"
javaType="java.lang.Integer" mode="IN"/>
        <parameter property="Result0" jdbcType="ORACLECURSOR"
javaType="java.sql.ResultSet" mode="OUT" resultMap="result1"/>
        <parameter property="Result1" jdbcType="ORACLECURSOR"
javaType="java.sql.ResultSet" mode="OUT" resultMap="result2"/>
      </parameterMap>

      <resultMap id="select-first-result-hq" class="VO">
        <result property="column1" column="columna"/>
        <result property="column2" column="columnb"/>
      </resultMap

We call our procedures like this:
    HashMap parm = new HashMap ();
    parm.put("type", type_val);
    parm.put("month", month_val);
    getSqlMapClientTemplate().queryForList("mymappingName.getReportData",
parm);


I could make a method that would take SP name + HashMap as parm and then
just put it on the log but then i'd have to explicitly make a call to that
method before I call the Stored procedure.  I will take this as the last
option as it involves me touching all my existing code.

Is there any simpler solution to this?

--0015174be8bc9795f4048137620a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

We use iBatis + Spring and make use of stored procedures to fetch informati=
on from Oracle DB. =A0To find out what parameters (HashMap) is sent to the =
stored procedure we have to actually set debug points. =A0We&#39;d like thi=
s information to go to a log. Basically print out name of the Stored Proc +=
 all that a HashMap contains (before calling the Stored procedure).<div>
<br></div><div>Our setup is as below:</div><div><br></div><div>Mapping:</di=
v><div><div>=A0=A0 =A0&lt;procedure id=3D&quot;getReportData&quot; paramete=
rMap=3D&quot;getReportDataCall&quot;&gt;</div><div>=A0=A0 =A0 =A0 {call get=
_rpt (?,?,?,?)}</div>
<div>=A0=A0 =A0&lt;/procedure&gt;</div><div><br></div><div>=A0=A0 =A0 =A0&l=
t;parameterMap id=3D&quot;getReportDataCall&quot; class=3D&quot;map&quot;&g=
t;</div><div>=A0=A0 =A0 =A0 =A0&lt;parameter property=3D&quot;type&quot; jd=
bcType=3D&quot;String&quot; javaType=3D&quot;java.lang.String&quot; mode=3D=
&quot;IN&quot;/&gt;</div>
<div>=A0=A0 =A0 =A0 =A0&lt;parameter property=3D&quot;month&quot; jdbcType=
=3D&quot;Int&quot; javaType=3D&quot;java.lang.Integer&quot; mode=3D&quot;IN=
&quot;/&gt;</div><div>=A0=A0 =A0 =A0 =A0&lt;parameter property=3D&quot;Resu=
lt0&quot; jdbcType=3D&quot;ORACLECURSOR&quot; javaType=3D&quot;java.sql.Res=
ultSet&quot; mode=3D&quot;OUT&quot; resultMap=3D&quot;result1&quot;/&gt;</d=
iv>
<div>=A0=A0 =A0 =A0 =A0&lt;parameter property=3D&quot;Result1&quot; jdbcTyp=
e=3D&quot;ORACLECURSOR&quot; javaType=3D&quot;java.sql.ResultSet&quot; mode=
=3D&quot;OUT&quot; resultMap=3D&quot;result2&quot;/&gt;</div><div>=A0=A0 =
=A0 =A0&lt;/parameterMap&gt;</div>
<div><br></div><div>=A0=A0 =A0 =A0&lt;resultMap id=3D&quot;select-first-res=
ult-hq&quot; class=3D&quot;VO&quot;&gt;</div><div>=A0=A0 =A0 =A0 =A0&lt;res=
ult property=3D&quot;column1&quot; column=3D&quot;columna&quot;/&gt;</div><=
div>=A0=A0 =A0 =A0 =A0&lt;result property=3D&quot;column2&quot; column=3D&q=
uot;columnb&quot;/&gt;</div>
<div>=A0=A0 =A0 =A0&lt;/resultMap</div><div><br></div><div>We call our proc=
edures like this:</div><div><div>=A0=A0 =A0HashMap parm =3D new HashMap ();=
</div><div>=A0=A0 =A0parm.put(&quot;type&quot;, type_val);</div><div>=A0=A0=
 =A0parm.put(&quot;month&quot;, month_val);</div>
<div>=A0=A0 =A0getSqlMapClientTemplate().queryForList(&quot;mymappingName.g=
etReportData&quot;, parm);</div><div><br></div><div><br></div><div>I could =
make a method that would take SP name + HashMap as parm and then just put i=
t on the log but then i&#39;d have to explicitly make a call to that method=
 before I call the Stored procedure. =A0I will take this as the last option=
 as it involves me touching all my existing code.=A0</div>
<div><br></div><div>Is there any simpler solution to this?</div></div></div=
>

--0015174be8bc9795f4048137620a--