Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 55160 invoked from network); 25 Jul 2006 06:11:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 25 Jul 2006 06:11:15 -0000 Received: (qmail 18048 invoked by uid 500); 25 Jul 2006 06:07:01 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 18036 invoked by uid 500); 25 Jul 2006 06:07:01 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 18023 invoked by uid 99); 25 Jul 2006 06:07:01 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Jul 2006 23:07:01 -0700 X-ASF-Spam-Status: No, hits=0.6 required=10.0 tests=HTML_MESSAGE,NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [203.91.201.15] (HELO wip-cdctls-mx1.wipro.com) (203.91.201.15) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 24 Jul 2006 23:06:57 -0700 Received: from wip-cdctls-mx1.wipro.com (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with ESMTP id 669783C4124 for ; Tue, 25 Jul 2006 11:34:21 +0530 (IST) Received: from chn-snr-bh1.wipro.com (chn-snr-bh1.wipro.com [10.145.50.91]) by wip-cdctls-mx1.wipro.com (Postfix) with ESMTP id 591843C4032 for ; Tue, 25 Jul 2006 11:34:21 +0530 (IST) Received: from HYD-MDP-MBX01.wipro.com ([10.150.50.182]) by chn-snr-bh1.wipro.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 25 Jul 2006 11:36:33 +0530 x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6AFB0.7ACFBEE8" Subject: -------Pagination----Need help Date: Tue, 25 Jul 2006 11:36:31 +0530 Message-ID: <2E7899FA2A83AB4480078DA88C8F10FB01A6AC76@HYD-MDP-MBX01.wipro.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: -------Pagination----Need help Thread-Index: AcavsHlm39HzLh7LR9+Wn5oXykQ+ig== From: To: X-OriginalArrivalTime: 25 Jul 2006 06:06:33.0925 (UTC) FILETIME=[7AFE9F50:01C6AFB0] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C6AFB0.7ACFBEE8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =0D =0D Hi, =0D I have two tables user_info and user_dynamic_info =0D the following is the table structure =0D user_info=0D =3D=3D=3D=3D=3D=3D=3D user_id primarykey user_name user_password =0D user_dynamic_info =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D user_id ForeignKey(user_info) property_name=0D property_value =0D I have one bean class which maps the information from these tables to one java Object =0D public class User { String userId; List dynamicInfo; } =0D =0D Now the table contains 200 records, and I want to retrieve 10 records every time when i invoke the select query. =0D inside the method=0D =0D public List getProperties(int fromRecord, int recordsPerTransaction)=0D { List list =3D SqlMapClient.queryForList("getProperties",null) } =0D It is working fine when the records count is more than 500. But when my Db contains lessthan 500 records, the result is unpredictable. =0D my query is=0D select BASIC.USER_ID,BASIC.USER_PWD,BASIC.USER_NAME EXTENSIN.USER_ID, EXTENSIN.PROPERTY_NAME,EXTENSIN.PROPERTY_VALUE from USER_INFO BASIC LEFT OUTER JOIN USER_DYNAMIC_INFO EXTENSIN ON BASIC.USER_ID=3DEXTENSIN.USER_ID. is there any way to pass the fromRecord, recordsPerTransaction to the query Can any one help me in this regard, =0D =0D Thanks n Regards, =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Rambabu=0D The information contained in this electronic message and any attachments to= this message are intended for the exclusive use of the addressee(s) and= may contain proprietary, confidential or privileged information. If you= are not the intended recipient, you should not disseminate, distribute or= copy this e-mail. Please notify the sender immediately and destroy all= copies of this message and any attachments.=0D WARNING: Computer viruses can be transmitted via email. The recipient= should check this email and any attachments for the presence of viruses.= The company accepts no liability for any damage caused by any virus= transmitted by this email. =0D www.wipro.com ------_=_NextPart_001_01C6AFB0.7ACFBEE8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
 
 
Hi,
 
I have two tables user_info and=0D user_dynamic_info
 
the following is the table=0D structure
 
user_info=0D
=3D=3D=3D=3D=3D=3D= =3D
user_id       &nbs= p;  =0D primarykey
user_name
user_password
 
user_dynamic_info
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D
user_id  =0D ForeignKey(user_info)
property_name=0D
property_value
 
I have one bean class which maps= the=0D information from these tables to one java=0D Object
 
public class=0D User
{
    String=0D userId;
    List=0D dynamicInfo;
}
 
 
Now the table contains 200= records,=0D and I want to retrieve 10 records every time when i invoke the select= =0D query.
 
inside the=0D method 
 
public List getProperties(int= fromRecord,=0D int recordsPerTransaction) 
{
     List list=0D =3D  =0D SqlMapClient.queryForList("getProperties",null)=
}
 
It is working fine when the= records count=0D is more than 500. But when my Db contains lessthan 500 records, the result= is=0D unpredictable.
 
my query is=0D

select BASIC.USER_ID,BASIC.USER_PWD,BASIC.USER_NAME= =0D EXTENSIN.USER_ID,= EXTENSIN.PROPERTY_NAME,EXTENSIN.PROPERTY_VALUE=0D from USER_INFO BASIC LEFT OUTER= JOIN=0D USER_DYNAMIC_INFO EXTENSIN ON BASIC.USER_ID=3DEXTENSIN.USER_ID.

is there any way to pass the fromRecord,=0D recordsPerTransaction  to the query

Can any one= help me in=0D this=0D regard,

<= /DIV>
 
 
Thanks n=0D Regards,
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Rambabu=

The information contained in this electronic message and any attachments to= this message are intended for the exclusive use of the addressee(s) and= may contain proprietary, confidential or privileged information. If you= are not the intended recipient, you should not disseminate, distribute or= copy this e-mail. Please notify the sender immediately and destroy all= copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient= should check this email and any attachments for the presence of viruses.= The company accepts no liability for any damage caused by any virus= transmitted by this email.

www.wipro.com
------_=_NextPart_001_01C6AFB0.7ACFBEE8--