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
