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
Originally posted by rnealejr What type of cursor are you using ? What other methods can you use on the resultset ?
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?
Comment out the last() method and just try executing a next twice and then a previous. Also, please post your code including the connection/statement/resultset. Let me know the results of this test - just try the next and previous methods only and see if an error is returned.
i've weblogic5.1 & i am working with stateless session beans. i am able to deploy the bean. but, when i run the client class, it is getting connected to the server and then, the following error occurs:
Exception java.rmi.RemoteException: java.lang.NoClassDefFoundError: org/xml/sax/InputSource
my bean class is XMLReaderBean which would read the contents of
an xml file. hence, i've imported the org.jdom.input.SAXBuilder.
kindly, let me know how to correct this error. expecting ur immediate reply.
Originally posted by rnealejr Comment out the last() method and just try executing a next twice and then a previous. Also, please post your code including the connection/statement/resultset. Let me know the results of this test - just try the next and previous methods only and see if an error is returned.
Hello. I too am experiencing this CLI0145E with SQLSTATE=HY106 issue. . .I am also using the same params on the resultset:
I tried your suggestion to the previous person... commenting out the .last() method and then trying a few .next() and then a .previous(). These statements worked fine... yet in my next line of code I try to get the number of rows: int nbrRows = gVORS.getRow(); and it says that I have 0.