updateRow() throws " ORA-00907: missing right parenthesis"

[Terry Luedtke]

Hi,
I'm trying to use an updateable record set, however whenever I update a row, I get the error " ORA-00907: missing right parenthesis". The query I use to get the record set is fine as I can extract the selected values. I just can't call updateRow(). Has anyone come across this? My code is:

  
      try {
        conn = JdbcFactory.getConnection();
        conn.setAutoCommit(false);
        log("Getting remaining count");
        PreparedStatement requestStmt = conn.prepareStatement(
                "SELECT remaining "
              + "FROM requests "
              + "WHERE id = ? "
              + "FOR UPDATE ",
              ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE
              );
        requestStmt.setLong(1, id);
        ResultSet requestRs = requestStmt.executeQuery();
                
        if(!requestRs.next()) {
          throw(new IllegalArgumentException(
          "Transaction ID " + id + " does not exist."));
        }
        log("extracting remaining");
        int remaining = requestRs.getInt("remaining");
        log(remaining + " remaining");
        /*
         * Remove requested quantity from inventory and
         * update the request to reflect shipped quantity
         */
        int backorder = 1;
        log("updating remaining quantity to " + backorder);
        requestRs.updateInt(1, 1);
//        requestRs.updateInt("remaining", backorder);
        
        log("updating row");
        requestRs.updateRow(); // ERROR IS HERE
        log("row updated");
        requestStmt.close();
        requestStmt = null;
 
        log("committing");
        conn.commit();
        log("committed");
        
      } catch (Exception ex) {
        ex.printStackTrace();
      }

Baffled,
Terry Luedtke

[Kevin Mukhar]

  
        PreparedStatement requestStmt = conn.prepareStatement(
                "SELECT remaining "
              + "FROM requests "
              + "WHERE id = ? "
              + "FOR UPDATE ",
              ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE
              );

Very strange message indeed. The error message appears to have nothing to do with (what I think is) the problem. According to Oracles documentation ( http://download-west.oracle.com/docs/cd/A97630_01/java.920/a96654/resltset.htm#101813, scroll down to "FOR UPDATE Clause Limitation in an Updatable Result Set"), you can't use a FOR UPDATE clause with an updatable result set. The documentation also lists some other limitations, but I don't think you are violating any of them.
[ December 12, 2002: Message edited by: Kevin Mukhar ]

[Terry Luedtke]

Thanks Kevin,
Removing the "For Update" fixed it. I'm learning to take Oracle errors with a grain of salt. When I was working with Perl's DBD library (a wrapper around Oracle's OCI drivers), I got an error stating: "You must install a Solaris patch to run this version of the Java runtime". The real problem was that I'd forgotten to add the Oracle library path to LD_LIBRARY_PATH. How that relates to a Java runtime, I have no idea.
Thanks,
Terry