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 ]