public void updateBug(int id, String actionDescription) throws SQLException
{
	Statement cs = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
 
	cs.executeQuery("A Select statement");
 
	while (true)
	{
		int updateCount = cs.getUpdateCount();
		ResultSet rs = cs.getResultSet();
		if (rs == null && updateCount == -1) break;
 
		if (rs != null)
		{
			while (rs.next())
			{
				if(rs.getInt(BUG_ID) == id)
				{
					rs.updateString(ACTION_DESCRIPTION, "Hello World");
					rs.updateRow();
				}
			}
			rs.close();
		}
		cs.getMoreResults();
	}
 
	destroy();
}

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Row update fai
led.
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.base.BaseImplUpdatableResultSet.executeStatement(U
nknown Source)
        at com.microsoft.jdbc.base.BaseImplUpdatableResultSet.updateRow(Unknown
Source)
        at com.microsoft.jdbc.base.BaseResultSet.updateRow(Unknown Source)
        at BTViewBugAction.updateBug(BTViewBugAction.java:230)
        at BTViewBugAction.main(BTViewBugAction.java:288)