Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
2.4.0
-
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
- is blocked by
-
MDEV-15031 Parameter metadata
- Open