[CONJ-749] Getting parameter type metadata are not supported Created: 2019-11-28  Updated: 2020-01-27  Resolved: 2020-01-27

Status: Closed
Project: MariaDB Connector/J
Component/s: metadata
Affects Version/s: 2.4.0
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Yanli Xu Assignee: Diego Dupin
Resolution: Duplicate Votes: 0
Labels: tests
Environment:

linuxamd64

Issue Links:
Blocks
is blocked by MDEV-15031 Parameter metadata Open

 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?

 Comments   
Comment by Diego Dupin [ 2019-12-03 ]

MariaDB/MySQL Servers doesn't provide those information on connectors.
See related issue on server : MDEV-15031

Comment by Diego Dupin [ 2020-01-27 ]

Closing since issue is https://jira.mariadb.org/browse/MDEV-15031.

Generated at Thu Feb 08 03:18:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.