Hello,
I'm having troubles with views. I would like to perform a select query on a view.
In results, i get a list filled of null objects. The number of null object is the right number of object i should have.
My key on the view is a composit one made of all the columns.
Here is the java part
Code:
public ArrayList getListObj(String sc) {
try {
Query query = getSession().createQuery("from Obj inv where inv.cs = :cs");
query.setString("cs",sc);
return new ArrayList(query.list());
} catch (Exception e) {
throw new DAOException( "Error getting the getListObj for cs : " + sc, e);
}
}
The Obj class mapps the view.
I'm using hibernate 3.0.beta4
Name and version of the database you are using:Oracle 9iThe generated SQL (show_sql=true):generated sql is okThank's a lot for your help.
Pat
[/code]
Login
FAQ
Search
