How to handle stored procedure that returns a ref cursor to resul t sets with a single column?

["Yee, Richard K CTR DMDC" <Ri...@osd.pentagon.mil>]

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 <lm...@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
<ma...@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?
	

Re: How to handle stored procedure that returns a ref cursor to resul t sets with a single column?

[Larry Meadors <lm...@apache.org>]

Please don't hijack other threads. It's really easy to copy the email
address and start a new one:

user-java@ibatis.apache.org

Larry


On 6/7/07, Yee, Richard K CTR DMDC <Ri...@osd.pentagon.mil> wrote:
> 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 <lm...@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
> <ma...@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?
>
>
>
>