ResultSet to String java?

Question

I'm just after a way to convert a ResultSet to string I've tried:

toReturn = result.getString(0);

I'm only after a proof that its working and thought this would be all that I need to return it via:

writer.write(toReturn);

TIA

Answer 1

JDBC column indexes start at 1, not zero, so try result.getString(1)