• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to retreive a blob....

 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I am trying to retreive a blob from the oracle 8.1.6.0.0 using jdk1.3. I tried most of the method's as per the API but could not get any result.
blob = (java.sql.Blob) rs.getObject(3);
InputStream in = blob.getBinaryStream();
byte[] b_blob = new byte[blob.length()];
b_blob = in.getBytes(1, blob.length());
// length = blob.length();
// txtfield.append("Length of blob : " + length);
Is there any other way out to retreive the blob. I have tried get Blob method as well. Moreover, I am not able to print the length of the blob as well.
I was able to insert the blob in the oracle database but could not check it exactly what is going in. As I tried to import the table in MS Access, it give me long binary data(AS MS access does not have objects). Can any one please, help me in how to check what is inserted in the table and also how to retreive the blob....Sample code is most welcome.
tia.........
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
here is a sample: http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/advanced/advanced.htm
click on the
LOB Datatype
JDBC: Source

about the length issue: http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_16_
this may be relevant or not..
Jamie
 
Being a smart alec beats the alternative. This tiny ad knows what I'm talking about:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic