[teiid-issues] [JBoss JIRA] (TEIID-4596) Teiid does not return genereted keys after executeBatch

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13332564#comment-13332564 ] 

Ramesh Reddy commented on TEIID-4596:
-------------------------------------

Based on http://stackoverflow.com/questions/15684297/how-to-get-generated-keys-from-jdbc-batch-insert-in-oracle looks like this is implementation specific when dealing with the Batch. So, there are no guarantees natively , so I propose we add this limitation to documentation and not do any code changes. 

[~jdurani] This does work in single statement cases right? 

> Teiid does not return genereted keys after executeBatch
> -------------------------------------------------------
>
>                 Key: TEIID-4596
>                 URL: https://issues.jboss.org/browse/TEIID-4596
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Documentation
>            Reporter: Juraj Duráni
>            Assignee: Ramesh Reddy
>            Priority: Minor
>
> Currently, Teiid does not return genereted keys after inserting value using PreparedStatement.executeBatch() method. JDBC ([4.1|http://download.oracle.com/otndocs/jcp/jdbc-4_1-mrel-spec/index.html]) does not require this :
> {quote}
> It is implementation-defined as to whether _getGeneratedKeys_ will return generated values  after invoking the _executeBatch_ method.
> {quote}
> However, it would be nice to have this behavior documented - https://teiid.gitbooks.io/documents/content/client-dev/JDBC_Support.html



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)