Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-475

MariaDB ODBC Driver returns "Invalid information type" when asked for SQL_POSITIONED_STATEMENTS. MariaDB Connector/ODBC returns "[ma-3.2.6]Invalid information type".

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.2.6
    • None
    • None
    • None
    • Windows 10 Pro

    Description

      30-Sept-2025 16:02:38 - ERROR - (VerifyDatabaseMetaData.java:validateSupportsPositionedDelete:2992) - *DatabaseMetaData.supportsPositionedDelete failed E:SQLGetInfoLong #SQLGetInfo I:hConnection=2039406711024, infoId=80 [ma-3.2.6]Invalid information type

      /**

      • Determine whether this database supports positioned <code>DELETE</code>
      • statements.
        *
      • JODBCDef.SQL_POSITIONED_STATEMENTS = 80
      • JODBCDef.SQL_PS_POSITIONED_DELETE = 1
        *
      • @return <code>true</code> if so; <code>false</code> otherwise
      • @exception SQLException if a database access error occurs
        */
        @Override
        public boolean supportsPositionedDelete() throws SQLException
        Unknown macro: { if (JODBC.tracer.isTracing()) { String jODBCInfo = "*DatabaseMetaData.supportsPositionedDelete"; JODBC.tracer.trace(jODBCInfo); } int value = getInfo (JODBCDef.SQL_POSITIONED_STATEMENTS); return ((value & JODBCDef.SQL_PS_POSITIONED_DELETE) > 0); }

      boolean validateSupportsPositionedDelete()
      {
      boolean result = true;
      try
      {
      if(iMeta.supportsPositionedDelete())

      { LogManager.getLogger(VerifyDatabaseMetaData.class).info("*DatabaseMetaData.supportsPositionedDelete returned true"); }

      else

      { LogManager.getLogger(VerifyDatabaseMetaData.class).info("*DatabaseMetaData.supportsPositionedDelete returned false"); }

      }
      catch(SQLException ex)
      {
      String state = ex.getSQLState();
      if(state != null && state.equals("IM001"))

      { LogManager.getLogger(VerifyDatabaseMetaData.class).info("*DatabaseMetaData.supportsPositionedDelete not supported I:" + ex.getMessage()); m_NotSupportedCount++; }

      else

      { LogManager.getLogger(VerifyDatabaseMetaData.class).error("*DatabaseMetaData.supportsPositionedDelete failed E:" + ex.getMessage()); result = false; }

      }
      catch(UnsupportedOperationException ue)

      { LogManager.getLogger(VerifyDatabaseMetaData.class).info("*DatabaseMetaData.supportsPositionedDelete not supported I:" + ue.getMessage()); m_NotSupportedCount++; }

      return result;
      }

      SQL_PS_POSITIONED_UPDATE (2) & SQL_PS_SELECT_FOR_UPDATE (4) as well

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            Ian B Ian Beard
            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.