help whit ResultSet

[Hugo de la Mora]

Hi, I need help for the next methods (first(),last(),absolute())because dont work and send me this error in
import java.sql.*;
public class Query {
public static void main(String[] args) {
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception e) {
System.err.println("Driver Error...");
e.printStackTrace();
}
try {
String cadCon="jdbc:mysql://127.0.0.1/xxx";
Connection conexion = DriverManager.getConnection(cadCon,"xx ","xx");
Statement sentencia = conexion.createStatement();
String consulta="SELECT * FROM bajas";
ResultSet srs = sentencia.executeQuery(consulta);
srs.absolute(4); //here send me Error
int rowNum = srs.getRow(); // rowNum should be 4
srs.relative(-3);
int rowNum2 = srs.getRow(); // rowNum should be 1
srs.relative(2);
int rowNum3 = srs.getRow(); // rowNum should be 3
System.out.println("one "+rowNum+"two"+rowNum2+"three"+rowNum3);
and then i got the error
java.lang.AbstractMethodError
at Consulta.main(Consulta.java:26)
Exception in thread "main"
the method srs.next() work it, so I dont know what I have to do? thank for your help.

[Juanjo Bazan]

The MySQL's ResultSet class do not has implemented the first(), last() & absolute() methods.
Every database vendor implements its own class from the ResultSet interface, so sometimes you dont have all the methods available.
Take a look at the documentation included with the database you chose.
HTH

[David O'Meara]

Check you are using the most recent version of the mm.MySQL drivers. I was pretty sure those methods had been implemented

[Hugo de la Mora]

Thanks, I downloaded the new driver and then work it, I really apreciate it, thanks.