Show Table of Contents
1.4. Generated Keys
JBoss Data Virtualization supports returning generated keys for JDBC sources and from JBoss Data Virtualization temp tables with SERIAL primary key columns. However the current implementation returns only the last set of keys generated and returns the key results directly from the source - no view projection of other intermediate handling is performed. For most scenarios (single source inserts) this handling is sufficient. A custom solution may need to be developed if you are using a FOR EACH ROW instead of trigger to process your inserts and target multiple tables that each return generated keys. It is possible to develop a UDF that also manipulates the returned generated keys - see the
org.teiid.CommandContext methods dealing with generated keys for more.

Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.