Hibernate native sql clob ve blob select yapma

Session session = getSessionFactory().getCurrentSession();
SQLQuery query = session.createSQLQuery("select * from table");

query.addScalar("MRICH_RICHTEXT1", Hibernate.CLOB);

List<Object> s = query.list();

Clob c = (Clob) s.get(0);

Date d2 = new Date();

try {

System.out.println("DAOOOOOO2331134String value of Clob -  " + c.getSubString(1,(int)c.length()));
} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();
}

Blob ta bu şekilde yapılabilir.