Return-Path: 
 <user-java-return-11815-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 36059 invoked from network); 7 Jun 2007 16:47:05 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 7 Jun 2007 16:47:05 -0000
Received: (qmail 14715 invoked by uid 500); 7 Jun 2007 16:46:55 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 14696 invoked by uid 500); 7 Jun 2007 16:46:55 -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 14678 invoked by uid 99); 7 Jun 2007 16:46:55 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jun 2007 09:46:55 -0700
X-ASF-Spam-Status: No, hits=0.3 required=10.0
	tests=MAILTO_TO_SPAM_ADDR
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [140.185.212.91] (HELO DFSMTTAYZ001.ptc.pentagon.mil)
 (140.185.212.91)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jun 2007 09:46:51 -0700
Received: by dfsmttayz001.ptc.pentagon.mil with Internet Mail Service
 (5.5.2657.72)
	id <MMPMDKQB>; Thu, 7 Jun 2007 16:46:29 -0000
Message-ID: <D2909F64E8DF6A4DA12D5D83BFF5D607058808D0@ddsmttayz026>
From: "Yee, Richard K CTR DMDC" <Richard.Yee.ctr@osd.pentagon.mil>
To: user-java@ibatis.apache.org
Subject: How to handle stored procedure that returns a ref cursor to resul
	t sets with a single column?
Date: Thu, 7 Jun 2007 16:45:49 -0000 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2657.72)
content-class: urn:content-classes:message
x-mimeole: Produced By Microsoft Exchange V6.5
x-originalarrivaltime: 07 Jun 2007 16:46:13.0182 (UTC)
 FILETIME=[5BC33DE0:01C7A923]
Content-Type: text/plain;
	charset="iso-8859-1"
X-Virus-Checked: Checked by ClamAV on apache.org

I'm using iBATIS 2.3 with the <procedure> element in my sqlMap file to
call a stored procedure that returns ref cursor. The results are
returned in a list in the parameterMap. I'm using a resultMap to map the
columns to a bean. My question is whether there is a different way to
handle multiple column result sets vs. single column result sets. So
far, it seems to me that in either case, a resultMap element is required
to map the result to a Java bean. I am looking for a way to handle a
single String result. Right now it works if I create a Java bean class
that has a single String attribute. This seems a bit cumbersome to me.
Is there a way to specify that the result list contain Strings instead
of Java Beans with 1 String attribute?

Thanks,

Richard


-----Original Message-----
From: Josh [mailto:gemini929@gmail.com] 
Sent: Thursday, June 07, 2007 9:17 AM
To: user-java@ibatis.apache.org; lmeadors@apache.org
Subject: Re: How to capture time spent at DB?

Larry,
 
I like the proxy idea.  I can use spring/aop to create a proxy and
capture the calls to the sqlmapclient.  Has anyone do this already?
 
-Joshua

 
On 6/7/07, Larry Meadors <lmeadors@apache.org> wrote: 

	Your most accurate results will come from the database logging
	facilities from the database vendor.
	
	If you wanted, you could create a proxy on the sqlmapclient to
log
	times, but I think the results would be questionable, depending
on
	what you are trying to capture.
	
	Larry
	
	
	On 6/7/07, Josh < gemini929@gmail.com
<mailto:gemini929@gmail.com> > wrote:
	> Hello,
	>
	> I am using Spring 1.28 and Ibatis 2.1.7.  I am currently
logging my total
	> total response time and service layer response time.  I would
also like to 
	> capture the time spent at the DB.  Can anyone provide any
suggestions on how
	> to do this?