On Thu, Nov 01, 2001 at 08:59:57PM -0800, Daniel Rall wrote: [Problem with ResultSet.isLast and Oracle JDBC] > Is there any way to open the result set with a different type of > cursor than forward only? You need a "random access" cursor. ... > > return !(rs.isLast() || this.isEmpty);
Depending on the JDBC driver implementation the ResultSet.isLast might have performance issues as well (even fetching the next row twice). If possible I would use ResultSet.next instead and do some caching/book keeping within TableTool to have it called just once even if TableTool.hasNext is called multiple times or not at all between the row fetches. This is more complicated and not as clean as the current approach but I have found that it works better with less-than-perfect JDBC implementations. -- Johannes Lehtinen <[EMAIL PROTECTED]>, http://www.iki.fi/jle/ -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
