用SSH SQL语句错误哪里有错呢

Question

select this_.pid as pid2_0_,
this_.pname as pname2_0_,
this_.market_price as market3_2_0_,
this_.shop_price as shop4_2_0_,
this_.image as image2_0_, this_.pdesc as pdesc2_0_,
this_.is_hot as is7_2_0_, this_.pdate as pdate2_0_,
this_.csid as csid2_0_ from product this_ where this_.is_hot=? order by this_.pdate desc];
nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query;

SQL [select this_.pid as pid2_0_,
this_.pname as pname2_0_,
this_.market_price as market3_2_0_,
this_.shop_price as shop4_2_0_,
this_.image as image2_0_,
this_.pdesc as pdesc2_0_,
this_.is_hot as is7_2_0_,
this_.pdate as pdate2_0_,
this_.csid as csid2_0_ from product this_ where this_.is_hot=? order by this_.pdate desc];
nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

Answer 1

Hibernate:
select
this_.pid as pid2_0_,
this_.pname as pname2_0_,
this_.market_price as market3_2_0_,
this_.shop_price as shop4_2_0_,
this_.image as image2_0_,
this_.pdesc as pdesc2_0_,
this_.is_hot as is7_2_0_,
this_.pdate as pdate2_0_,
this_.csid as csid2_0_
from
product this_
where
this_.is_hot=?
order by
this_.pdate desc limit ?
11:27:56,588 WARN JDBCExceptionReporter:233 - SQL Error: 933, SQLState: 42000
11:27:56,589 ERROR JDBCExceptionReporter:234 - ORA-00933: SQL 命令未正确结束