looks like invalid SQL Curtie!
UPDATE ADEVAL.USER_PROXY set
PROXY_PRIV= ?,
LAST_UPDATED_BY = ?,
LAST_UPDATED_DT=?
WHERE USER_PROXY_ID = ?
JT
> To: [EMAIL PROTECTED]
> cc: (bcc: Janet Traub/IS/SSC/THD)
> Subject: [ND] JDBC Question
>
> I need another set of eyes.
>
> Here's my jdbc code, going against oracle:
>
> PreparedStatement pstmt = con.prepareStatement
> ("UPDATE ADEVAL.USER_PROXY set (PROXY_PRIV, LAST_UPDATED_BY,
> LAST_UPDATED_DT) = (?, ? ,?) WHERE USER_PROXY_ID = ?");
>
> pstmt.setString(1, request.getParameter("PROXY_PRIV"));
> pstmt.setInt(2,
> Integer.parseInt(session.getValue("SESSION_USER_ID").toString()));
> pstmt.setDate(3, new java.sql.Date(new java.util.Date().getTime()));
> pstmt.setInt(4, Integer.parseInt(USER_PROXY_ID));
>
> int rowcount;
>
> try
> {
> rowcount = pstmt.executeUpdate();
> }//try
>
> I'm getting a sql error:
> javax.servlet.ServletException: java.sql.SQLException: ORA-01767: UPDATE
> ... SET expression must be a subquery
>
> How am I messing up the sql-- played with all sorts of options
>
> Thx,
> Curt
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
>
>
>-----------------------------------------------------------------
>
> Name: pic30664.pcx
> pic30664.pcx Type: Bitmap Image
>(application/x-unknown-content-type-Paint.Picture)
> Encoding: base64
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
