Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of jeffgbutler@gmail.com
 designates 209.85.146.183 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=Rg8lY3EEGn9OxI9lXbBWcjxqAGP4ZwV+AkqVqleVbJ/+E+aLqVlgHZ7cCgdOrS8flk/ylGHi7Uv6uTCR1LglyM7he0qBbRDGai9tca1kd8FHfnc1AqKpYkorPutaph0DHsCfolUvU0galgEACPxP7T5sivl9fO4mTG4h45BjBHg=
Message-ID: <c593b8750711130935yba182b1r454e557b1a292e5e@mail.gmail.com>
Date: Tue, 13 Nov 2007 11:35:43 -0600
From: "Jeff Butler" <jeffgbutler@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: Logging oddity
In-Reply-To: <c0312f5d0711130923r5f5987e8h7d026c9816358e61@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_11566_13272357.1194975343169"
References: <c0312f5d0711130923r5f5987e8h7d026c9816358e61@mail.gmail.com>

------=_Part_11566_13272357.1194975343169
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

This is related to a structural defect in the way iBATIS does logging.
iBATIS does logging through dynamic proxies for all the JDBC objects - and
these objects are only proxied if the Connection object itself is proxied.
The Connection object is proxied only if debugging is enabled for it.  So,
you'll not get any logging unless debugging is enabled for Connection.

It wouldn't be too difficult to fix I suppose.

Jeff Butler

On Nov 13, 2007 11:23 AM, Gwyn Evans <gwyn.evans@gmail.com> wrote:

> Hi - wonder if anyone can explain this...
>
> I'm testing with ibatis & am finding that if I have
>
> java.sql.Connection = Info
> java.sql.PreparedStatement = Debug
> java.sql.ResultSet = Debug
>
> then I don't get *any* ibatis logging, but if I change just the
> java.sql.Connection value to Debug, then I get the following:
>
> 2007-11-13 17:17:57|   |C-1|Connection|Debug|{conn-100000} Connection
> 2007-11-13 17:17:57|   |C-1|Connection|Debug|{conn-100000} Preparing
> Statement:  SELECT ID, DEST, SMSCA, T FROM SMSCAA ORDER BY ID ASC
> LIMIT 1
> 2007-11-13 17:17:57|   |C-1|PreparedStatement|Debug|{pstm-100001}
> Executing Statement:  SELECT ID, DEST, SMSCA, T FROM SMSCAA ORDER BY
> ID ASC LIMIT 1
> 2007-11-13 17:17:57|   |C-1|PreparedStatement|Debug|{pstm-100001}
> Parameters: []
> 2007-11-13 17:17:57|   |C-1|PreparedStatement|Debug|{pstm-100001} Types:
> []
> 2007-11-13 17:17:57|   |C-1|ResultSet|Debug|{rset-100002} ResultSet
>
> If I leave Connection as debug & raise PreparedStatement to Info, then
> I loose that as expected, but I can't get PreparedStatement without
> Connection?
>
> (The settings are from Simple-log, which is where JCL is being adapted
> to, so could be an issue with that, I guess...)
>
> /Gwyn
>

------=_Part_11566_13272357.1194975343169
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>This is related to a structural defect in the way iBATIS does logging.&nbsp; iBATIS does logging through dynamic proxies for all the JDBC objects - and these objects are only proxied if the Connection object itself is proxied.&nbsp; The Connection object is proxied only if debugging is enabled for it.&nbsp; So, you&#39;ll not get any logging unless debugging is enabled for Connection.
</div>
<div>&nbsp;</div>
<div>It wouldn&#39;t be too difficult to fix I suppose.</div>
<div>&nbsp;</div>
<div>Jeff Butler<br><br></div>
<div class="gmail_quote">On Nov 13, 2007 11:23 AM, Gwyn Evans &lt;<a href="mailto:gwyn.evans@gmail.com">gwyn.evans@gmail.com</a>&gt; wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi - wonder if anyone can explain this...<br><br>I&#39;m testing with ibatis &amp; am finding that if I have
<br><br>java.sql.Connection = Info<br>java.sql.PreparedStatement = Debug<br>java.sql.ResultSet = Debug<br><br>then I don&#39;t get *any* ibatis logging, but if I change just the<br>java.sql.Connection value to Debug, then I get the following:
<br><br>2007-11-13 17:17:57| &nbsp; |C-1|Connection|Debug|{conn-100000} Connection<br>2007-11-13 17:17:57| &nbsp; |C-1|Connection|Debug|{conn-100000} Preparing<br>Statement: &nbsp;SELECT ID, DEST, SMSCA, T FROM SMSCAA ORDER BY ID ASC<br>
LIMIT 1<br>2007-11-13 17:17:57| &nbsp; |C-1|PreparedStatement|Debug|{pstm-100001}<br>Executing Statement: &nbsp;SELECT ID, DEST, SMSCA, T FROM SMSCAA ORDER BY<br>ID ASC LIMIT 1<br>2007-11-13 17:17:57| &nbsp; |C-1|PreparedStatement|Debug|{pstm-100001} Parameters: []
<br>2007-11-13 17:17:57| &nbsp; |C-1|PreparedStatement|Debug|{pstm-100001} Types: []<br>2007-11-13 17:17:57| &nbsp; |C-1|ResultSet|Debug|{rset-100002} ResultSet<br><br>If I leave Connection as debug &amp; raise PreparedStatement to Info, then
<br>I loose that as expected, but I can&#39;t get PreparedStatement without<br>Connection?<br><br>(The settings are from Simple-log, which is where JCL is being adapted<br>to, so could be an issue with that, I guess...)<br>
<font color="#888888"><br>/Gwyn<br></font></blockquote></div><br>

------=_Part_11566_13272357.1194975343169--