Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Uplod Blob with stream

 
roberto zzzz
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I want to store big data in a blob (Oracle 10g)
I can use only Store Procedures...
My problem is :

I don't know the blob size and CallableStatement provide only a method setBinaryStream (column, inputStream, size).
The method setBinaryStream(column, inputStream) is not available .

waht is the value for "size" ?

the value "-1" don't work....

Tank you.

 
Leandro Coutinho
Ranch Hand
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
e ae blz

I tested here and this method exist.


http://www.giraffeed.com/show-image.php?id=bf48b0b680801f0bfeac3ce24d7e9787

What version of JDK you are using?

 
roberto zzzz
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ver 1.4.2 and this method do not exist

tank you...
 
Leandro Coutinho
Ranch Hand
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
roberto zzzz wrote:ver 1.4.2 and this method do not exist

tank you...


I'm using JDK 6 and this method exist.

http://java.sun.com/javase/downloads/index.jsp
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
roberto zzzz wrote:
waht is the value for "size" ?

Do a guess? What does the parameter name "size" itself say when you keep a binary stream in mind?
 
Bauke Scholtz
Ranch Hand
Posts: 2458
 
Leandro Coutinho
Ranch Hand
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
congratulations Bauke Scholtz!
2000 messages!!!

don't reply my post

=D
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Heh, it isn't that much. Congratulate if I'm over 50K or so.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic