getHoldability() and getResultSetHoldability() return different results about aws-mysql-jdbc HOT 2 CLOSED

Hi @dwenking,

Thanks for reaching out and raising this issue.

We'll take a look at this and keep you updated as we investigate.

Thank you for your patience!

from aws-mysql-jdbc.

Hi @dwenking,

After some consideration, we've decided we will not be implementing a fix for this issue.

Looking at the code, the default holdability value is HOLD_CURSORS_OVER_COMMIT and CLOSE_CURSORS_AT_COMMIT does not seem to be supported. Some getHoldability or getResultSetHoldability methods return constant values, and others throw an exception. To make these methods consistent, the potential solutions would be:

1. to have all get holdability methods return HOLD_CURSORS_OVER_COMMIT, as that is the default value.
2. to have all get holdability methods throw an exception, as is done in the ResultSetImpl and UpdatableResultSet classes.

The AWS JDBC Driver for MySQL is based on the MySQL Connector/J driver and we would like to remain as consistent with it as possible. Therefore, it is difficult for us to determine which approach to take as we would be changing which methods automatically throw exceptions. In this case, we will defer to the existing code and leave it as-is.

This issue will be closed, but please feel free to reach out again if you have other questions. Thank you!

from aws-mysql-jdbc.