Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-899

Support UUID Object

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.1.0
    • Other
    • None

    Description

      Support UUID objects
      This means supporting PreparedStatement.setObject() with UUID object,
      and resultset.getObject() returning UUID object by default.
      Resultset metadata will change accordingly

      An option to keep default as String must be provided to ensure compatibility.

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-4958 Adding datatype UUID

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONJ-1001 For UUID column, the type name in metadata should not be CHAR

          • Major - Major loss of function.
          • Closed

          Activity

            diego dupin Diego Dupin added a comment - - edited

            getter and setter can now pass UUID parameter (i.e. setObject(index, <UUID class>) / getObject(index, UUID.class)

            Resultset.getObject without class or type precision will now return UUID object for UUID fields by default
            Metadata for UUID columns (MariaDB 10.7 and later) will now return
            ResultSetMetaData.getColumnTypeName(index) => "uuid"
            ResultSetMetaData.getColumnClassName(index) => "java.util.UUID"
            ResultSetMetaData.getColumnType(index) => Types.OTHER
            replacing :
            ResultSetMetaData.getColumnTypeName(index) => "CHAR"
            ResultSetMetaData.getColumnClassName(index) => "java.lang.String"
            ResultSetMetaData.getColumnType(index) => Types.CHAR

            for compatibility, a new option `uuidAsString` permit to consider UUID as String like previously

            result tested with hibernate 6.2.0 (btw, PR submitted https://github.com/hibernate/hibernate-orm/pull/5506)

            diego dupin Diego Dupin added a comment - - edited getter and setter can now pass UUID parameter (i.e. setObject(index, <UUID class>) / getObject(index, UUID.class) Resultset.getObject without class or type precision will now return UUID object for UUID fields by default Metadata for UUID columns (MariaDB 10.7 and later) will now return ResultSetMetaData.getColumnTypeName(index) => "uuid" ResultSetMetaData.getColumnClassName(index) => "java.util.UUID" ResultSetMetaData.getColumnType(index) => Types.OTHER replacing : ResultSetMetaData.getColumnTypeName(index) => "CHAR" ResultSetMetaData.getColumnClassName(index) => "java.lang.String" ResultSetMetaData.getColumnType(index) => Types.CHAR for compatibility, a new option `uuidAsString` permit to consider UUID as String like previously result tested with hibernate 6.2.0 (btw, PR submitted https://github.com/hibernate/hibernate-orm/pull/5506 )

            People

              diego dupin Diego Dupin
              diego dupin Diego Dupin
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.