Forum:

How to Upload a file to oracle database using JSP or Servlets

Ranch Hand

Posts: 47

posted 13 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I want to uplaod a file(csv or excel) to Oracle 10g database, using Jsp or Servlets....

Addfile.jsp

UploadFile.jsp

<%@ 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>

<%
        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", "log", "log");
            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...Its not uploading the file, it is giving me Error--> Index 1, size 1. Please help me ..how to do this. I am trying to upload a csv file to oracle db from jsp page, csv file has two fields PartNo and SerialNo. The Oracle table InventoryDB_main has 23 columns including PartNo, SerialNo. Please can anyone help me how to upload a file to oracle database.

Thanks in advance
Lissy.

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 13 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Step 1: get the code out of a JSP and into a servlet. Then we can discuss step 2.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Paul Clapham

Marshal

Posts: 28296

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You don't know what line of code threw that exception, do you? In your catch block you should print the whole stack trace, like this:

Only since the code is in a JSP, the line numbers in the stack trace which you get won't match the line numbers in the JSP, because the JSP is compiled into something else where the line numbers are different. So as Bear said... put the code into a servlet.

Java 8 (verified skill)
Skill verified by Paul Clapham

lisy jessica

Ranch Hand

Posts: 47

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks for the reply. Will try this.

Sanjeev P Kulkarni

Greenhorn

Posts: 20

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

lisy jessica wrote:Thanks for the reply. Will try this.

http://www.roseindia.net/jsp/file_upload/uploadingMultipleFiles.shtml

Try this link if you want full explanation along with the code.

Sanjeev

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 13 years ago

2
Number of slices to send:

Optional 'thank-you' note:

Send

Do not use the code of that link. It irresponsibly puts code in a JSP just like we have been advising not to. The roseindia site should be avoided as its examples rarely exhibit proper practices and good coding.

[Asking smart questions] [About Bear] [Books by Bear]

Drove my Chevy to the levee but the levee was dry. A wrung this tiny ad and it was still dry.

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser