Hi, Thanks for your kind response.. Thanks very much.. but I am getting another error.. like java.sql.SQLException: Internal Error: Unable to construct a Datum from the specified input I am working on uplad and downlad by using jspsmartuplod api.. Please help me in this regard. Thanks, Malla REddy Thanks, Malla Reddy >From: Hung Yee <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and > reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Invalid operation for read only resultset >Date: Tue, 9 Jan 2001 15:06:33 -0800 > >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 _________________________________________________________________ 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
