mysql - java.sql.SQLException: Before start of result set -

i don't understand why isn't working, keep getting java.sql.sqlexception: before start of result set error, ive looked online because ive been staring @ computer screen hours brain frazzling i'm not able find soloutions. please can me?!

string = ""; string subject= ""; string to= ""; string message= ""; try {     while(retrievemessages().next())     {          = retrievemessages().getstring("tblemail.to");          = retrievemessages().getstring("tblemail.from");          subject = retrievemessages().getstring("tblemail.subject");          message = retrievemessages().getstring("tblemail.message");          mailbox.add(new email(to, from, subject, message));     } } catch (sqlexception e) {      e.printstacktrace(); } 

you're calling retrievemessages() multiple times. doesn't haven't shown does, suspect want call once , store result in local variable. @ moment, suspect you're calling next() on 1 result set, getstring() on different result set. example:

try (resultset results = retrievemessages()) {     while (results.next()) {         string = results.getstring("tblemail.to");         string = results.getstring("tblemail.from");         string subject = results.getstring("tblemail.subject");         string message = results.getstring("tblemail.message");         mailbox.add(new email(to, from, subject, message));     } }