My classpath is .;C:\Estimation;C:\Tomcat\common\lib\servlet.jar;C:\Tomcat\common\lib\mail.jar;C:\Tomcat\common\lib\activation.jar;C:\Tomcat\common\lib\jndi.jar;C:\Tomcat\common\lib\classes12.jar;C:\Tomcat\common\lib\commons-collections-3.0.jar;C:\Tomcat\common\lib\commons-dbcp-1.1.jar;C:\Tomcat\common\lib\commons-pool-1.1.jar;C:\Tomcat\common\lib\jdbc2_0-stdext.jar;C:\Tomcat\common\lib\ojdbc14.jar;C:\Tomcat\common\lib\classes111.jar;C:\Tomcat\common\lib\ocrs12.jar;
Best Regards Abhay Kumar -----Original Message----- From: Mike Curwen [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 1:59 PM To: 'Tomcat Users List' Subject: RE: [OT] getBlob() error in Tomcat The javadoc for that error suggests: "this error can only occur at run time if the definition of some class has incompatibly changed since the currently executing method was last compiled." So is the version of classes12.jar that you used to compile the code, the exact same version that is being used to run it ? As for casting...... OracleResultSetClass foo = (OracleResultSetClass)result; obviously, you'd need to replace 'OracleResultSetClass' with the actual name of the class. > -----Original Message----- > From: Kumar Abhay-CAK203C [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 1:43 PM > To: 'Tomcat Users List' > Subject: RE: [OT] getBlob() error in Tomcat > Importance: High > > > I will appreciate you if you can tell me how ? > > Best Regards > Abhay Kumar > > -----Original Message----- > From: Summers, Bert W. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 1:05 PM > To: Tomcat Users List > Subject: RE: [OT] getBlob() error in Tomcat > > > You need to cast the ResultSet to the Oracle specify ResultSet > > -----Original Message----- > From: Kumar Abhay-CAK203C [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 11:01 AM > To: Tomcat Users List > Subject: [OT] getBlob() error in Tomcat > Importance: High > > > Hi, > > Any idea why this error is coming in runtime? > > Servlet) - FileDisplayServlet.doPost() > java.lang.AbstractMethodError: > oracle.jdbc.driver.OracleResultSetImpl.getBlob(Ljava/lang/Stri > ng;)Ljava/sql/ > Blob; > at > org.apache.commons.dbcp.DelegatingResultSet.getBlob(Delegating > ResultSet.java > :318) > at > com.mot.iDEN.webapp.oes.servlet.FileDisplayServlet.readBlob(Fi > leDisplayServl > et.java:169) > > I am trying to display a image that is stored in a BLOB field > in Oracle. I am using connection pooling and classes12.jar > > Servlet Code > -------------------------------------------------------------- > -------------- > -------------------------------------------------------------- > -------------- > -------- > private void readBlob > ( > HttpServletRequest request, > HttpServletResponse response, > long aFeatureId, > String aFileName, > String aUserId > ) > throws SQLException,IOException > { > Connection conn = null; > ResultSet result = null; > PreparedStatement prepStmt = null; > java.io.InputStream in = null; > java.sql.Blob myBlob = null; > FileUploadFactory uploadFactory = new > FileUploadFactory(); > > try > { > conn = config_.getEstimationConnection(false); > String sql = ""; > sql = > " SELECT "+ > " FILE_IMAGE "+ > " FROM "+ > " OES_FEATURE_DETAILS "+ > " WHERE "+ > " FEATURE_ID = > "+aFeatureId; > > log_.debug("SQL:==="+sql); > log_.debug("result=" + result); > prepStmt = conn.prepareStatement(sql); > result = prepStmt.executeQuery(); > if (result != null && result.next()) > { > //get the file ext > String strDocExt = ""; > try > { > strDocExt = > uploadFactory.getFileType(aFileName, aUserId); > } > catch(Exception e) > { > log_.debug("Exception is"+e); > } > //get the file length > int intCountBytes = 0; > String strPrpValue = null; > //set the mimetype > ResourceBundle mimetype = > ResourceBundle.getBundle("mimes"); > strPrpValue = > mimetype.getString(strDocExt.toLowerCase()); > log_.debug("Value=" + strPrpValue); > if (strPrpValue != null) > { > > response.setContentType(strPrpValue); > > response.setHeader("Content-Disposition", "inline; filename=" > + aFileName); > } > myBlob = result.getBlob("FILE_IMAGE"); > //get the inputStream > in = myBlob.getBinaryStream(); > /*Get the Output Stream*/ > if (in != null) > { > > generatePresentation(in, response); > in.close(); > } > } > } > catch (SQLException sqle) > { > throw new > SQLException("FileDisplayServlet.readBlob", "" + sqle.getErrorCode()); > } > catch (IOException io) > { > throw new > IOException("FileDisplayServlet.readBlob"); > } > finally > { > try > { > if (result != null) > { > result.close(); > } > if (prepStmt != null) > { > prepStmt.close(); > } > if (conn != null) > { > conn.close(); > } > } > catch (SQLException sqle) > { > throw new > SQLException("FileDisplayServlet.readBlob"); > } > } > } > -------------------------------------------------------------- > -------------- > -------------------------------------------------------------- > -------------- > ---- > > Best Regards > Abhay Kumar > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
