This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Uplod Blob with stream Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Uplod Blob with stream" Watch "Uplod Blob with stream" New topic
Author

Uplod Blob with stream

roberto zzzz
Greenhorn

Joined: Mar 19, 2009
Posts: 2
posted private message
0
Quote
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

Joined: Mar 04, 2009
Posts: 415
posted private message
0
Quote
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

Joined: Mar 19, 2009
Posts: 2
posted private message
0
Quote
ver 1.4.2 and this method do not exist

tank you...
Leandro Coutinho
Ranch Hand

Joined: Mar 04, 2009
Posts: 415
posted private message
0
Quote
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

Joined: Oct 08, 2006
Posts: 2458
posted
0
Quote
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?

Code depot of a Java EE / JSF developer | JSF / Eclipse / Tomcat kickoff tutorial | DAO kickoff tutorial | I ♥ Unicode
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
posted
0
Quote
Have you read the Javadoc at any way? http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html#setBinaryStream(java.lang.String,%20java.io.InputStream,%20int)
Leandro Coutinho
Ranch Hand

Joined: Mar 04, 2009
Posts: 415
posted private message
0
Quote
congratulations Bauke Scholtz!
2000 messages!!!

don't reply my post

=D
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
posted
0
Quote
Heh, it isn't that much. Congratulate if I'm over 50K or so.
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Uplod Blob with stream
 
Similar Threads
dealing with images/pictures
BLOB Creation in Java (MS SQL Server or generic)
how to upload xls file
Load Image in a database..Pls help me
using setBlob()