I am working on an insert into...select statement, and I ran into an issue with using named parameters in the select clause (see HQL below). My thought was that I could use the parameters instead of actual values to reduce the number of prepared statements generated. Is this supported in HQL? If so, what am I doing wrong in my query?

insert into DataReqSetDetail
(dataReqSet, moduleDataReqAssoc, orderNumber, createdBy, modifiedBy)
select drs, mdra, :order, :createdBy, :modifiedBy
from DataReqSet as drs, ModuleDataReqAssoc as mdra
where drs.id = :dataReqSetId
and mdra.id = :moduleDataReqAssocId

The query works if I provide values for :order, :createdBy and :modifiedBy parameters as follows:

insert into DataReqSetDetail
(dataReqSet, moduleDataReqAssoc, orderNumber, createdBy, modifiedBy)
select drs, mdra, 1, 'username', 'username'
from DataReqSet as drs, ModuleDataReqAssoc as mdra
where drs.id = :dataReqSetId
and mdra.id = :moduleDataReqAssocId


Thanks in advance,
Scott

Hi

You are selecting from the table but i think you are nowhere setting the data of :nnnnn,:nnnnnn,:nnnnnn

In the second query you are giving the values but in the first query where are you giving the values ? you are only retrieving but not setting the values for parameters.

Shantha,

Thank you for your reply. In the java code related to the query, I provided values for each of the named parameters.

Hibernate was unable to parse into SQL and threw a query exception with the named parameters in the select clause.

Scott

Hi shammer64


Can u please post the query so that i can have a look at it.