aspose file tools*
The moose likes JDBC and the fly likes How to access a photo in a data base from  a frame Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to access a photo in a data base from  a frame" Watch "How to access a photo in a data base from  a frame" New topic
Author

How to access a photo in a data base from a frame

Mukesh Jain
Greenhorn

Joined: Jan 17, 2001
Posts: 9
Sir
can you please tell me how to insert a photo in oracle database from a frame in java and retrive it back
please
Mukesh Jain
Lakshmi Kishore
Ranch Hand

Joined: Aug 04, 2001
Posts: 51
hi,
can you please explain me a little more.
bye
glkishore


Thanks & Regards<br />glkishore
Mukesh Jain
Greenhorn

Joined: Jan 17, 2001
Posts: 9
Originally posted by Lakshmi Kishore:
hi,
can you please explain me a little more.
bye
glkishore
]
I mean that how to insert a photo to oracle database and retrive a photo using blob and clob. for example a in student information system we require the photo of the student with other details, which are retrived when required.Hope you understand!
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

here is the jdbc sample code for LOBS to an Oracle DB(retrieving and inserting)
http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/advanced/advanced.htm
look for the link "LOB Datatype"
you might have to hit the Swing forum to find out how to display it nicely on the screen.
Jamie
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to access a photo in a data base from a frame