ansaurus

Question

whats wrong with this simple HQL syntax?

Answer 1

+3 A:

You're specifying the table name, not the class name; they differ in case. Try this:

private static final String SQL_GET_FILE_LIST = 
     "select filename, size, id, type from FileObject";

Admittedly it's been a while since I've done any Hibernate, but I suspect that's the problem...

Jon Skeet 2010-09-14 12:56:05

you suspect correctly

Bozho 2010-09-14 13:02:15

Answer 2

+5 A:

Well, first of all, as the trace says, fileobject is not mapped but FileObject is. So change your HQL query into:

select filename, size, id, type from FileObject

Second, since you're using projections, you won't get a List<FileObject> but a List<Object[]>. So your code should be:

private static final String SQL_GET_FILE_LIST = "select filename, size, id, type from FileObject";

@Override
public List<Object[]> getFileList(String type) {
    // TODO Auto-generated method stub
    List<Object[]> files = hbTemplate.find(SQL_GET_FILE_LIST);
    hbTemplate.flush();
    return files;
}

Or, if you want to get a type safe result, you could use a constructor expression (assuming your class is providing the appropriate constructor):

select new FileObject(filename, size, id, type) from FileObject

And then you could use your current code.

private static final String SQL_GET_FILE_LIST = "select new FileObject(filename, size, id, type) from FileObject";

@Override
public List<FileObject> getFileList(String type) {
    // TODO Auto-generated method stub
    List<FileObject> files = hbTemplate.find(SQL_GET_FILE_LIST);
    hbTemplate.flush();
    return files;
}

Reference

Hibernate Core Reference Guide
- 14.6. The select clause

Pascal Thivent 2010-09-14 13:00:01

working now with no errors thanks again

jonney 2010-09-14 14:55:10

@jonney You're welcome, glad it's solved.

Pascal Thivent 2010-09-14 15:06:55

ansaurus

tags:

views:

answers:

whats wrong with this simple HQL syntax?

Reference

related questions