Implement JDBC 4.1 getObject

[marschall]

The driver currently lacks critical JDBC 4.1 methods. Most notably:

• ResultSet#getObject(int,Class)
• ResultSet#getObject(String,Class)
• CallableStatement#getObject(int,Class)
• CallableStatement#getObject(String,Class)

These limitations make it impossible to retrieve Java 8 Date and Time API data types.

[ajlam]

@marschall - would require adding new APIs. Filing as an enhancement and for follow-up investigation.

[marschall]

I don't see this as an enhancement but as a compliance issue. These are existing JDBC 4.1 APIs. I do not see how you can claim compliance yet do not implement these APIs.

[ajlam]

@marschall - I am not 100% well versed with the JDBC 4.1 API. We are following up to understand if the APIs you mentioned above are completely required for JDBC 4.1 compliance.

[v-mabarw]

@marschall @ajlam The JDBC specification identifies features that are required for compliance as well as enhancements that are considered optional. I've confirmed that the getObject methods mentioned here fall under the optional category (if you want more detail, you can refer to Chapter 6 in the 4.1 specification)

[marschall]

@v-mabarw I see, chapter 6.3, you are correct. You may want to delete these comments as they are all in optional methods (and contain a typo).

[v-mabarw]

@marschall Thanks for pointing out those comments, we'll update them & fix the typo.

Am I correct in understanding that you are still looking for those APIs to be implemented?

[marschall]

@v-mabarw yes, I would still like to see these methods implemented. The main reason being that these methods are the only way to use Java 8 Date and Time types.

[xiangyushawn]

Thank you @marschall the PR is merged now. We very appreciate your contribution!