This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Blob?

 
moh sak
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,

i'm trying to retrive a pic from the database using the getBlob method but the following exception pops up :

java.lang.UnsupportedOperationException

at sun.jdbc.odbc.JdbcOdbcResultSet.getBlob(JdbcOdbcResultSet.java:4390)



and i don't know what it's mean . any way this is my code that i use to retrive the picture :


public byte[] getBlob() throws SQLException {
String SQLCommand = "SELECT user_pic FROM USERS where user_id = ? ";
dbUtil.openConnection();
Blob blob = null;
byte[] bytes = null;
PreparedStatement pstmt = dbUtil.prepareStatement(SQLCommand);
if (pstmt == null) {
throw new SQLException("Erorr In Preparing Update Statement In UsersDAO");
}
pstmt.setInt(1, 1010);
ResultSet rs = pstmt.executeQuery();
//ResultSetMetaData md = rs.getMetaData();
while (rs.next()) {
blob = rs.getBlob(1);
}
bytes = blob.getBytes(1, (int) (blob.length()));
dbUtil.closeConnection();
return bytes;
}





any one can help me ?? please i realy need help


thanx in advance.
[ June 11, 2005: Message edited by: Bear Bibeault ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The error message means exactly what it says: that the getBlob() method is unsupported by your driver. You could change drivers to one which does support this method. What database are you using?
 
moh sak
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi thanx for you'r replay , i'm using microsoft sql server .

is there any way to do it ? i'm using the jdbc dbc bridge !!???
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic