Aargh! - bad link because of stupid frames! Try this one instead: http://technet.oracle.com/doc/oracle8i_816/java.816/a81354/resltse2.htm#1018 228 -----Original Message----- From: Hung Yee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:28 PM To: [EMAIL PROTECTED] Subject: Re: Invalid operation for read only resultset It's because of your select statement "SELECT * FROM UPLOAD .... This is a known limitation of Oracle's JDBC 2.0 drivers when implementing an updatable ResultSet. Because the driver couldn't do this operation, it automatically downgraded your ResultSet to be CONCUR_READONLY See the Oracle TechNet article below: http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm You have to register to use the 'Oracle Technology Network' but it's free and it does have a lot of useful information about Oracle's DBs and drivers. According to this article, the work around is to use table aliases. So try changing your select statement to say this: SELECT t.* FROM UPLOAD t where FILE_NAME = 'bbbb'"); See if this works. -----Original Message----- From: fau k [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 12:54 PM To: [EMAIL PROTECTED] Subject: Invalid operation for read only resultset Hi, I am getting an error like.... Invalid operation for read only resultset Here is the code.. Driver DriverRecordset = (Driver)Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); Connection con = DriverManager.getConnection("xyz.."); Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE); ResultSet rs = stmt.executeQuery("SELECT * FROM UPLOAD where FILE_NAME = 'bbbb'"); // if the resultset is not null if (rs.next()){ // Initialization mySmartUpload.initialize(pageContext); // Upload mySmartUpload.upload(); // upload file in the DB if this file is not missing if (!mySmartUpload.getFiles().getFile(0).isMissing()){ try { //here I am getting error.. like An error occurs : //java.sql.SQLException: Invalid operation for read only resultset: rs.updateString("FILE_NAME", mySmartUpload.getFiles().getFile(0).getFileName()); // Add the current file in the DB field mySmartUpload.getFiles().getFile(0).fileToField(rs,"ATTACHMENT"); // Update rs.updateRow(); count++; } catch(Exception e) { out.println("An error occurs : " + e.toString()); } } } Please help me in this, I will thankfull to u.. Thanks, Malla Reddy [EMAIL PROTECTED] _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
