Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes Java in General and the fly likes how to load file into DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "how to load file into DB" Watch "how to load file into DB" New topic

how to load file into DB

trupti nigam
Ranch Hand

Joined: Jun 21, 2001
Posts: 613
I don't know this question is suitable for which please excuse me..
I have many files..pure text files.When some request comes i need to load these files into DB & query the DB to find out the file browsing is time consuming.
i am using oracle Db.
i will be doing this frequently..
does any one know can it be possible & if how can i acieve that?

Cindy Glass
"The Hood"

Joined: Sep 29, 2000
Posts: 8521
You could check out saving the files as blobs. In that case the files remain where they were on disk and the database just keeps a pointer to where the file is.

"JavaRanch, where the deer and the Certified play" - David O'Meara
I agree. Here's the link:
subject: how to load file into DB
It's not a secret anymore!