Store file in access

[visu Nekk]

package Test;
 
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import org.apache.commons.fileupload.*;
import java.util.Iterator;
import java.util.List;
 
 
public class Sample1 extends HttpServlet
{
 
   public void service(HttpServletRequest req,HttpServletResponse res)
         throws ServletException,IOException
     {
       PrintWriter out = res.getWriter();
       
       try
       {
         boolean isMultipart = FileUpload.isMultipartContent(req);
 
         DiskFileUpload upload = new DiskFileUpload();
 
         List items = upload.parseRequest(req);
 
         Iterator iter = items.iterator();
 
         while (iter.hasNext())
         {
           FileItem item = (FileItem) iter.next();
 
           if (item.isFormField())
           {
             String name = item.getFieldName();
             System.out.println("Field Name : " + name);
             String value = item.getString();
             System.out.println("Field Value : " + value);
           }
           else if (!item.isFormField())
           {
             String fieldName = item.getFieldName();
             System.out.println("fieldName : " + fieldName);
             String fileName = item.getName();
             System.out.println("fileName : " + fileName);
             String contentType = item.getContentType();
             System.out.println("Content Type : " + contentType);
             boolean isInMemory = item.isInMemory();
             System.out.println("In memory : " + isInMemory);
             long sizeInBytes = item.getSize();
             System.out.println("Size : " + sizeInBytes);
           }
           
           File uploadedFile = new File("c:\\resumes");
           item.write(uploadedFile);
           // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           // Connection con = DriverManager.getConnection("jdbc  :-o	  dbc:Rd","Admin","");
           // Statement stmt = con.createStatement();
           // stmt.executeUpdate("insert into Table4 values('"+value+"','"+uploaded+"')");
     
             //InputStream uploaded = item.getInputStream();         
         }
         
 
       }catch(Exception e)
       {
         out.println(e);
       }
      }
}     

using the above code i could read the file.Now can anyone guide me to store it in access or oracle database.Thanx in advance.

[added code tags]
[ September 21, 2005: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Visu,
You have the right idea with the commented out part. Good start!

I think you need to use a PreparedStatement since you are inserting a BLOB. It seems tough to represent a file in a SQL query. You can pass a byte[] or ByteArrayInputStream to the prepared statement.

[visu Nekk]

hi Jeanne,

i have tried out with prepared statement but the microsoft access driver does'nt support prepared statement.can u help me anyother way out?

[Jeanne Boyarsky]

Visu,
Please don't post duplicate threads about the same question. Continue conversation in your other thread.

Thanks,
Jeanne
JDBC Forum Bartender