Resultset has more than 10000 records - Its not working

[Praneeth Reddy]

Hi All,

 

I am facing some wierd issue , If the records are more than 10000 for below mentioned query then its not processing futher after executing the query

but if it is less than 10000 its fetching the data from db ,returning to implementation class.

 

Mapper.xml

 

<select id="getNormalTransactions" resultMap="SLS_TRN_HDR_OPR"> 
SELECT hdr.sls_tran_opr_num
FROM
 
  Table
 
   WHERE  RTKL.RETRICKLE_SOURCE='O'
   AND RTKL.RETRICKLE_STATUS='V';
</select>

mapper.java  ---

public List<SlsTrnHdrOpr> getNormalTransactions()

Impl class :  ---

List<SlsTrnHdrOpr> normalTranDTOs = retrickleTransactionDAO
                        .getNormalTransactions();

DAO Class :

List<SlsTrnHdrOpr> normalTrans = null;
  normalTrans = retrickleMapper
                    .getNormalTransactions();

 

Could you please help me out .

Thanks

[Iwao AVE!]

Hi,

Can you get all rows if you execute the query using plain JDBC (i.e.
without MyBatis) ?
Which version of database/driver do you use?

Regards,
Iwao


2013/5/17 Praneeth Reddy <pranith....@gmail.com>:

> --
> You received this message because you are subscribed to the Google Groups
> "mybatis-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to mybatis-user...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Jose María Zaragoza]

Hello:

You could try to execute the same query by using JDBC API , with the same JDBC driver and the same URL connection and test from the same machine )

Yoy didn't tell anything about your DBMS , or your JDBC driver, or your configuration 

Regards

2013/5/17 Praneeth Reddy <pranith....@gmail.com>

--