my dog learned polymorphism
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "UnsupportedOperationException and ODBC-driver" Watch "UnsupportedOperationException and ODBC-driver" New topic

UnsupportedOperationException and ODBC-driver

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

Do I need another (newer) driver, or causes this problem something else?
Thank U
Good luck
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.
I agree. Here's the link:
subject: UnsupportedOperationException and ODBC-driver
It's not a secret anymore!