hi ther,,,
hope this code wil help u
import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.OracleDriver;
class DemoDataBaseTest {
public static void main(String args[]){
Connection con = null;
PreparedStatement pstmt;
ResultSet rs;
Blob blob = null;
try{
DriverManager.registerDriver(new OracleDriver());
con = DriverManager.getConnection("jdbc
racle:thin:@192.168.0.50:1521:ORCL","scott","tiger");
Statement stmt = con.createStatement();
pstmt = con.prepareStatement("insert into temp values(?,?)");
pstmt.setInt(1,1);
File file = new File("apache_pb.gif");
//File file = new File("Part.java");
pstmt.setBinaryStream(2,new FileInputStream(file),(int)file.length());
int i = pstmt.executeUpdate();
System.out.println( "the execution succeeds");
String strqry = "select * from temp";
rs = stmt.executeQuery(strqry);
if(rs.next()){
i = rs.getInt(1);
blob = rs.getBlob(2);
System.out.println("Values Retreived Successfully");
} else {
System.out.println("Cannot Retreive Values from database");
}
InputStream is = blob.getBinaryStream();
FileOutputStream fos = new FileOutputStream("apache_pb2.gif");
int c=0;
while((c = is.read()) != -1){
fos.write(c);
}
}catch(Exception e){
System.out.println("Oops");
e.printStackTrace();
}
}
}
using the above program u can store/retreive any type of file... any database....
Rao
------------------
Rao
Sun Certified Programmer for the Java� 2 Platform