Hello! We have a scenario where the user can select multiple employeeID's that we need to show line items on in one shot. The number of items in the selection could possibly be 1000's. To execute such a query, we would have to use an IN clause e.g. SELECT name, date, salary FROM EMPLOYEE WHERE empID IN (x,y,z..........)
Now the IN length of the SQL will become very large & many databases have limits on the SQL statement length. We are using a temporary table to store the use selection & then we do a join against the temporary table & the EMPLOYEE table to get our results back. Can we do this using Hibernate? Are there any plans to support such a functionality? Thanks Rajan __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
