getGeneratedKeys() is not working after executeBatch() is called

[utenakr]

I need support for getGeneratedKeys() on executeBatch() defined according to the JDBC spec. Our code is shared with other JDBC drivers, and we found our code is not working with MS-SQL Server JDBC.

I try to work around with replacing executeBatch() with executeUpdate(), but I am afraid this will lead to overhead to MS-SQL server. I need to implement getGeneratedKey() after executeBatch() is called with rollback compatibility.

If you have a workaround with my use case, that would be great!

Thank you,
Ji Sun

[v-nisidh]

Thanks @utenakr for reporting this defect. I guess root cause of this is #245

Connect to #245

[utenakr]

I see, thanks for pointing that out @v-nisidh Perhaps, would you let me know if you have a timeline for #245 feature? I would also need #245, too.

Appreciatively,

[xiangyushawn]

Hello @utenakr, it seems like the issue you created is different from #245. Did you get the following error?

The statement must be executed before any results can be obtained.

On JDBC specification it says

It is implementation-defined as to whether getGeneratedKeys will return generated values after invoking the executeBatch method.

This feature is optional and did not implemented in the driver.

I will confirm with our team and see when we can have a timeline for getGeneratedKeys after calling executeBatch method. Will keep you updated. Thanks.