This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes how to create and read a blob in oracle database through java? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to create and read a blob in oracle database through java?" Watch "how to create and read a blob in oracle database through java?" New topic
Author

how to create and read a blob in oracle database through java?

Vinod Vinu
Ranch Hand

Joined: Aug 30, 2009
Posts: 217
hi, im extremely new to blob. i have a task to do like i have to iterate a list based on some conditions, actually this is a list of bids stored in some tables in oracle which are old bids. i have to archive those old bids in such a way that i have to store them as blob in oracle database in some other tables. Now whenever the user wants to see those old bids then i should read those archived blob data and generate a report using java.

Any idea to get begin with ?

thanks in advance


Vinod Kumar Nair
"Any fool can write code that a computer can understan. Good programmers write code that humans can understand."
Wouter Oet
Saloon Keeper

Joined: Oct 25, 2008
Posts: 2700

My first question would be, what have you done so far?

Also you could begin by telling us on what platform you're working on. Why the data needs to be stored in a blob. How you're connection to the database etc. Basically TellTheDetails.

Also it is appropriate to tell who you're quoting in your signature like I've been doing for years.

Edit: and there is a typo in your quote.


"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

I would start with the BLOB section of the JDBC tutorial.

Also, moving your post to our JDBC forum.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
VennkataReddy Kv
Greenhorn

Joined: Mar 28, 2011
Posts: 3
Hi

You can use serialization mecchanisum.
And serialize each object and pass these serialize file to a specific BLOB column.
If you want to read data from database you can Deserialze the Object...........

I think it is helpful for you

Regards
--------------
Venkata Reddy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to create and read a blob in oracle database through java?
 
Similar Threads
How to store & retrieve a video file from database?
Oracle function using Java to return Blob is zero size
Predict...
jpg to BLOB and BLOB to JPG
Does the persistence layer know when the database has changed?