I have this problem in geTcolumType :


// fact :fieldIndex refers to a BLOB COLUMN
ResultSetMetaData rsmd = rs.getMetaData();
int columnType = rsmd.getColumnType(fieldIndex);
String columnTypeName = rsmd.getColumnTypeName(fieldIndex);
System.out.println(""+(columnTypeName.toUpperCase().indexOf
("BLOB")>=0); // prints true, which is correct since the column is a
blob
System.out.println(""+(columnType==columnType.BLOB)); //
prints FALSE !!!


This way, I cant detect the column is a blob.. Is there any
trick I am missing ?