[ https://issues.jboss.org/browse/TEIID-4596?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4596: ------------------------------------- [~rareddy], the simplest test could look like follows: {code:sql|title=MySQL55 Create table command} CREATE TABLE ag (id integer AUTO_INCREMENT PRIMARY KEY, name varchar(10)) {code} {code:sql|title=VDB DDL metadata} CREATE FOREIGN TABLE ag (id integer PRIMARY KEY, name string) OPTIONS (UPDATABLE 'TRUE'); {code} {code:java|title=Test} Connection con = ...; // connect to your VDB PreparedStatement ps = con.prepareStatement("INSERT INTO ag (name) VALUES (?)", Statement.RETURN_GENERATED_KEYS); ps.setString(1, "name1"); ps.addBatch(); ps.setString(1, "name2"); ps.addBatch(); ps.setString(1, "name3"); ps.addBatch(); LOG.info("{}", ps.executeBatch()); ResultSet rs = ps.getGeneratedKeys(); // print the result set {code} Result of such test looks like: {code:plain} 08:15:12.676 [main] INFO sandbox.MainClass - [1, 1, 1] --- result set start --- columns: --- result set end --- {code} This behavior is hardcoded in StatementImpl [here|https://github.com/teiid/teiid/blob/15a1ec932cf54def24805de8b360d05e...] and [here|https://github.com/teiid/teiid/blob/15a1ec932cf54def24805de8b360d05e...]. -- This message was sent by Atlassian JIRA (v7.2.3#72005)