I am using this: Statem=MyQueryResults.ConnectionUsed.createStatement( java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); Statem.setFetchSize(Integer.MIN_VALUE);
But, it will not allow me to do .first() on the ResultSet...or reset to first record on the result set... TYPE_SCROLL_INSENSITIVE allows bi-directional scrolling of records... Am I correct in that I am seeing that MySQL 3.0.11 JDBC Client does not support anything other than TYPE_FORWARD_ONLY and .next() on result set? Any help would be appreciated.... Ted