CLI0145E Fetch type out of range.

daiondoroga's Avatar
Go4Expert Member
Hi,
When i try to call resultset.last() method on scrollable resultset i am getting the following error message :
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0145E Fetch type out of range. SQLSTATE=HY106

I am using Visual Age for Java.

Can any one help me in this problem?

Thanks
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Can you elaborate a bit more on when and where you are getting the errors.
daiondoroga's Avatar
Go4Expert Member
I have choosen TYPE_SCROLL_INSENSITIVE and CONCUR_READ_ONLY
options for the resultset. Basically I want to get the row count in the resultset. So first method i am calling is resultSet.last(), there itself I could not proceed. Later I am using other methods like getRow(), first(), but I could not go till there.
Do u have any clue why is it giving exception?

Thanks
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Quote:
Originally Posted by daiondoroga
Basically I want to get the row count in the resultset. So first method i am calling is resultSet.last(), there itself I could not proceed.
Do not use resultSet.last() to get the no of row count as that will not return you the count properly instead use the count SQL something like
Code: JAVA
ResultSet rs = executeQuery("SELECT COUNT(*) AS rowcount FROM MyTable");
rs.next();
int RocordCount = rs.getInt("rowcount") ;
rs.close() ;