using native SQL

[13年前 に asile elisa によって更新されました。]

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.

[13年前 に asile elisa によって更新されました。]

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.

[11年前 に Zhao Jin によって更新されました。]

Should use BookImpl.class

[11年前 に Harish Kumar によって更新されました。]

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.

[11年前 に Hitoshi Ozawa によって更新されました。]

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.