com.microsoft.sqlserver.jdbc.SQLServerException: The result set has no current row

Question

I am trying to get the first column in the first row of my result set. I know I can change my SQL query to do that. BUT no. I want the full table and I only want to do what I just mentioned.

NOTE - Winners is an Aliased column in my sql query.

The error is basically -

com.microsoft.sqlserver.jdbc.SQLServerException: 
The result set has no current row.

More of the error -

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.verifyResultSetHasCurrentRow(SQLServerResultSet.java:483)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(SQLServerResultSet.java:2047)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2082)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2067)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(SQLServerResultSet.java:2401)

This is what I have tried so far and I need your help to fix it -

ResultSet rs = statement.executeQuery("get a whole table"); //pseudocode

try{            
    rs.next();
    numberOne = rs.getString("Winners");
    rs.first(); 
} catch (SQLException e) {
    e.printStackTrace();
}

Konstantin Yovkov · Accepted Answer · 2013-05-28 21:47:54Z

5

There is probably nothing in your result set. Use

if (rs.next()) {
    numberOne = rs.getString("Winners");
}

edited May 28, 2013 at 21:47

Konstantin Yovkov

63k9 gold badges107 silver badges152 bronze badges

answered May 28, 2013 at 21:46

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Apple Grinder Over a year ago

Yes, thats strange. How can there be nothing in my result set ? I have executed the same query in my database and I get results. But java fails :(

JB Nizet Over a year ago

Either you're not pointing to the same database or schema, or you've not committed the transaction used to insert the rows.

Apple Grinder Over a year ago

I ran the same query on SQL server which my ResultSet uses. It works fine. Don't know why this does not work in Java. Commit is not a problem, DB is loaded with rows. I only need to read DB and not write to DB.

Apple Grinder Over a year ago

I used the CachedRowSetImpl along with the irritating ResultSet. Now, it works.

geisterfurz007 Over a year ago

This is completely broken... I have something in my ResultSet but can only use it, when I place rs.beforeFirst(); rs.next(); in front of rs.getSomething();... Any idea why this happens and how to fix it?

Collectives™ on Stack Overflow

com.microsoft.sqlserver.jdbc.SQLServerException: The result set has no current row

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related