Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C67AB3.D51B53AA"
Subject: RE: Is it possible
Date: Thu, 18 May 2006 15:46:59 -0400
Message-ID: 
 <093D7E25FD9C2441A13103EFB8CBED3A0AD922F0@nmr001oldmsx04.enterprisenet.org>
Thread-Topic: Is it possible
thread-index: AcZ6saWMbwEEbJmwQsS/Z+dM7OwEeQAAfoAg
From: "Chen, Tim" <Tim.Chen@NielsenMedia.com>
To: <user-java@ibatis.apache.org>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C67AB3.D51B53AA
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Actually I turned on JDBC logging (I think it explains how in the IBatis
log) using log4j and from that you can infer which goes out as queries
and which doesn't (which goes to cache). Don't know if there's another
solution but it's really easy to do.

________________________________

From: Zacks, Michael [mailto:Michael_Zacks@ziffdavis.com]=20
Sent: Thursday, May 18, 2006 3:31 PM
To: user-java@ibatis.apache.org
Subject: Is it possible


To determine whether query results were returned from the cache or from
a trip to the database?  I'm running Ibatis against SqlServer.  My
problem is that I have a query that was meant to be cached, but instead
was being run every time against the database - much to the detriment of
our application.  I think I know what the problem is (I suspect it is an
accidental 'select * from'), but I would like to be able to verify when
database results came from the cache or not.

Thanks in advance.=20

=20
=20
This e-mail message and any attachments to it are for the sole use of
the intended recipients and may contain confidential and privileged
information. This e-mail message and any attachments are the property of
Ziff Davis Media Inc. or its affiliates. Any unauthorized review, use,
disclosure, or distribution of this e-mail message or its attachments is
prohibited. If you are not an intended recipient, please notify the
sender by reply e-mail and destroy all copies of the original message
and any attachments. Thank you.


------_=_NextPart_001_01C67AB3.D51B53AA
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:eXclaimer =3D "http://www.exclaimer.co.uk" xmlns:msxsl =3D=20
"urn:schemas-microsoft-com:xslt" xmlns:exc =3D=20
"http://www.exclaimer.co.uk/rtf"><HEAD><TITLE>Is it possible</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D133324519-18052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Actually I turned on JDBC logging (I think it =
explains how=20
in the IBatis log) using log4j and&nbsp;from that&nbsp;you can =
infer&nbsp;which=20
goes out as queries and which doesn't (which goes to cache). Don't know =
if=20
there's another solution but it's really easy to =
do.</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Zacks, Michael=20
[mailto:Michael_Zacks@ziffdavis.com] <BR><B>Sent:</B> Thursday, May 18, =
2006=20
3:31 PM<BR><B>To:</B> user-java@ibatis.apache.org<BR><B>Subject:</B> Is =
it=20
possible<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><!-- Converted from text/rtf format -->
<P><FONT face=3DArial size=3D2>To determine whether query results were =
returned from=20
the cache or from a trip to the database?&nbsp; I'm running Ibatis =
against=20
SqlServer.&nbsp; My problem is that I have a query that was meant to be =
cached,=20
but instead was being run every time against the database - much to the=20
detriment of our application.&nbsp; I think I know what the problem is =
(I=20
suspect it is an accidental 'select * from'), but I would like to be =
able to=20
verify when database results came from the cache or not.</FONT></P>
<P><FONT face=3DArial size=3D2>Thanks in advance.</FONT> </P></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Courier New"><FONT =
face=3DArial size=3D2>
<P>This e-mail message and any attachments to it are for the sole use of =
the=20
intended recipients and may contain confidential and privileged =
information.=20
This e-mail message and any attachments are the property of Ziff Davis =
Media=20
Inc. or its affiliates. Any unauthorized review, use, disclosure, or=20
distribution of this e-mail message or its attachments is prohibited. If =
you are=20
not an intended recipient, please notify the sender by reply e-mail and =
destroy=20
all copies of the original message and any attachments. Thank=20
you.</P></FONT></DIV></BODY></HTML>

------_=_NextPart_001_01C67AB3.D51B53AA--