Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to save files into oracle database using java as a object.

 
Mannu Pal
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
i have a requirement in which i have to save some files into a table. and these files may b in any format like (Pdf, csv, doc etc). i have to do this using java coding.

can any one guide me to do this.

Thanks ,

Mannu Pal.
 
raj malhotra
Ranch Hand
Posts: 288
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can use blob type to save file of any format as it stores the binary format.
 
Campbell Ritchie
Sheriff
Pie
Posts: 47285
52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am sure "b" is a simple spelling error, but beware: using pseudo-words can make the posts very difficult for some people to read. Please see this FAQ.
 
Mannu Pal
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi raj malhotra ,

i am using blob type. and i am able to save data into oracle database(as object). but at the time of retrieving i am not getting real one.
at the time of insert i am checking the byte[] and at the time or retrieve its giving different byte[].

can you guide how to do this.
if required i will share code with you.

Thanks ,
Mannu Pal.
 
raj malhotra
Ranch Hand
Posts: 288
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try to save and retrieve this way:

 
tillu Sharma
Greenhorn
Posts: 8
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks save file in database but how to download save in database file...what is the exact procedure....
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic