The thing is that when I used the result set's first method it returned true which means I should be able to retrieve data from the current row but this is not happening.
Rick Hillegas-2 wrote: > > digi_pixel wrote: >> By the way I was trying to retrieve the column using index 0. I have >> attempted to re run the application by changing the index to 1 this time, >> however a new run time error now appears: >> >> org.apache.derby.client.am.SqlException: Invalid operation to read at >> current cursor position. >> >> >> Rick Hillegas-2 wrote: >> >>> Without seeing your code, I can only speculate about what the problem >>> is. However, your problem may be that you are trying to retrieve the >>> first column using the index 0. Annoyingly, the JDBC methods use >>> 1-based, not 0-based indexing. So the first thing to verify is that you >>> are retrieving the initial column using index 1, not 0. >>> >>> Hope this helps, >>> -Rick >>> >>> >>> >> >> > Maybe you are positioned before the first row or after the last row. > Make sure that you issue a ResultSet.next() call before trying to > retrieve the first row. In general, make sure that ResultSet.next() > evaluates to true before each row that you read. When ResultSet.next() > returns false, you are at the end of the data and you will get an > exception if you try to read past the end. > > Hope this helps, > -Rick > > -- View this message in context: http://www.nabble.com/SqlException-With-Returning-Data-For-First-Row-tf4952206.html#a14181170 Sent from the Apache Derby Users mailing list archive at Nabble.com.
