How to Upload a file directly to Oracle database using JSP or Servlets?


How to Upload a file directly to Oracle database using JSP or Servlets?


I want to upload a file(csv or excel) to Oracle 10g Database using JSP, here is my code which gives me an error..


<%@ page import="java.sql.*" %>


    <BODY bgcolor="#99CCCC">

        <h2 align="center">Upload File to Oracle Database</h2>
        <form id="form1" enctype="multipart/form-data" action="UploadFile.jsp" method="post">
            <table align="center">

                    <td>Browse File  </td>
                    <td><input align="center" type="file"  name="csvfile" />
            <center><input align="center" type="submit" value="Upload File"/></center>



<%@ page import="java.sql.*" %>
<%@ page import="" %>
<%@ page import="" %>
<%@ page import="java.util.List" %>
<%@ page import="javax.servlet.ServletException" %>
<%@ page import="javax.servlet.http.HttpServlet" %>
<%@ page import="javax.servlet.http.HttpServletRequest" %>
<%@ page import="javax.servlet.http.HttpServletResponse" %>
<%@ page import="org.apache.commons.fileupload.FileItem" %>
<%@ page import="org.apache.commons.fileupload.disk.DiskFileItemFactory" %>
<%@ page import="org.apache.commons.fileupload.servlet.ServletFileUpload" %>


    <BODY bgcolor="#99CCCC">


        try {
            // Apache Commons-Fileupload library classes
            DiskFileItemFactory factory = new DiskFileItemFactory();
            ServletFileUpload sfu  = new ServletFileUpload(factory);

            if (! ServletFileUpload.isMultipartContent(request)) {
                System.out.println("sorry. No file uploaded");

            // parse request
            List items = sfu.parseRequest(request);
            FileItem  PartNo = (FileItem) items.get(0);
            String photoid =  PartNo.getString();

            FileItem SerialNo = (FileItem) items.get(1);
            String phototitle = SerialNo.getString();

            // get uploaded file
            FileItem file = (FileItem) items.get(2);

            // Connect to Oracle
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "hr", "hr");

            PreparedStatement ps = con.prepareStatement("insert into InventoryDB_Main(PartNo,SerialNo) values(?,?)");
            ps.setString(1, photoid);
            ps.setString(2, phototitle);
            // size must be converted to int otherwise it results in error
            ps.setBinaryStream(3, file.getInputStream(), (int) file.getSize());
            out.println("File Uploaded Successfully.");
        catch(Exception ex) {
            out.println( "Error --> " + ex.getMessage());


This is my code which is not working it throws error, index 1, size 1.

Please help me. I want to upload a file to Oracle 10g table directly. Help needed urgently.

Thanks in advance Lissy.

View Answers


Related Tutorials/Questions & Answers:
How to Upload a file directly to Oracle database using JSP or Servlets?
How I Upload File and Store that file name in Database using JSP
How i upload file and save that record in database using JSP?
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
How to upload file using JSP?
how to upload multiple files in jsp and saving the path in database and the file in folder
oracle database backup using jsp
how to generate reports from oracle database using jsp and ajax code
how do i upload a file by using servlet or jsp?
How to get data from Oracle database using JSP
file upload using JSP
How to browse and upload the file in same page using jsp.
how to upload an image from a jsp page to a mysql database table using jsp
How to browse and upload the file in same page using jsp.
How to browse excel file and stored the contents into the database using jsp/servlet?
Image upload in mysql database using jsp servlet
how to save images in oracle using JSP
how to save images in oracle using JSP
How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end
fetch record from oracle database using jsp-servlet?
how to upload and download images using buttons in jsp?
How to upload files to server using JSP/Servlet?
Upload and display image and text records using JSP and Oracle
To Upload and insert the file into Database with Current Date and Time In JSP
Upload csv or .xlsx file from JSP form to Database Table using servlet
upload a file and write it in JSP using servlet
jsp upload file to server
how to upload file using FTP in java
Unable to upload a file to mysql database using struts1
upload file and insert other details to database using a single form
insert name city and upload image in database using mysql and jsp