How do i retrieve a whole row of data at once?

[krishnaIn]

How do i retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX methods for each column?

[writetokaruna@yahoo.com]

Hi Krishna,
you cannot retrieve complete row of data at once,ResultSet.getXXX() is the only way to fetch data from ResultSet object.

Comments are welcome.

Thanks&Regards,
R.P.Karunakaran.

[krishnaIn]

Thank You dude!

With Regards,
SRK

[harikotha]

Hi Dudes,

U can fetch a entire row using ResultSet.getRow() method , refer the documents or API once ....
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.

.....

Regards
Hari

[krishnaIn]

getRow() method of ResultSet returns the row number not the data of entire row.
if u have any doubts just check API.

With Regards
SRK

[sandy_rgpv]

U can fetch Entire row using ResultSet.getRow() method , refer the documents or API once ....
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.