How to create blob objects
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Christophe_Grosjean
Posted On:   Tuesday, February 19, 2002 01:14 AM

Hi all,
I want to create Blob objects. How can i do that ? Must I implement the java.sql.blob interface ? I did it for Clob object but internal representation of a blob seems to be more complex... what could be this implementation of a blob ?

Thx for any help.
Christophe

Re: How to create blob objects

Posted By:   thirupathi_rajan  
Posted On:   Wednesday, February 20, 2002 01:18 AM

Actualy, i have done storing & retrieving .gif images into database. when i am retrieving images from database, i used blob. For this, i imported java.sql.blob. i am sending samle codes for ur reference. Are u trying to store and retrieve images into database......?.


To store a image,




Connection conn=null;

try{

File image = new File("c:\images\adobe.gif");

InputStream streamimage = new FileInputStream(image);

conn = getConnection();

PreparedStatement pstmt = conn.prepareStatement("insert into image ( imageid, imageblob ) values ( ?, ?) ");

pstmt.setString(1, "101");

pstmt.setBinaryStream(2, streamimage, ( (int) image.length() ) );
pstmt.executeUpdate();




When retrieving image,


Connection conn=null;

Blob blob=null;

int blength;

byte [] imgBytes = "sd".getBytes();

try{
conn = getConnection();

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery ("select * from image");

rs.next();

blob = rs.getBlob("imageblob");

blength = (int)(blob.length());

imgBytes = blob.getBytes(1, blength);



In the database, datatype of imageblob variable should be "blob".
I hope that it should be helpful for u.
About | Sitemap | Contact