OK DB2 and TimesTen gurus :) I am adding the "insert ... select ..." functionality to HQL. For sequence generated ids I am not sure of the syntax of how to do this for DB2 and TimesTen dialects.
The normal Dialect.getSequenceNextValString() returns a complete statement ("select " + sequenceName + ".nextval from dual" for Oracle for example). So this cannot be used within select statements. So I added a new Dialect.getSelectSequenceNextValString() method which returns the "selectable" nextval fragment (sequenceName + ".nextval" for Oracle again) which can be embedded into another select statement. But I have no idea of the acceptable syntax of that for either DB2 or TimesTen. Need some help Thanks ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel