Need Help in adding photo [message #333953] |
Tue, 15 July 2008 00:44 |
sai.baranidharan
Messages: 4 Registered: July 2008 Location: Chennai
|
Junior Member |
|
|
I need to insert photo as a BFILE type into my database table. The inserted photo needs to be stored in a folder automatically.
I have a field 'joining date' in my database. The photo inserted should be stored in the folder whose name is the year of joining. The folder should be automatically created.
Also, the file name should contain the number of the row that is being inserted.
Please help me in this issue. I need to submit this in 5 days.
|
|
|
|
|
Re: Need Help in adding photo [message #334406 is a reply to message #333953] |
Wed, 16 July 2008 06:58 |
sai.baranidharan
Messages: 4 Registered: July 2008 Location: Chennai
|
Junior Member |
|
|
I am doing my Masters degree and I need to submit my project as part of my curriculum.
I am using Java as front end and Oracle 9i as back end to develop a desktop application on College Management System.
In this application, I need to add the details of students who had joined into the institution.
The database table contains fields like 'JOINING DATE','ROLLNO'(and some more fields, which I am not mentioning here)
What I need is this:
1. I need to insert a photo into the database. The photo needs to be stored into a folder. The folder's name should be the 'year of joining'(This can be retrieved from the field 'JOINING DATE'). This should not be done manually. It should be automatically created when the photo is inserted.
2. The file name of the photo inserted into the folder/table, should be the student's roll number.
I think I am clear. If you need further details, please post it. I would reply to you as soon as possible.
As I am learning Oracle and doing it, I am seeking the help of some professionals in this forum. Please do not mistake me or neglect my post.
thanks a lot.
|
|
|
Re: Need Help in adding photo [message #334410 is a reply to message #334406] |
Wed, 16 July 2008 07:03 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
1. Oracle does not manage directories or files, this is an issue for your Java application.
2. Idem.
A simple select allows you to retrieve the data you want, the other points (naming) is for your Java application, then you can reference the photo in your Oracle table using a BFILE field which is just a "pointer" to the OS photo file.
Regards
Michel
|
|
|