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

Ads
 

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

Hi

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

Addfile.jsp

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

<HTML>

    <BODY bgcolor="#99CCCC">
        <p>&nbsp;</p>

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

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


    </BODY>
</HTML>

UploadFile.jsp

[code]
<%@ page import="java.sql.*" %>
<%@ page import="java.io.IOException" %>
<%@ page import="java.io.PrintWriter" %>
<%@ 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" %>

<HTML>

    <BODY bgcolor="#99CCCC">
        <p>&nbsp;</p>

<br>

<%
        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");
                return;
            }

            // 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
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "hr", "hr");
            con.setAutoCommit(false);

            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());
            ps.executeUpdate();
            con.commit();
            con.close();
            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

Ads









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
Advertisements
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?
oracle database backup using jsp
how to upload multiple files in jsp and saving the path in database and the file in folder
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 browse excel file and stored the contents into the database using jsp/servlet?
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
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
how to upload and download images using buttons in jsp?
How to upload files to server using JSP/Servlet?
fetch record from oracle database using jsp-servlet?
Upload and display image and text records using JSP and Oracle
Upload csv or .xlsx file from JSP form to Database Table using servlet
upload a file and write it in JSP using servlet
how to upload file using FTP in java
jsp upload file to server
upload file and insert other details to database using a single form
Unable to upload a file to mysql database using struts1
insert name city and upload image in database using mysql and jsp
Retrieve database from the table dynamically in jsp from oracle using servlet

Ads