Peter Barraud wrote: > Hi, > Anybody has any idea of how to get the recordcount of a resultset using jdbc > 1. Not JDBC 2. > Any suggestions would be great > _______________________________________________ > Advanced-swing mailing list > [EMAIL PROTECTED] > http://eos.dk/mailman/listinfo/advanced-swing
Peter, Why do you need tht count? In many of our applications, we use the count for controlling the update of a progress bar where we are processing a lot of data. So we use the "count(*)" method. Any small discrepancies in the count between the SQL call to get the count and to get the actual reasult set does not matter for this purpose. However, depending on the query, "count(*)" can take some time. If your query is small, then you could use the ArrayList approach that was recommended. Why would you need the result set if you have all of the data in an array list? Cynthia Jeness _______________________________________________ Advanced-swing mailing list [EMAIL PROTECTED] http://eos.dk/mailman/listinfo/advanced-swing
