ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <rambabu.pir...@wipro.com>
Subject -------Pagination----Need help
Date Tue, 25 Jul 2006 06:06:31 GMT



Hi,

I have two tables user_info and user_dynamic_info

the following is the table structure

user_info
=======
user_id           primarykey
user_name
user_password

user_dynamic_info
=============
user_id   ForeignKey(user_info)
property_name
property_value

I have one bean class which maps the information from these tables to
one java Object

public class User
{
    String userId;
    List dynamicInfo;
}


Now the table contains 200 records, and I want to retrieve 10 records
every time when i invoke the select query.

inside the method

public List getProperties(int fromRecord, int recordsPerTransaction)
{
     List list =   SqlMapClient.queryForList("getProperties",null)
}

It is working fine when the records count is more than 500. But when my
Db contains lessthan 500 records, the result is unpredictable.

my query is
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=EXTENSIN.USER_ID.

is there any way to pass the fromRecord, recordsPerTransaction  to the
query

Can any one help me in this regard,



Thanks n Regards,
==============
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
Mime
View raw message