how to insert a file

[jsweety]

hi there
i am using complete jsp
and my backend is oracle 9i

i want to insert a file it may be with any format
into database field

please suggest database field datatype clob or blob or else....

i am a beginner so please be a bit descriptive

thanx in advance

regards
sweety

 

[kalimba]

Hi, I am also a beginner but I have just gotten this working on my machine using MYSQL. The Database part was easy but getting the other stuff working was a bit difficult for me. I used the following instructions:


1)Upload File Part

http://www.onjava.com/pub/a/onjava/2003/06/25/commons.html?page=3

Note that this is a three page tutorial with the source files on the 1st page. So after you read page three, go to page one to get the files downloaded.

This all worked perfectly after adding the appropriate .jar files and classpath stuff.

2)Database part. On the page called fileuploaddemo.jsp there is a section of the code that deals with uploading a file:

// the item must be an uploaded file
// save it to disk
File fullFile = new File(item.getName());
File savedFile = new File(getServletContext().getRealPath("/"), fullFile.getName());
item.write(savedFile);

//I added these lines to write to my database. They use the class which I wrote and is stored in a java class file.

UploadDB myDBFunctions = new UploadDB();
int up = myDBFunctions.insertFile(fullFile);



//BELOW IS THE JAVA CLASS. You mentioned you wanted to do it all in JSP. It would probably look similar anyway though.


package package_name;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

/**
*
* @author BUCKET
*/
public class UploadDB {

/** Creates a new instance of UploadDB */
public UploadDB() {
}


public int insertFile(File f) throws Exception{

// connection instance
Connection connection = null;
FileInputStream fis = null;
int myint = 0;
File file = new File("/Users/you_computer_name/file_path/test.mp3");
fis = new FileInputStream(file);
//My test table in the db has one field - file_name it is a BLOB
String sqlInsertFile = "INSERT INTO files (file_name) VALUES ('" + file + "')";

try {
// connect to database
DataSource dataSource = getJdbcConnectionPool();
connection = dataSource.getConnection();
PreparedStatement ps = connection.prepareStatement(sqlInsertFile);
myint = ps.executeUpdate();

} catch(Exception e){
System.out.println(e.getMessage());

} finally{
// close the connection so it can be returned to
// the connection pool then return the list
connection.close();
return myint;

}
}



//Here I used a connection Pool. However there is plenty of examples on google of how to connect directly.

private DataSource getJdbcConnectionPool() throws NamingException {
Context c = new InitialContext();
return (DataSource) c.lookup("java:comp/env/jdbc/connectionPoolWiz");
}

}

I hope this helped a bit. Like I said, I am new to this as well and it took me a few days of having no idea what to do before I got it working. If you have some success let me know. I am currently stuck on how to get the file back out of the database! Good luck.

 

[prosper]

Saving file to database is similar to saving a file to server.
1)There will be upload library on server side to upload a file.
2)Then you can click a browse file button and select a file in local harddisk
3)The file will be changed to a stream of data


4)you can save that stream of data into database(saving to database)
5)or you can save that stream of data into a file (upload a file)

The following is the link for the upload library. It is difficult for a beginner to configure it.

http://commons.apache.org/fileupload/