How do I simply retrieve the length of a text/blob record from a database? I see the LENGTH function associated with the WHERE clause but I don't see how to say 'give me the lenght of this record'.

Thanx,
Allan Clearwaters

For me I always do something like this
public class HibernateLimousine implements Limousine , Serializable {

private Long limousineId;
private String limousineType;
private String description;
private Double rate;
private Blob picture;
private String fileName;
private int fileSize;

Get file size from application layer and keep it in DB, so this would be easier for me......
Cheers

Allan,

I use something like this:


Report report = (Report) session.load(Report.class, id);
Blob blob = report.getData(); // getter mapped to a blob
long blobLength = blob.length();
...

Jan