how to upload image/video file in to database

[meseenu]

Hi every one,

iam developing an application where i want to upload image and video files in to a oracle data base. I have used BLOB data type to store the image and video files.

iam using jsp as front end and java servlet for the application.

iam converting the image file into byte[] and then inserting in to data base.

problem for me is iam able to do this on a local system. ie iam running the java in my local PC and able to upload the image files from that same PC.

if i run tha application from one PC and try to upload from different PC then iam not able to upload.

[meseenu]

Hi every one,

iam developing an application where i want to upload image and video files in to a oracle data base. I have used BLOB data type to store the image and video files.

iam using jsp as front end and java servlet for the application.

iam converting the image file into byte[] and then inserting in to data base.

problem for me is iam able to do this on a local system. ie iam running the java in my local PC and able to upload the image files from that same PC.

if i run tha application from one PC and try to upload from different PC then iam not able to upload.

pls suggest me what can be done

[r035198x]

Please do not double post.

Threads merged.

[Suvranil Basu]

Image upload from JSP to Data Base step by step :

step 1 :
In the JSP
<form name="regform2" method="post" enctype="multipart/form-data">
<input type="file" name="ImageFile" id="ImageFile" onChange="uploadImage()"/>
</form>

java script :
function uploadImage(){
document.regform.action ="<%=request.getContextPath()%>/dfdmin?cmd=uploadimage";
document.regform.submit();
}


Step 2.
In the servlet - add the below code.
String rtempfile = File.createTempFile("temp","1").getParent();
MultipartRequest multi = new MultipartRequest(request, rtempfile, 500000 * 1024);
File rnewfile=null;
rnewfile = new File(CommonArt.IMAGE_PATH+"jsp"+File.separator+"im ages"+File.separator+"uploadImage"+File.separator) ;
if(rnewfile.exists()){
}else{
rnewfile.mkdirs();
}

File f = multi.getFile("ImageFile");
System.out.println(f.getName());
FileInputStream fin =new FileInputStream(f);
RandomAccessFile r = new RandomAccessFile(rnewfile+File.separator+f.getName (),"rw");
filename = f.getName();
// FileOutputStream fos =new FileOutputStream(rnewfile);
byte sizefile[] = new byte[5000000];
fin.read(sizefile);
// fos.write(sizefile);
r.write(sizefile);
//fos.close();
r.close();
fin.close();


Step 3.
Insert into Database

InputStream is = new FileInputStream(f);
String sql = " INSERT INTO image_upload (IMAGE) VALUES (?) ";
pStmt = conn.prepareStatement(sql);
pStmt.setBinaryStream(1, is, (int)(f.length()));
pStmt.execute();
conn.commit();


This will upload multipart file to your data base.
Note : get cos.jar from oreilly website

Hope this will help you....!!!

Regards,
Suvranil.

[simbukalai]

Connection conn = getConnection();
Statement stmt = conn.createStatement();
File file = new File("Your Video File Location and file name");
FileInputStream fileInputStream = new FileInputStream(file);
ByteArrayOutputStream out = new ByteArrayOutputStream();
while (fileInputStream.available()>0) {
out.write(fileInputStream.read());
}
byte[] jpgByteArray = out.toByteArray();
String driver = "com.mysql.jdbc.Driver";
Class.forName(driver);
String INSERT_PICTURE = "insert into MyPictures(name, video) values (?, ?)";
PreparedStatement ps = null;
try {
conn.setAutoCommit(false);
ps = conn.prepareStatement(INSERT_PICTURE);
ps.setString(1, "Test1");
ps.setBytes(2,jpgByteArray);
ps.executeUpdate();
ResultSet rs = stmt.executeQuery("SELECT video FROM MyPictures");
while (rs.next()) {
File file1 = new File("Mention the destination File Location and FileName");
FileOutputStream foStream = new FileOutputStream(file1);
ByteArrayOutputStream oStream = new ByteArrayOutputStream();
if(rs.getString("photo") != null){
InputStream is2 = rs.getBinaryStream(1);
byte[] bytes=new byte[is2.available()];
is2.read(bytes);
oStream.write(bytes);
oStream.writeTo(foStream);
}
conn.commit();
}finally {
ps.close();
}

NOTE :
If you are using MySQL DB then include code in the my.ini file as follows,This is for increase the storeage file size

wait_timeout=28800
interactive_timeout = 28800
max_allowed_packet=64M
socket = /tmp/mysql.sock
skip-locking