Re: [ND] JDBC Question

[Shamdasani Nimmi-ANS004]

Curt,

Try Replacing:

        ("UPDATE ADEVAL.USER_PROXY set (PROXY_PRIV, LAST_UPDATED_BY, 
LAST_UPDATED_DT) = (?, ? ,?) WHERE USER_PROXY_ID = ?");

with:
        ("UPDATE ADEVAL.USER_PROXY set PROXY_PRIV = ?, LAST_UPDATED_BY=?, 
LAST_UPDATED_DT=? WHERE USER_PROXY_ID = ?");

-----Original Message-----
From: Curt Springer [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 18, 1999 9:53 AM
To: [EMAIL PROTECTED]
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]
_________________________________________________________________________

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]