1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

CLI0145E Fetch type out of range.

Discussion in 'Java' started by daiondoroga, Aug 12, 2006.

  1. daiondoroga

    daiondoroga New Member

    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?

  2. shabbir

    shabbir Administrator Staff Member

    Can you elaborate a bit more on when and where you are getting the errors.
  3. daiondoroga

    daiondoroga New Member

    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?

  4. shabbir

    shabbir Administrator Staff Member

    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
    ResultSet rs = executeQuery("SELECT COUNT(*) AS rowcount FROM MyTable");
    int RocordCount = rs.getInt("rowcount") ;
    rs.close() ;

Share This Page