tags:

views:

13

answers:

0
Q: 

HQL: combine "insert into ... select" with fixed parameters values

I have HQL statement:

insert into Item (ost, value, comments, startTime, endTime, proposedBy) 
select si.ost, si.value, si.comments, si.endTime, si.endTime, u 
from Item si, User u 
where si.ost = ? and u.id = ?

How could it be modified to use parameters' values for ost and startTime columns while taking other columns from select?

related questions

Is it worth the effort to move from a hand crafted hibernate mapping file to annotaions?
Hibernate Tools and the ever changing database
What is the best way to load a Hibernate object graph before using it in a UI?
HQL querying columns in a set
Is it possible to use analytic functions in Hibernate?
Hibernate (JPA) how to do an eager query, loading all child objects
Hibernate mapping a composite key with null values
Mixing EJB 2.x BMP entity beans with Hibernate 3.x
Lazy loading property and session.get problem
Hibernate - maxElementsOnDisk from EHCache to TreeCache
Hibernate criteria _ how to use criteria to return only one element of an object instead the entire object
When can/should you go whole hog with the ORM approach?
How do you "OR" criteria together when using a criteria query with hibernate?
Looking for an HQL builder (Hibernate Query Language)
Enabling Hibernate second-level cache with JPA on JBoss 4.2
Getting hibernate to log clob parameters
Hibernate crops clob values oddly
(N)Hibernate - is it possible to dynamically map multiple tables to the one class
Querying collections of value type in the Criteria API in Hibernate
How to maintain Hibernate cache consistency running two Java applications?
Why @OneToMany does not work with inheritance in Hibernate
data 'security' with java and hibernate
Using Hibernate to work with Text Files
Giant NodeManagerLogs from hibernate in weblogic
Hibernate saveOrUpdate with another object in the session