rs.first() error

[ed copony]

hi. i am getting the following error when compiling:
cannot find method "first()"
-------
the code is this:
...
ResultSet rs = stmt.executeQuery("valid sql statement here");
if (rs.first()) {
...
and at the top of the file i have imported the java.sql package like so:
import java.sql.*;
------
so how come i can't call first() when it found the class ResultSet? and is there a better way to determine if anything was returned by the query?
thanks!
ed

[ed copony]

after more digging i see that my driver does not support the first() method -- i guess that explains it.
(i'll just be in here talking to myself if anyone needs me.)

[Dharmesh Chheda]

hey ED
while creating the statement object do the following

stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

and then execute the query
it will work
------------------
IBM Certified WebSphere Application Server V3.5 Specialist

[Peter den Haan]

Won't work - he got a compile-time error, not a run-time error. Willing to bet that it's a JDBC 1 driver.
- Peter

[Dharmesh Chheda]

hey peter.. oops i didnt notice it .. thanx for correcting my reply..