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

support MariaDB 12.3 XML data type.

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 3.6
    • None
    • None

    Description

      MariaDB 12.3 introduced a native XML column type with MDEV-37261.
      Currently, Connector/J does not recognize this type and falls back to treating it as a plain String (mapped to Types.LONGVARCHAR or similar). This means ResultSetMetaData.getColumnType() does not return Types.SQLXML and ResultSet.getSQLXML() is not usable in a spec-compliant way.

      Expected behavior:

      ResultSetMetaData.getColumnTypeName() should return "XML" for XML columns.
      ResultSetMetaData.getColumnType() should return java.sql.Types.SQLXML (type code 2009).
      ResultSet.getSQLXML(int/String) should return a valid java.sql.SQLXML instance backed by the column value.
      PreparedStatement.setSQLXML(int, SQLXML) should correctly bind XML values when inserting or updating XML columns.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Git Integration

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