final String query = "SELECT e.* FROM SimpleEntity e WHERE convert_from(lo_get(cast(e.value as oid)), 'UTF8') = :value";
final List<SimpleEntity> results = session.createNativeQuery( query, SimpleEntity.class )
    .setParameter( "value", value )
    .getResultList();