Hello,

The following name query is generating incorrect SQL (see below). Why would this be happening?

<query name="updateDownloadDate"><![CDATA[
update Tcat t
set t.downloadDate = :downloadDate
where t.target = :target and
t.plan.name = :plan and
t.payload = :payload
]]>
</query>

update
dxc.tcat,
set
tcat_download=?
where
tcat_target=?
and plan_name=?
and tcat_payload=?

Hi,
I'm not sure If this would solve the issue but out of curiosity why do you need an alias when you have just one Entity/Table in the query?

Have you tried this removing the alias?:-
<query name="updateDownloadDate"><![CDATA[
update Tcat set downloadDate = :downloadDate
where target = :target and
plan.name = :plan and
payload = :payload
]]>
</query>

Thanks for your reply. I'll try it and see.