Description of problem:
Currently in RHEL 7.6 the mysql connector for java is in version : 5.1.25 in channel rhel-x86_64-server-7
The same connector by Oracle is 8.0.13.
We would have the opportunity to use a more recent connector from the RHEL base, for easily maintenance and updates.
Is it possible to have a newer mysql connector for java in RHEL ?
Version-Release number of selected component (if applicable):
Steps to Reproduce:
- Install a RHEL 7.6 with mysql-connector-java
- Install Artifactory 6.6.0 for RHEL by following the procédure => Artifactory starts
- Upgrade Artifactory to 6.6.1 with yum update => Artifactory will not start, and in the log file you will have the java error
It seems the function missing in the current version of this connector in RHEL 7 is this one :
2018-12-27 15:30:22 [ARTIFACTORY] [ERROR] Failed to ensure db table 'master_key_status' exists: : java.sql.SQLFeatureNotSupportedException: Not supported
The way we request it via the code is:
Error in file
Hello, unfortunately rebase is problematic, see https://bugzilla.redhat.com/show_bug.cgi?id=1647175#c1
Connector 8.0.15 requires a lot of dependencies not available in RHEL7.
We are preparing mariadb connector as a replacement in collections.
Is it usable for you?
The package mariadb Java client is now available in the RHSCL repository, it can be installed this way:
# yum-config-manager --enable rhel-server-rhscl-7-rpms
# yum install rh-mariadb103-mariadb-java-client
This JDBC driver works fine with both, MariaDB and MySQL servers.
As written in comment #2, this is the best we could do for the customers who need a recent version of the JDBC driver for MySQL/MariaDB. Is it ok to close the ticket now?
1) (Why) Couldn't we have had at least at more recent v5.1.x (like 5.1.47) in centos7 ?!
I did some proper research for the Cloudera community, which needed at least v5.1.26, more infos here (and links below):
2) >Connector 8.0.15 requires a lot of dependencies not available in RHEL7.
The 8.0.16 (or 8.0.15) that I found (link below) only required openjdk-8 (which can be easily deployed, fortunatelly, without the need for any extra yum repo).
And even for people that somehow need to stay with an (open)jdk-7, I found a working rpm , which is from Fedora however (but it flawlessly installed on centos7 and it worked).
Finally here the many working RPMs, even if not officially proposed by RH, they just work :)
* With Java >=v8, I recommend following:
RPM: yum install http://repo.mysql.com/yum/mysql-connectors-community/el/7/i386//mysql-connector-java-8.0.16-1.el7.noarch.rpm
* With Java v7 you can try the latest 5.1.x from Fedora:
* Find RPMs for other distros: https://pkgs.org/download/mysql-connector-java
In official repositories all Java libraries should run with JRE 7 and should not use bundled libraries.
MySQL JDBC 8.x does not support JDK 7 neither JRE 7, so I cant build it with JDK 8 for JRE 7 to meet expectations.
MySQL JDBC 5.x added build dependencies that are not in repositories, this is why we cant update even 5.x version.
The dependencies are build dependencies instead of runtime ones. This is why you can download and use built driver from internet and they bundle them into source code so you cannot see it in maven central package details.