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
 
 
subject: How to access a photo in a data base from a frame