Manal,

It looks like you left out the closing single quote in the SQL statement
near cancelled.  It should be:

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

-Christopher

-----Original Message-----
From: Pro_JavaServer_Pages digest [mailto:pro_jsp@p...]
Sent: Sunday, May 13, 2001 7:01 PM
To: pro_jsp digest recipients
Subject: pro_jsp digest: May 13, 2001


PRO_JSP Digest for Sunday, May 13, 2001.

1. What's the problem with this statement?

----------------------------------------------------------------------

Subject: What's the problem with this statement?
From: "Manal Rayess" <m_rayess@h...>
Date: Sun, 13 May 2001 12:36:21
X-Message-Number: 1

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.