Your resultSet needs to be scrollable. You have created a streaming resultSet.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/26/04, 12:33:38 PM, Ted Hulick "(nVision" "Software)" <[EMAIL PROTECTED]> wrote regarding Large ResultSets/TYPE_SCROLL_INSENSITIVE: > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
