Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Unanswered: Error! - oracle.jdbc.driver.OracleSQLException: ORA-01410: invalid ROWID

    Hmmm. Don't really know whats going on here.

    I have a java program cycling though records in a table as follows;
    Code:
    resultSet = sel.executeQuery("SELECT rowid FROM " + final_table + " WHERE cba_granule=" + x);
    while (!resultSet.isLast())
    {
     //Assign a CBA_RECORD number to the entry.
     resultSet.next();
     s = sel.executeUpdate("UPDATE "+final_table+" SET cba_record = "+temp+" WHERE rowid='"+resultSet.getString(1)+"'");
     temp++;
    }
    connection.commit();
    Any ideas why this doesn't work; could it be i need to lock the rows/row that i'am using?

    Any ideas would be appreaciated!

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Also:

    If i println the row id i get this; (which doesn't look like a row id)
    414141486B6F41414A414141717236414236

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •