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

Getting parameter type metadata are not supported

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 2.4.0
    • N/A
    • metadata
    • 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

              diego dupin Diego Dupin
              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.