aspose file tools*
The moose likes JDBC and the fly likes inserting jpg/gif in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "inserting jpg/gif in oracle" Watch "inserting jpg/gif in oracle" New topic
Author

inserting jpg/gif in oracle

padmanabh dongre
Greenhorn

Joined: Aug 13, 2001
Posts: 24

HI

I am getting the following error when i execute the following line.
rs = stmt.executeQuery("SELECT FILEDATA FROM TMPBLOB WHERE FILENAME='test.jpg' FOR UPDATE");
where FILEDATA is of type BLOB.
Error : java.sql.SQLException : General error
when i try the following Select query on SQL prompt
SELECT FILEDATA FROM TMPBLOB;
I get the error message : Column or attribute type can not be displayed by SQL*Plus
why this should happen ??
thank you.
Padmanabh

sanjay yermalkar
Greenhorn

Joined: Sep 19, 2001
Posts: 23
Error : java.sql.SQLException : General error

Could you please describe this more? may be a printStackTrace will help.
I also get the same error in SQL plus, i think it cannot display binary data types.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: inserting jpg/gif in oracle