Hi All,
I want to use fetchsize in my select query.
Can I get sample for this.
--
With regards
Tushar Kherde
iBATIS does not provide a means to use the setFetchSize on a
PreparedStatement. If you are looking to limit the number of rows you get
back from the database then I suggest using queryForList(id, parmObject,
skip, max) or placing it in your SQL statement like select * from foo where
rownum10 in
Actually it does!
select ... fetchSize=50
Remember that it's just a hint though...not a guarantee IIRC.
Clinton
On 2/13/07, Brandon Goodin [EMAIL PROTECTED] wrote:
iBATIS does not provide a means to use the setFetchSize on a
PreparedStatement. If you are looking to limit the number of rows
Sorry for the bad info. Learn something new all the time. :-/
Brandon
On 2/13/07, Clinton Begin [EMAIL PROTECTED] wrote:
Actually it does!
select ... fetchSize=50
Remember that it's just a hint though...not a guarantee IIRC.
Clinton
On 2/13/07, Brandon Goodin [EMAIL PROTECTED] wrote:
I tried it with oracle 8i and driver jdbc14.jar but not working :(
I just added the fetchSize=5 attribute in select element. Is there
anything else i need to do please correct if i am wrong.
I am using iBATIS2.0 ( Note: i was using iBATIS1.0 and upgraded just by
changing jars )
If possible I need
You're using an 8 year old database and a 5 year old driver. :-)
The combination may not support fetch size properly.
Furthermore, even if it is supported by the driver, it is not
guaranteed to fetch exactly that number of rows. The following is an
excerpt from the JDK JavaDoc for
Sorry i am using ojdbc14.jar not jdbc14.jar which is for 10g i think its
recent release.
On 2/13/07, Clinton Begin [EMAIL PROTECTED] wrote:
You're using an 8 year old database and a 5 year old driver. :-)
The combination may not support fetch size properly.
Furthermore, even if it is
Regardless, all of the other points still apply. :-)
How are you testing to see if it works?
Clinton
On 2/13/07, Tushar Kherde [EMAIL PROTECTED] wrote:
Sorry i am using ojdbc14.jar not jdbc14.jar which is for 10g i think its
recent release.
On 2/13/07, Clinton Begin [EMAIL PROTECTED]
I have mentioned the fetchSize in select element
Following is the code
select fetchSize=5 id=ICE_COUNTRY.abatorgenerated_selectForIndex
resultMap=abatorgenerated_IceCountryResult parameterClass=java.util.Map
!--
WARNING - This element is automatically generated by Abator for
Oh.
You don't want fetch size. :-) Fetch size doesn't have anything to
do with the total returned records. It has to do with how many
records it returns at a time.
What you want is:
sqlMapClient.queryForList(findAllWhatevers, paramObj, skipThisMany,
getThisMany);
Page 57 - 61 of the
Hi,
Just checking,
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
What if the database is DB2? Are DB2 versions of ref cursor's supported?
Regards,
Amit
Hi,
Just checking,
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
What if the database is DB2? Are DB2 versions of ref cursor's supported?
Thanks,
Amit
DB2 doesn't implement the idea of a ref cursor. What feature of DB2 are you
trying to use?
Jeff Butler
On 2/13/07, Amit Kushwaha [EMAIL PROTECTED] wrote:
Hi,
Just checking,
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
What if the database is
I would just like to note that I anticipated that was what he wanted and
stated it upfront. Just cuz i was wrong on one point doesn't mean i was
wrong on every point :)
Brandon
On 2/13/07, Clinton Begin [EMAIL PROTECTED] wrote:
Oh.
You don't want fetch size. :-) Fetch size doesn't have
You know how when you propose using some new software library and
someone always asks Who else is using it?? Well that's where I am
now with iBATIS. I'm trying to convince a client that iBATIS is a
good solution for them. Is there a list of companies that are using
iBATIS somewhere?
Hahait was mass confusion all around. :-)
Clinton
On 2/13/07, Brandon Goodin [EMAIL PROTECTED] wrote:
I would just like to note that I anticipated that was what he wanted and
stated it upfront. Just cuz i was wrong on one point doesn't mean i was
wrong on every point :)
Brandon
On
See
http://opensource.atlassian.com/confluence/oss/pages/viewpage.action?pageId=25
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Feedback+and+Experiences
On 2/13/07, Mark Volkmann [EMAIL PROTECTED] wrote:
You know how when you propose using some new software library and
Jeff,
Right. DB2 stored procs, that returns back a result set.
Do you need to specify the jdbcType on the output parameter that is a
resultset?
For ex, in the /REFCURSOR /below,
resultMap id=product class=Product
result property=name columnIndex=1/
result property=description
When DB2 returns a result set from a stored proc, it is not as an output
parameter. It's just like the result set returned from a select statement.
So you don't declre an out parameter for the result set, you just use a
result map.
procedure id=statementName parameterClass=long,
A'ha. Thanks.
Jeff Butler wrote:
When DB2 returns a result set from a stored proc, it is not as an
output parameter. It's just like the result set returned from a
select statement. So you don't declre an out parameter for the result
set, you just use a result map.
procedure
Off the record, CNET is using it for certain applications.
-Original Message-
From: Mark Volkmann [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 9:22 AM
To: user-java@ibatis.apache.org
Subject: who's using it?
You know how when you propose using some new software library
Javaforge.com is also using IBATIS, (its getting really hot I think
nowadays)
Levan Dvalishvili
Support Lead US
Verticali,Inc
(646) 736 - 6075
-Original Message-
From: Daniel Pitts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 1:06 PM
To: user-java@ibatis.apache.org
We use it at LogicaCMG for lots of client applications at a number of national
and international clients across a range of sectors such as space and finance
systems
-Original Message-
From: Levan Dvalishvili [mailto:[EMAIL PROTECTED]
Sent: Tue 13/02/2007 19:29
To:
JP Morgan Chase is using it as part of their core Private Banking IT
Architecture as well. It might be getting sign offs in other areas of
Chase as well.
-Ayan
Daniel Pitts [EMAIL PROTECTED]
02/13/2007 01:06 PM
Please respond to
user-java@ibatis.apache.org
To
user-java@ibatis.apache.org
Hi
I have a web application where i am using ibatis, i have a situation where i
want to select the database from where i want to get data.
In this application user will login and select he wants to use development
1, or development 2 or test 1 from a drop down
So if the user selects
Use a properties object when you create the sql map client.
Larry
On 2/13/07, Ashish Kulkarni [EMAIL PROTECTED] wrote:
Hi
I have a web application where i am using ibatis, i have a situation where i
want to select the database from where i want to get data.
In this application user will
It's better to ask who don't use iBatis and give them an advise to use
it.
MV You know how when you propose using some new software library and
MV someone always asks Who else is using it?? Well that's where I am
MV now with iBATIS. I'm trying to convince a client that iBATIS is a
MV
Although this would require the use of the Spring Framework, it provides a
pretty transparent way to do what you're asking:
http://blog.interface21.com/main/2007/01/23/dynamic-datasource-routing/
You could probably adapt the idea pretty easily and get rid of the Spring
dependencies if that is
Thanks for all the feedback! I've compiled a list an added it to my
page of notes on iBATIS at http://www.ociweb.com/mark/iBATIS.html. I
also have notes on Abator at http://www.ociweb.com/mark/Abator.html.
Feedback on both is welcomed!
A big confusion from my side sorry :/
On 2/13/07, Clinton Begin [EMAIL PROTECTED] wrote:
Hahait was mass confusion all around. :-)
Clinton
On 2/13/07, Brandon Goodin [EMAIL PROTECTED] wrote:
I would just like to note that I anticipated that was what he wanted and
stated it upfront.
30 matches
Mail list logo