Can anyone please tell me how i can achieve this. Please. I am very much new to all this and i want to learn.
Well, it isn't really a JDBC question as such. But that's because it's really a long list of questions. Let's go through what I think is the list:
1. How do I upload files using JSF?
Well, I don't know. That's a JSF question. If JSF doesn't have that as a built-in feature then I would recommend using the Apache Commons FileUpload package.
2. Once I have the file upload, how do I put it into a blob in my database?
You seem to think that JSF and ADF have this covered. I don't know anything about that. And there isn't much point in going into detail about JDBC if they already do, so I won't.
3. How do I display one of these blobs?
That's a JSF question, too. Normally you would just provide a URL with a parameter identifying how to get the blob from the database, and write a servlet which streams the data from the blob back to the response's output stream. It would use JDBC to get the blob data if JSF didn't already have that sort of thing built in. Which I don't know if it does or not.