Question

hibernate的 session.createSQLQuery这样查不出来数据，但是打出来的sql可以在plsql里查出来数据

sql就长下面这样！
select q.*
from (select u.project_id,
u.file_name,
u.file_path,
u.code_id,
u.package_id,
p.package_name,
u.file_id,
u.op_time,
u.file_type
from CMT_FILE_UPLOAD u, ect_cn_package p
where u.project_id = p.project_id
and u.package_id = p.package_id
and u.is_valid = 'Y'
and u.project_id = '1254d7f77a4c4bcbbdf51db130f0a21c'
and u.code_id like 'chengqingbuyi%') q,
ECT_CN_SUPP_REPLY reply
where q.project_id = reply.project_id
and q.package_id = reply.package_id
and reply.reply_status in ('AFFIRM', 'REPLY')
and reply.supplier_id = 'e7250a9634c74457939fadf490f08f04'

Answer 1

超能力