How to configure eclipselink so that Teiid can provide sequence for auto generated id?

[kchen007]

When creating a new entity, if the entity has system generated key, how can I get this key back after I call EntityManager.persistent()? 

Thanks

Kevin

[shawkins]

Teiid does not yet provide a mechanism to return a generated key, see https://issues.jboss.org/browse/TEIID-1557

Steve

[kchen007]

Steve:

Do you have some suggestion on how to work around the issue for now?

Thanks.

Kevin

[shawkins]

A workaround would be slightly involved.  At the translator level you would need to capture the generated id(s) and then store them on something with a session scope - there would be a couple of hacks to use the CommandContext.  Then add a UDF to retrieve the generated id that was last created.

I'll look at addressing this within Teiid proper for 8.3 as this has come up several times.

Steve

[kchen007]

Steven:

As always, thanks for the information.

Kevin

[shawkins]

Basic support for generated keys will be in 8.3 - see https://issues.jboss.org/browse/TEIID-2169

The first alpha should be available later today.

Steve

[kchen007]

Steve:

I want to pick up this with beta 3, is there any documentation on how to use it?

Thanks

Kevin

[shawkins]

Documentation on what aspect?  Returning generated keys from the Teiid client is no different than any other JDBC implementation, use a create/prepareStatement that specifies the Statement.RETURN_GENERATED_KEYS option, then call Statement.getGeneratedKeys() after the statement has executed.  Are you looking more for something built-in like: https://issues.jboss.org/browse/TEIID-1910

Steve