This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
Similar Threads
Can I join two tables in a NamedQuery?
Prepared Statement Error
Issue with inserting a BLOB using IBatis DAO
java.io.ioException
DB2 SQL Error: SQLCODE=-103