Consider the following SQL example:
Code:
mysql> INSERT INTO Employee (Empid,Empname,Salary,DOB) VALUES
-> (01,'John',2014,20041202),
-> (02,'Tom',4021,20030411),
-> (03,'Mary', 22,20080223),
-> (04,'Sam', 25,20081015),
-> (05,'Tim', 29,19990126);
I need to achieve the same in Hibernate via a SQL query to an unmapped table i.e. use a SQLQuery.
The complexity I'm facing is that the number of 'Employees" is very large (let's say 1,000,000) > I could use MANY named parms to set id, name, salary, dob but is there a way I could pass in all this information in one collection
say, . this or something similar
.... sqlQuery.setAParameterList(List<Array of Parms.>
Or can I do this using multiple parameterlists ?
Thanks
Login
FAQ
Search
