I'm using SQLite for an academic project, through Java's JDBC (sqlitejdbc-0.5.4.jar). After executing a simple select, i can iterate the ResultSet all the way (showing to output), no problem. The problem, which may be silly, is that i need to get a row count so i can initialize a variable.
I tried using rs.getFetchSize() but it returns 0. This is the only method i could relate to "getting number of rows" from the method list. I tried rs.last(); but get "SQLException: ResultSet is TYPE_FORWARD_ONLY" and wouldn't be able to get back anyway. I tried iterating the set and using rs.isLast() but i get "SQLException: function not yet implemented for SQLite". I've also tried setting flags on the statement but i get the same exceptions. Am i missing something obvious? TIA, Nuno Magalhães --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
