用SSH 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
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

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 命令未正确结束

this_是什么？缺东西吧？

看着SQL没问题。
先把SQL语句上数据库客户端工具执行一下试试，看能不能正常执行。

恕我冒味，为啥你最后desc后面有一个]呢

是不是多写或者少写了一个逗号