How do i use full select statement in the hibernate with spring-web application?

EX: select id, lastname||','||firstname from emp

I always got error if i put this string in the find(s) function.

-Henry

This is not valid HQL. Either use createSQLQuery() or learn about HQL by reading the chapter in the documentation.

how do we call createSQLQuery in the following class:

public class EmpDaoSql extends HibernateDaoSupport
{
public List select Emp()
{
// ?? here ??
String s = "select id,lastname||','||firstname from emp";
createSQLQuery(s);
....
}
}

-Henry

This is all very well documented.

I got the following error :

--------------------------------------------------------------------------------
12:46:55,365 ERROR - [util.JDBCExceptionReporter.logExceptions] Invalid column name
--------------------------------------------------------------------------------
my code is:
---------------------------------------------------------------------------------
String sqlString =
"SELECT dept.DEPTNO, dept.DNAME FROM Dept {dept}";

Session sess = getSession();

try {
Query qr = sess.createSQLQuery(sqlString, "dept", Dept.class);

resultList = qr.list();
...

So you have an invalid column name.

what is wrong with my column name?

13:21:10 SQL> desc dept
Name Null? Type
------------------------------- -------- ----
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)

String sqlString =
"SELECT dept.DEPTNO, dept.DNAME FROM Dept {dept}";

and domain class:

public class Dept implements java.io.Serializable {
private int DEPTNO;
private String DNAME;
private String LOC;
...
}

-Henry

please read the docs and note that all examples and doc says that you can load entities with createsqlquery - not scalar values!

Thus: "...if you list each property explicitly, you must include all properties of the class and its subclasses!" <-- taken from the docs and unless you have an object with two properties DEPTNO and DNAME then you have not done as stated in the docs!

First of all what RDBMS are you using ? Some are case sensitive. Second why SQL if HQL can do ? And I agree Max if you mapping only contains native Types and no object relations then you SQL Statement is incorrect, because it will use dept as schema not as Object.

regards

Olaf

is has nothing to do with casesensivity but with the fact that he is only listing 2 column/properties from his object where he at least has shown the object has 3 and more properties. Thus when hibernate tries to build his object and wants to get LOC then it fails because it is not part of his output from the query.