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

Getting parameter type metadata are not supported

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.4.0
    • Fix Version/s: N/A
    • Component/s: metadata
    • Labels:
    • Environment:
      linuxamd64

      Description

      1) The jdbc driver: mariadb-java-client-2.4.0.jar
      2) The API query is:
      SELECT A0.`PRICE` FROM `MARIADB_OJOIN_PRODUCTS` A0 WHERE (A0.`PRICE` = :H0 ) AND (A0.`PRICE` IS NOT NULL)
      The query send to jdbc-driver is:
      SELECT A0.`PRICE` FROM `MARIADB_OJOIN_PRODUCTS` A0 WHERE (A0.`PRICE` = ? ) AND (A0.`PRICE` IS NOT NULL)
      3) Driver issue:
      DriverManager.getDriver("jdbc:mariadb://9.30.244.223:3306/testdb")
      getDriver: no suitable driver
      java.sql.SQLException: No suitable driver
      at java.sql.DriverManager.getDriver(DriverManager.java:326)
      at com.ibm.db2.jdbcwrapper.JavaFunc.registerDriverToDriverManager(JavaFunc.java:193)
      SQLException: SQLState(08001)
      registerDriver: org.mariadb.jdbc.Driver@c7f95912
      registerDriver: com.ibm.db2.jdbcwrapper.DelegatingDriver@63f58fd4
      DriverManager.getConnection("jdbc:mariadb://9.30.244.223:3306/testdb")
      trying com.ibm.fluidquery.jdbc.sforce.SForceDriver
      trying com.ibm.db2.jcc.DB2Driver
      skipping: java.sql.DriverInfo
      trying com.ibm.db2.jdbcwrapper.DelegatingDriver
      getConnection returning com.ibm.db2.jdbcwrapper.DelegatingDriver
      DriverManager.getDriver("jdbc:mariadb://9.30.244.223:3306/testdb")
      skipping: org.mariadb.jdbc.Driver
      getDriver returning com.ibm.db2.jdbcwrapper.DelegatingDriver
      DriverManager.getConnection("jdbc:mariadb://9.30.244.223:3306/testdb")
      trying com.ibm.fluidquery.jdbc.sforce.SForceDriver
      trying com.ibm.db2.jcc.DB2Driver
      skipping: java.sql.DriverInfo
      trying com.ibm.db2.jdbcwrapper.DelegatingDriver
      getConnection returning com.ibm.db2.jdbcwrapper.DelegatingDriver
      java.sql.SQLFeatureNotSupportedException: Getting parameter type metadata are not supported
      at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getFeatureNotSupportedException(ExceptionMapper.java:275)
      at org.mariadb.jdbc.MariaDbParameterMetaData.getParameterType(MariaDbParameterMetaData.java:135)
      java.sql.SQLException: Parameter at position 1 is not set
      at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:204)
      at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:157)
      SQLException: SQLState(07004)
      SQLState(07004) vendor code(0)

      Question:
      how can we fix this issue?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              diego dupin Diego Dupin
              Reporter:
              yanlixu Yanli Xu
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.