Insert image from user using and save in database

when i am trying to upload a image from user and trying to save into oracle9i database it will always give this error...... if any one know the solution...please tell me how to remove that HTTP Status 500 -

type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling this request.

exception 

org.apache.jasper.JasperException: An exception occurred processing JSP page /upload.jsp at line 27

24:     String file = new String(dataBytes);
25:     String saveFile = file.substring(file.indexOf("filename=\"") + 10);
26:     System.out.println("saveFile=" + saveFile);
27:     saveFile = saveFile.substring(saveFile.lastIndexOf("\\")+ 1,saveFile.indexOf("\""));
28:     System.out.println("saveFile" + saveFile);
29:     saveFile = file.substring(file.indexOf("filename=\"") + 10);
30:         saveFile = saveFile.substring(0, saveFile.indexOf("\n"));


Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


root cause 

java.lang.StringIndexOutOfBoundsException: String index out of range: -28161
    java.lang.String.substring(Unknown Source)
    org.apache.jsp.upload_jsp._jspService(upload_jsp.java:80)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.

Apache Tomcat/6.0.29

View Answers

April 25, 2011 at 11:28 AM

We have used MySQl database.

1)page.jsp:

<%@ page language="java" %>
<HTML>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD>
<BODY> <FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
<br><br><br>
<center>
<table border="0" bgcolor=#ccFDDEE>
<tr>
<center>
<td colspan="2" align="center"><B>UPLOAD THE FILE</B><center></td>
</tr>
<tr>
<td colspan="2" align="center">�</td>
</tr>
<tr>
<td><b>Choose the file To Upload:</b></td>
<td><INPUT NAME="file" TYPE="file"></td>
</tr>
<tr>
<td colspan="2" align="center">�</td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Send File"> </td>
</tr>
<table>
</center>
</FORM>
</BODY>
</HTML>

2)uoload.jsp:

<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.zip.*"%>
<%
String saveFile="";
String contentType = request.getContentType();
if((contentType != null)&&(contentType.indexOf("multipart/form-data") >= 0)){
DataInputStream in = new DataInputStream(request.getInputStream());
int formDataLength = request.getContentLength();
byte dataBytes[] = new byte[formDataLength];
int byteRead = 0;
int totalBytesRead = 0;
while(totalBytesRead < formDataLength){
byteRead = in.read(dataBytes, totalBytesRead,formDataLength);
totalBytesRead += byteRead;
}
String file = new String(dataBytes);
saveFile = file.substring(file.indexOf("filename=\"") + 10);
saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1,saveFile.indexOf("\""));
int lastIndex = contentType.lastIndexOf("=");
String boundary = contentType.substring(lastIndex + 1,contentType.length());
int pos;
pos = file.indexOf("filename=\"");
pos = file.indexOf("\n", pos) + 1;
pos = file.indexOf("\n", pos) + 1;
pos = file.indexOf("\n", pos) + 1;
int boundaryLocation = file.indexOf(boundary, pos) - 4;
int startPos = ((file.substring(0, pos)).getBytes()).length;
int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
File ff = new File(saveFile);
FileOutputStream fileOut = new FileOutputStream(ff);
fileOut.write(dataBytes, startPos, (endPos - startPos));
fileOut.flush();
fileOut.close();
%><Br><table border="2"><tr><td><b>You have successfully upload the file:</b>
<%out.println(saveFile);%></td></tr></table>
<%
Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/test";
ResultSet rs = null;
PreparedStatement psmnt = null;
FileInputStream fis;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
File f = new File(saveFile);
psmnt = connection.prepareStatement("insert into file(file_data) values(?)");
fis = new FileInputStream(f);
psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
int s = psmnt.executeUpdate();
if(s>0){
System.out.println("Uploaded successfully !");
}
else{
System.out.println("Error!");
}
}
catch(Exception e){e.printStackTrace();}
}
%>

3)For oracle database, use BLOB datatype for image.

January 17, 2012 at 8:20 AM

dear sir or madam, i wont to How to Store Image Into The Database Using netbeans

Advertisements

how to save uploaded image in database using javascript
how to save uploaded image in database using javascript Please can you tell me how to store uploaded image in database using java I'll use...; Now i want to store it on database...ADS_TO_REPLACE_1 Please help me Thanks

insert and retrive image from sql server database in jsp
insert and retrive image from sql server database in jsp what is the code to insert and retrive an image from sql server database in jsp

how to insert and retrieve an image from mysql using java - Java Beginners
how to insert and retrieve an image from mysql using java how to insert and retrieve an image from mysql using java? Hi friend, Code to insert image using java : import java.sql.*; import java.io.*; class

insert name city and upload image in database using mysql and jsp
insert name city and upload image in database using mysql and jsp insert name city and upload image in database using mysql and jsp

Upload Image and save in database using jsp-servlet mvc
Upload Image and save in database using jsp-servlet mvc Here is my...;/TD> <td><input type="file" name="Image" size="20" value=""><..." name="Image" size="20" value=""></TD> </tr> <tr> <

Upload Image and save in database using jsp-servlet mvc
Upload Image and save in database using jsp-servlet mvc Here is my... = connection.prepareStatement("insert into uploadimage(image,image_name,image_length...;/TD> <td><input type="file" name="Image" size="20" value="">

insert name city image in database using mysql and jsp
insert name city image in database using mysql and jsp how to insert name ,city and image in database in mysql and jsp Here is an example in jsp that insert name, city and image to database. <%@ page import

Insert image in database
Insert image in database Want a jsp-struts program in which the imageFile is in the form of getter and setter and inserted in the database as a Blob using . and then download the image and show on next jsp pg. No use

<img src=""> using retrieve image from database using jsp
using retrieve image from database using jsp how to <img src="" > tag using retrieve image from database and display in jsp

insert image using hibernate
insert image using hibernate Sir, Today I hadposted question regarding upload image, th answer you had given is using SQL, but I am using Hibernate to insert data in the same table where I want to insert image. Plz hlp me

Insert Image into Database Using Servlet
the image from database using Servlet. After retrieving the image from database...Insert Image into Database Using Servlet �... image into database table using Servlet. This type of program is useful in social

Insert Image into Database Using Servlet
to retrieve the image from database using Servlet. After retrieving the image from... Insert Image into Database Using Servlet �... of inserting image into database table using Servlet. This type of program is useful

How to insert and retreive an image in mysql database using spring mvc framework???
How to insert and retreive an image in mysql database using spring mvc framework??? I ve solved this problem based on the Product Search Application. Those who need this concept and code segment kindly copy it. Thanks and All

How to store user name,city,state,image path into database and image into folder using jsp
How to store user name,city,state,image path into database and image into folder using jsp How to store user name,city,state,image path into database and image into folder using jsp

how to insert data from database using oops concepts - Development process
how to insert data from database using oops concepts Hi, How to insert data from database using oops based concepts.please write the code... the following code: import java.sql.*; class Insert{ public static String url

How to insert data from textfields into database using hibernate?
How to insert data from textfields into database using hibernate? try{ Session session = HibernateUtil.getSessionFactory().openSession...); System.out.println("Successfully data insert in database"); tx.commit

retrive image from database using jsp without stream
retrive image from database using jsp without stream How to retrive image from database using jsp without stream like (inputStream

How to display image in jsp from database using Servlet?
How to display image in jsp from database using Servlet? Hi, How to display image in jsp from database using Servlet? Thanks Hi, You will find code and example program at Retrieve image from database using Servlet

How to retrieve image from database using jsp and servlet?
How to retrieve image from database using jsp and servlet? Hi, I am trying to find code for displaying the image from database in a JSP page. How to retrieve image from database using jsp and servlet

User Registration Form Using JSP(JspBeans) after that how i can insert in database
User Registration Form Using JSP(JspBeans) after that how i can insert in database User Registration Form Using JSP(JspBeans) after that how i can insert in database

Retrieve image from database using servlet and display in JSP
Retrieve image from database using servlet and display in JSP Hi, I am total new to JSP although I am learning it for the last few days. Now I want to use MySQL Database from JSP page. How to retrieve image from database using

retrive the employee details with image from mysql database using jsp servlet
retrive the employee details with image from mysql database using jsp servlet im doing the web project to retrive the employee profile which i stored in the database using jsp servlet then want to show the result in the next jsp

Fetching image from database
Fetching image from database I have uploaded image path and image name in database so, now how can i display that image using JSP or HTML page(is it possible to display using tag using concatination). image path i have stored

save the uploading image with user specified name
save the uploading image with user specified name My form consists of a textbox and an upload image with submit button.When i submit the form I want to save the uploaded image in a folder with user specfied name

insert user session into other oracle database table
insert user session into other oracle database table hello i am... comments then how i can retrive his user id using session and store id into comments table. with user id i also want to insert date and current time in to database

Image name,image path into database and image into folder using jsp
Image name,image path into database and image into folder using jsp How to insert image path and image name into oracle database and image into folder using jsp

insert date into database using jsf
insert date into database using jsf Hello I need a simple example of source code to insert a date into a database using jsf what do I have to put in backing bean and page jsf ( i need juste a date ) thanks

how to insert the physical path of an image in database - JDBC
how to insert the physical path of an image in database hello I m working in a project where we have to capture an image using web cam. when... , the image column is of varchar datatype.. plz can you tell me how to insert image's

Save profile and image to mysql database, and view the image in another jsp page
Save profile and image to mysql database, and view the image in another jsp page Pls. need help in saving the profile info with the image in mysql database.. some basic code pls in jsp... thanks in advance

How to store and retrieve image from database in JSP?
the image. Check this example: Retrieve image from database using Servlet. Thanks...How to store and retrieve image from database in JSP? Hi, In one... and retrieve image from database in JSP? Thanks HI, You can use

Retrieve image from database using Servlet
Retrieve image from database using Servlet �... that connects to the MySQL database and retrieves the image from the table. After... applications that retrieves the image from database. You can use this type

i want to save image on server folder. and i want to save URL of this folder and name of image in database
i want to save image on server folder. and i want to save URL of this folder and name of image in database hi i want to save image on server folder. and i want to save URL of this folder and name of image in database.on click

how to upload an image from a jsp page to a mysql database table using jsp
how to upload an image from a jsp page to a mysql database table using jsp how to upload an image from a jsp page to a mysql database table using jspstrong text

how to retrieve image from mysql database using java and show it in HTML img tag ?
how to retrieve image from mysql database using java and show it in HTML img tag ? how to retrieve image from mysql database using java and show it in HTML img tag

Insert or retrieve image into oracle 10g by using java
Insert or retrieve image into oracle 10g by using java How can i insert or retrieve image into oracle10g using java plz i need it urgently,need guidance to do this plz

how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database using jsp or oracle??? sir.. i have number of excel sheets which... be inserted into oracle database.. please help me sir... hi friend

Retrieving images from the oracle database using jsp and create that rretrieved image as hyperlink
Retrieving images from the oracle database using jsp and create that rretrieved image as hyperlink I want to insert images into oracle database.I want to retrieve images using jsp and I want to display on the browser.The

insert data in the database using checkbox
insert data in the database using checkbox i am fetching data from the database using servlet on the jsp page and there is checkbox corresponding... should i insert only checked data into database on submission. We

Insert Image into Mysql Database through Simple Java Code
Insert Image into Mysql Database through Simple Java Code... simple java code that how save image into mysql database. Before running this java code you need to create data base and table to save image in same database

How to save database data into excelsheet using hibernate
How to save database data into excelsheet using hibernate How to save database data into excelsheet using hibernate

code for insert the value from jsp to access database
code for insert the value from jsp to access database code for insert the value from jsp to access database

store and retrive image from the database
to store and retreive images from sql database using sql commands -how to store and retreive images from sql database using asp.net/c# thanks in advance...store and retrive image from the database please provide me

insert rows from browsed file to sql database
insert rows from browsed file to sql database i need to insert rows from excel to database by browsing the file in jsp. by connecting both..., content of the file has to go to database. how can i insert record into database

Insert Blob(Image) in Mysql table using JSP
Insert Blob(Image) in Mysql table using JSP In this Section, we will insert blob data(image) in Mysql database table using JSP code. A Blob stores a binary...=con.prepareStatement("insert into inimage(name,city,image)"+"

insert values from excel file into database
the following link: Insert values from excel file to database...insert values from excel file into database hi i want to insert... file that should go to database which exists. am using SQL Server management

Image upload in mysql database using jsp servlet
Image upload in mysql database using jsp servlet Hello, I need code to insert image in mysql database, I have seen the code which is already in your portal but it is not inserting image into database it save in the folder

How to retrieve image from database
How to retrieve image from database hi........ How to retrieve image from database when it is stored. I have stored image in postgresql and want... but it retrieves as a string and not complete image can u tel me the conversion

Ads