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 how to write BLOB type of data from java application into an oracle table 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 "how to write BLOB type of data from java application into an oracle table" Watch "how to write BLOB type of data from java application into an oracle table" New topic
Author

how to write BLOB type of data from java application into an oracle table

Aparna Yadav
Greenhorn

Joined: Sep 13, 2004
Posts: 4
I want to write a java application which will store BLOB type of data into an oracle table & same way retrieve it from table.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1076

use PreparedStatement !!! you can set your blob data using
PreparedStatement.setBlob(int i, Blob x)

and you can retrieve your blob from resultset using
resultset.getBlob(String colName)


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: how to write BLOB type of data from java application into an oracle table
 
Similar Threads
java.sql.SQLException: Unsupported feature
How to store & retrieve a video file from database?
how to insert CLOB data type
BLOB data type
Parsing BLOB datatype