ResultSet 'update' method gives sql Exception

Hi,

Im trying to update a record using the ResultSet 'updateTime' method as follows:

Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

ResultSet rs = st.executeQuery("SELECT (*) FROM MESSAGESTORE WHERE (UID=" + uid + ")");

// ive cut out a bit of the code here - just basically enters into a while loop

Time timeRec = new java.sql.Time( new Date().getTime() );

rs.updateTime( "TIMERECEIVED", timeRec );

TIMERECEIVED is of Type Time, so there shouldnt be a problem there, but I am getting:

java.sql.SQLException: This function is not supported

I get the same exception if I try to use just the rs.update() method.

Is this a known problem?

Cheers

Josh

[779 byte] By [joshsmitha] at [2007-11-27 0:14:50]