Problems with file upload

[sovan chatt]

 
#   import java.sql.*;  
# import java.io.*;  
# import javax.servlet.*;  
# import javax.servlet.http.*;  
# import java.util.*;  
# import org.apache.commons.fileupload.servlet.ServletFileUpload;  
# import org.apache.commons.fileupload.disk.DiskFileItemFactory;  
# import org.apache.commons.fileupload.*;  
#   
# public class testServlet extends  HttpServlet{  
#     @Override  
#   public void doPost(HttpServletRequest request, HttpServletResponse response)  
#     throws ServletException, IOException{  
#     PrintWriter pw = response.getWriter();  
#     String n="";String v="";  
#     boolean isMultipart = ServletFileUpload.isMultipartContent(request);  
#         if (!isMultipart) {  
#             System.out.println("File Not Uploaded");  
#         } else {  
#             FileItemFactory factory = new DiskFileItemFactory();  
#             ServletFileUpload upload = new ServletFileUpload(factory);  
#             List items = null;  
#   
#             try {  
#                 items = upload.parseRequest(request);  
#             } catch (FileUploadException e) {  
#             }  
#   
#             Iterator itr = items.iterator();  
#             while (itr.hasNext()) {  
#                 FileItem item = (FileItem) itr.next();  
#                 if (item.isFormField()){  
#                                  n=item.getFieldName();  
#                                  if(n.equalsIgnoreCase("fid")){  
#                                  v=item.getString();  
#                              
#                                 }  
#                             }  
#                                else{  
#                                  String itemName = item.getName();  
#                         try{  
#                             Connection con=DbCon.setCon();  
#                             
#                              File file=new File(itemName);  
#                              FileInputStream is = new FileInputStream(file);  
#                              PreparedStatement ps = con.prepareStatement("INSERT INTO test VALUES(?,?)");  
#                         
#                              ps.setString(1,v);  
#                                ps.setBinaryStream(2,is,is.available());  
#                         
#                                ps.executeUpdate();  
#                          
#                                  
#                               }  
#                   catch (Exception e){  
#                           System.out.println(e);  
#                            }  
#          }  
#         }  
#       }  
#     }  
# }   

When I run this code I get the following error messge java.sql.SQLException: Io exception: Connection reset by peer: socket write error.and when I try to retrieve the blob object I get a Nullpointer Exception.

[David Newton]

So it's not really a file upload problem, but a DB issue?

[sovan chatt]

@David Newton Yes ..that might be the case but what should I do?

[Paul Sturrock]

Connection reset by peer

This usually means the server itself has deliberately dropped the connection. What database are you using?

[Deepak Kumar Jena]

@Sovan, What I think is you are trying to upload a file of larger size and your system is unable to keep a connection open long enough to upload the file successfully, try with small size files. While retrieving the BLOB object you are getting the NullPointerException, because you are trying to retrieve an object which does not exists (As the file is failing to upload in your case).

[Paul Sturrock]

If this were the case I would expect the error to report a transaction time out. It should be easy to confirm by checking the database logs.

[sovan chatt]

@Deepak Kumar Jena,@Paul Sturrock...I am using Oracle 9i...I tried to upload files of around 350Kb and still its not working...What should I do?

[Paul Sturrock]

OK, what data type are you using to store the binary content and which driver version are you using?

[sovan chatt]

@Paul Sturrock I am using 'blob' object to store binary data and Oracle thin type 4 driver...

[Paul Sturrock]

What version of driver (not type)? Oracle's 9i drivers were less than perfect - from memory (though this may only apply to LONG RAW data types) you needed to be careful what order you bound binary content variables.

If you are not already doing this, try swapping to the latest 11g driver.

[Rene Larsen]

And maybe store the Blob in the right way, by using empty_blob()

Look at the sample code here: http://www.idevelopment.info/data/Oracle/DBA_tips/LOBs/LOBS_12.shtml

Methods in the samples of interest are: writeBLOBPut() or writeBLOBStream()