Results 1 to 3 of 3
Thread: File upload error
- 08-19-2008, 06:24 AM #1
Member
- Join Date
- Aug 2008
- Posts
- 2
- Rep Power
- 0
File upload error
Dear all,
I'm trying to upload a file to database, i uploaded a image size is lessthan 4 kb using blb,
when I try with a image or file morethan 4kb, i'm getting an error:
ORA-01460: unimplemented or unreasonable conversion requested
i added my java code below,
package Action;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Blob;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.upload.FormFile;
import org.apache.struts.upload.MultipartRequestHandler;
import Form.StrutsUploadForm;
/**
* @author jegadeeswaran
*
*/
public class StrutsUploadAction extends Action {
Connection conn = null;
ResultSet rset = null;
int s=0;
public ActionForward execute
(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception{
StrutsUploadForm myForm = (StrutsUploadForm)form;
FormFile myFile = myForm.getTheFile();
String contentType = myFile.getContentType();
System.out.println(">> contentType: >> " +contentType);
String fileName = myFile.getFileName();
System.out.println(">> File Name: >> " +fileName);
int fileSize = myFile.getFileSize();
System.out.println(">> File Size: >> " +fileSize);
byte[] fileData = myFile.getFileData();
System.out.println(">> file data: >> " +fileData);
InputStream inFile = myFile.getInputStream();
Class.forName("oracle.jdbc.driver.OracleDriver");
conn =DriverManager.getConnection("jdbc:oracle:thin:@de vdbserver.edkaladc.com:1521:EDKADCDB","jegadeeswar an","jeg");
System.out.println("connection >> "+conn);
PreparedStatement pstmt = conn.prepareStatement("insert into ABSFILEUPLOAD (filename,upfile) values(?,?)");
// conn.prepareCall("{call package.functionname(?,?)}");
System.out.println("prepared statement >> "+pstmt);
pstmt.setString(1,fileName);
pstmt.setBinaryStream(2,inFile,fileSize);
s = pstmt.executeUpdate();
System.out.println("quert execute resultset >> "+s);
pstmt.close();
System.out.println("Insertion successfull");
return mapping.findForward("success");
}
}
note:
1.i have given the buffer size in the controller
2.i added ojdbc jar alsoLast edited by jegadeeshsp; 08-19-2008 at 06:34 AM.
- 08-19-2008, 02:02 PM #2
Is that a Database error message? It doesn't look like a java error message.
- 08-20-2008, 05:13 AM #3
Member
- Join Date
- Aug 2008
- Posts
- 2
- Rep Power
- 0
File upload in struts
Similar Threads
-
how to upload a file?
By tommy in forum JavaServer Pages (JSP) and JSTLReplies: 4Last Post: 06-30-2008, 02:50 PM -
file upload
By sundarjothi in forum JavaServer Pages (JSP) and JSTLReplies: 1Last Post: 06-27-2008, 11:52 AM -
file upload in java
By muralikrishna in forum New To JavaReplies: 6Last Post: 06-25-2008, 08:24 AM -
File Upload
By ShoeNinja in forum JavaServer Pages (JSP) and JSTLReplies: 0Last Post: 11-09-2007, 10:09 PM -
how to upload a file using servlet
By simon in forum Java ServletReplies: 1Last Post: 08-05-2007, 03:50 AM


LinkBack URL
About LinkBacks
Reply With Quote

Bookmarks