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?
how to upload multiple files in jsp and saving the path in database and the file in folder
oracle database backup using jsp
how do i upload a file by using servlet or jsp?
how to generate reports from oracle database using jsp and ajax code
file upload using JSP
How to get data from Oracle database using JSP
How to browse and upload the file in same page 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 excel file and stored the contents into the database using jsp/servlet?
Image upload in mysql database using jsp servlet
file upload and insert name into database - JSP-Servlet
Upload and display image and text records using JSP and Oracle
how to save images in oracle using JSP
how to save images in oracle using JSP
How to upload files to server using JSP/Servlet?
how to upload and download images using buttons in 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?
To Upload and insert the file into Database with Current Date and Time In JSP
Unable to upload a file to mysql database using struts1
how to upload file using FTP in java
how to upload a file - JSP-Servlet
Upload csv or .xlsx file from JSP form to Database Table using servlet
File insertion into oracle database
jsp upload file to server

Ads