Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

storing /retrieving blob data from SQL2000  RSS feed

sunil kumre
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using SQL2000 database server .I want to store a file in database.What should be the field type for storing a file?
Also i would like to store/retrieve this file to/from the database using java.
Can someone help?
thanks in advance
raghavender rao
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi ther,,,
hope this code wil help u
import java.sql.*;
import oracle.jdbc.driver.OracleDriver;

class DemoDataBaseTest {

public static void main(String args[]){

Connection con = null;
PreparedStatement pstmt;
ResultSet rs;
Blob blob = null;


DriverManager.registerDriver(new OracleDriver());
con = DriverManager.getConnection("jdbc racle:thin:@","scott","tiger");

Statement stmt = con.createStatement();
pstmt = con.prepareStatement("insert into temp values(?,?)");


File file = new File("apache_pb.gif");

//File file = new File("");

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);


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 = != -1){



}catch(Exception e){





using the above program u can store/retreive any type of file... any database....

Sun Certified Programmer for the Java� 2 Platform
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!