using native SQL

[asile elisa, geändert vor 13 Jahren.]

hi everyone,

I want tp use native SQL but even a simple query did not work and I got an exception
here is the Query:

session.createSQLQuery("SELECT * FROM Book").addEntity(Book.class).list();

here is the exception:

org.hibernate.MappingException: Unknown entity: com.ext.portlet.library.model.Book

thanks in advance.

[asile elisa, geändert vor 13 Jahren.]

hi,

I can use native SQL directly in my JAVA class right?
it is not necessary to define my queries in xml files like what is shown in this article:
custom query
right??

thanks.

[Zhao Jin, geändert vor 11 Jahren.]

Should use BookImpl.class

[Harish Kumar, geändert vor 11 Jahren.]

You cant use native sql directly in your java class.
hibernate session wont be available there. You should follow the same link for custom query, you have posted.

[Hitoshi Ozawa, geändert vor 11 Jahren.]

Is there some reason to why you would want to use sql directly? Liferay sometimes changes fields and interfaces and writing sql directly would make maintenance more difficult.