Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-8046160

JEP 170: JDBC 4.2

    XMLWordPrintable

    Details

    • Type: JEP
    • Status: Closed
    • Priority: P4
    • Resolution: Delivered
    • Fix Version/s: 8
    • Component/s: core-libs
    • Labels:
      None
    • Author:
      Lance Andersen
    • JEP Type:
      Feature
    • Exposure:
      Open
    • Scope:
      SE
    • JSR:
      114 MR, 221 MR
    • Discussion:
      jdbc dash spec dash discuss at openjdk dot java dot net
    • Effort:
      S
    • Duration:
      S
    • JEP Number:
      170

      Description

      Summary

      Minor enhancements to JDBC to improve usability and portability

      Motivation

      Improve the ability to leverage new data types and continue to make improvements in areas that have been requested by JDBC application programmers and driver vendors.

      Description

      Changes under consideration for JDBC 4.2 include:

      • Add a generic setter/update method to ResultSet, PreparedStatement, and CallableStatement to support new data types such as those being defined in JSR 310.

      • Define REF_CURSOR support for CallableStatement.

      • Specify required DataSource properties for a Java EE environment.

      • Enhance DatabaseMetaData.getIndexInfo to provide new columns for CARDINALITY and PAGES which return a long value.

      • Add a new DatabaseMeta method to return the logical maximum size for a LOB.

      • Additional clean up of the spec as needed.

      Testing

      Changes will be mostly additions to existing interfaces.

      The JCK will need to tests added for any concrete methods/classes, e.g., PreparedStatement.setObject(int pos, Object val, SQLType type).

      Risks and Assumptions

      The primary risk of this change is that any change affecting method type-inference has the potential for backwards incompatibility.

      Dependences

      JSR 310, the new Date and Time API ( JEP 150 ).

      Impact

      • Compatibility: Minimal - Additional methods will be added to existing interfaces, but that only affects JDBC drivers. Existing JDBC applications will continue to run unmodified.

      • Documentation: Additional updates to the spec and the javadoc spec

      • JCP: A Maintenance Release of JSR 221, as done for JDBC 4.1, with a 30-day review period

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              lancea Lance Andersen
              Reporter:
              lancea Lance Andersen
              Owner:
              Lance Andersen Lance Andersen
              Endorsed By:
              Mark Reinhold
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: