Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes UnsupportedOperationException and ODBC-driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "UnsupportedOperationException and ODBC-driver" Watch "UnsupportedOperationException and ODBC-driver" New topic
Author

UnsupportedOperationException and ODBC-driver

dar
Ranch Hand

Joined: Nov 08, 2001
Posts: 45
Hi, Ranchers
I have this problem, help me please.
In my JSP I want read BLOB (rs.getBlob("PICTURES")). But I get "UnsupportedOperationException".
I have oracle 8.1, tomcat403 and W2K.
I'm using odbc-jdbc bridge, driverClassName=sun.jdbc.odbc.JdbcOdbcDriver.
My driver is Oracle ODBC Driver v 8.01.07.00

Do I need another (newer) driver, or causes this problem something else?
Thank U
Good luck
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I think the reason is that the JDBC-ODBC Driver does not support BLOB's. So when you call the method getBLOB() you call an unsopportet driver method.
So better try to get the Oracle Thin Driver to access your Oracle Database. Then it should work.
Oliver
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: UnsupportedOperationException and ODBC-driver
 
Similar Threads
connection url
Odbc problem help me
Establishing Connections to a Data base on a different machine
Oracle ODBC Driver Problems. Please help
connectivity problem