Manal,

You have not closed the ' for RES_STATUS

int rowsaffected = stmt.executeUpdate("UPDATE
RESERVATION SET RES_STATUS='" + canceled + "' WHERE
RESERVATION_NUM=" + resno);

Kapil


--- Manal Rayess <m_rayess@h...> wrote:
> it is a query:
> 
> int rowsaffected = stmt.executeUpdate("UPDATE
> RESERVATION SET 
> RES_STATUS='" + canceled + " WHERE RESERVATION_NUM="
> + resno);
> 
> the error message says that: "java.sql.SQLException:
> ORA-01756: quoted 
> string not properly terminated"
> 
> Note: the table and columns names are valid.
>