From ac62a4a52bad0f0c5d3b3a0de39893f6993a9f1b Mon Sep 17 00:00:00 2001 From: Patrick Brady Date: Wed, 13 Sep 2017 00:11:21 -0700 Subject: [PATCH] Changing to mariadb java client Changing from the mysql java connector to the mariadb java client. Change-Id: I2f9b1f5da37424d529e196f9b6b8d0bf4f1f9d2f Signed-off-by: Patrick Brady Issue-id: APPC-198 --- .../appc-ansible-adapter-bundle/pom.xml | 9 +++------ .../appc-chef-adapter/appc-chef-adapter-bundle/pom.xml | 9 +++------ .../appc-dmaap-adapter-bundle/pom.xml | 2 +- .../appc-dmaap-adapter/appc-message-adapter-api/pom.xml | 2 +- .../appc-message-adapter-factory/pom.xml | 2 +- .../appc-iaas-adapter/appc-iaas-adapter-bundle/pom.xml | 17 +---------------- .../appc-netconf-adapter-bundle/pom.xml | 4 ++-- .../appc-rest-adapter/appc-rest-adapter-bundle/pom.xml | 13 +++++-------- .../appc-rest-healthcheck-adapter-bundle/pom.xml | 7 ++----- appc-config/appc-encryption-tool/pom.xml | 1 - appc-dg-util/appc-dg-util-bundle/pom.xml | 7 ++----- .../appc-dispatcher-common/appc-data-access-lib/pom.xml | 6 +++++- .../main/java/org/openecomp/appc/dao/util/DBUtils.java | 4 ++-- .../lock-manager-lib/lock-manager-impl/pom.xml | 7 ++----- .../lockmanager/impl/sql/MySqlConnectionFactory.java | 2 +- pom.xml | 7 ++++++- 16 files changed, 37 insertions(+), 62 deletions(-) diff --git a/appc-adapters/appc-ansible-adapter/appc-ansible-adapter-bundle/pom.xml b/appc-adapters/appc-ansible-adapter/appc-ansible-adapter-bundle/pom.xml index 70f76d6f7..cb37c2b5f 100644 --- a/appc-adapters/appc-ansible-adapter/appc-ansible-adapter-bundle/pom.xml +++ b/appc-adapters/appc-ansible-adapter/appc-ansible-adapter-bundle/pom.xml @@ -158,11 +158,8 @@ - mysql - mysql-connector-java - 5.1.31 - jar - compile + org.mariadb.jdbc + mariadb-java-client @@ -201,7 +198,7 @@ org.openecomp.appc.adapter.ansible.AnsibleActivator org.openecomp.appc.adapter.ansible org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,org.slf4j.*, javax.net.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.bind.*,javax.naming.*, javax.security.* - *;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis + *;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis true diff --git a/appc-adapters/appc-chef-adapter/appc-chef-adapter-bundle/pom.xml b/appc-adapters/appc-chef-adapter/appc-chef-adapter-bundle/pom.xml index 4ebbb8dbe..28930ba2d 100644 --- a/appc-adapters/appc-chef-adapter/appc-chef-adapter-bundle/pom.xml +++ b/appc-adapters/appc-chef-adapter/appc-chef-adapter-bundle/pom.xml @@ -189,11 +189,8 @@ - mysql - mysql-connector-java - 5.1.31 - jar - compile + org.mariadb.jdbc + mariadb-java-client @@ -227,7 +224,7 @@ org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.bind.*,javax.naming.* - *;scope=compile|runtime;artifactId=!sli-common|!appc-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis + *;scope=compile|runtime;artifactId=!sli-common|!appc-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis true diff --git a/appc-adapters/appc-dmaap-adapter/appc-dmaap-adapter-bundle/pom.xml b/appc-adapters/appc-dmaap-adapter/appc-dmaap-adapter-bundle/pom.xml index 7824ad598..1a7643b8a 100644 --- a/appc-adapters/appc-dmaap-adapter/appc-dmaap-adapter-bundle/pom.xml +++ b/appc-adapters/appc-dmaap-adapter/appc-dmaap-adapter-bundle/pom.xml @@ -157,7 +157,7 @@ org.openecomp.appc.adapter.messaging.dmaap.AppcDmaapAdapterActivator org.openecomp.appc.adapter.messaging.* !org.slf4j.event,org.openecomp.appc.adapter.message.*,org.openecomp.appc.metricservice.*,com.att.nsa.*,org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,!org.osgi.service.event.*,org.osgi.service.*,org.osgi.util.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.*,javax.naming.*,javax.crypto.*, com.sun.jersey.spi.container.servlet,org.eclipse.jetty.servlets - *;scope=compile|runtime;artifactId=!appc-metric-bundle|appc-message-adapter-api|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|pax-* + *;scope=compile|runtime;artifactId=!appc-metric-bundle|appc-message-adapter-api|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|pax-* true OSGI-INF/blueprint/blueprint.xml diff --git a/appc-adapters/appc-dmaap-adapter/appc-message-adapter-api/pom.xml b/appc-adapters/appc-dmaap-adapter/appc-message-adapter-api/pom.xml index 459f3951b..7932ebebe 100644 --- a/appc-adapters/appc-dmaap-adapter/appc-message-adapter-api/pom.xml +++ b/appc-adapters/appc-dmaap-adapter/appc-message-adapter-api/pom.xml @@ -125,7 +125,7 @@ org.openecomp.appc.metricservice.*,com.att.nsa.*,org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,!org.osgi.service.event.*,org.osgi.service.*,org.osgi.util.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.*,javax.naming.*,javax.crypto.*, com.sun.jersey.spi.container.servlet,org.eclipse.jetty.servlets - *;scope=compile|runtime;artifactId=!appc-metric-bundle|sli-common|sli-provider|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|pax-* + *;scope=compile|runtime;artifactId=!appc-metric-bundle|sli-common|sli-provider|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|pax-* true OSGI-INF/blueprint/blueprint.xml diff --git a/appc-adapters/appc-dmaap-adapter/appc-message-adapter-factory/pom.xml b/appc-adapters/appc-dmaap-adapter/appc-message-adapter-factory/pom.xml index 75640b7e1..cd4c50a44 100644 --- a/appc-adapters/appc-dmaap-adapter/appc-message-adapter-factory/pom.xml +++ b/appc-adapters/appc-dmaap-adapter/appc-message-adapter-factory/pom.xml @@ -134,7 +134,7 @@ org.openecomp.appc.adapter.factory.DmaapMessageAdapterFactoryActivator org.openecomp.appc.adapter.message.MessageAdapterFactory org.openecomp.appc.adapter.messaging.*,org.openecomp.appc.adapter.message.*,org.openecomp.appc.metricservice.*,com.att.nsa.*org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,!org.osgi.service.event.*,org.osgi.service.*,org.osgi.util.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.*,javax.naming.*,javax.crypto.*, com.sun.jersey.spi.container.servlet,org.eclipse.jetty.servlets - *;scope=compile|runtime;artifactId=!appc-metric-bundle|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|pax-* + *;scope=compile|runtime;artifactId=!appc-metric-bundle|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|pax-* true OSGI-INF/blueprint/blueprint.xml diff --git a/appc-adapters/appc-iaas-adapter/appc-iaas-adapter-bundle/pom.xml b/appc-adapters/appc-iaas-adapter/appc-iaas-adapter-bundle/pom.xml index 27a5e5cf1..8b5132ad5 100644 --- a/appc-adapters/appc-iaas-adapter/appc-iaas-adapter-bundle/pom.xml +++ b/appc-adapters/appc-iaas-adapter/appc-iaas-adapter-bundle/pom.xml @@ -171,21 +171,6 @@ - - - - - - - - - - - - - - - @@ -223,7 +208,7 @@ *;scope=compile|runtime;artifactId=!org.eclipse.osgi|slf4j-api|jcl-over-slf4j| - + true diff --git a/appc-adapters/appc-netconf-adapter/appc-netconf-adapter-bundle/pom.xml b/appc-adapters/appc-netconf-adapter/appc-netconf-adapter-bundle/pom.xml index 41af30ae4..4e04166ca 100644 --- a/appc-adapters/appc-netconf-adapter/appc-netconf-adapter-bundle/pom.xml +++ b/appc-adapters/appc-netconf-adapter/appc-netconf-adapter-bundle/pom.xml @@ -169,9 +169,9 @@ org.openecomp.appc.adapter.netconf.AppcNetconfAdapterActivator org.openecomp.appc.adapter.netconf,org.openecomp.appc.adapter.netconf.dao,org.openecomp.appc.adapter.netconf.util,org.openecomp.appc.adapter.netconf.exception - !org.slf4j.event,org.w3c.dom.*,com.sun.org.apache.xerces.*,javax.sql.*,javax.sql.rowset.*,javax.xml.*,org.openecomp.appc.adapter.messaging.*,javax.crypto.*,org.openecomp.appc.common.exception.*,com.mysql.*,org.onap.ccsdk.sli.core.sli.*,org.onap.ccsdk.sli.core.dblib,org.osgi.framework.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.bind.*,javax.naming.* + !org.slf4j.event,org.w3c.dom.*,com.sun.org.apache.xerces.*,javax.sql.*,javax.sql.rowset.*,javax.xml.*,org.openecomp.appc.adapter.messaging.*,javax.crypto.*,org.openecomp.appc.common.exception.*,org.mariadb.*,org.onap.ccsdk.sli.core.sli.*,org.onap.ccsdk.sli.core.dblib,org.osgi.framework.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.bind.*,javax.naming.* - *;scope=compile|runtime;artifactId=!dblib-provider|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|appc-dmaap-adapter-bundle + *;scope=compile|runtime;artifactId=!dblib-provider|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|appc-dmaap-adapter-bundle true diff --git a/appc-adapters/appc-rest-adapter/appc-rest-adapter-bundle/pom.xml b/appc-adapters/appc-rest-adapter/appc-rest-adapter-bundle/pom.xml index 8e26f5fb0..8cce088aa 100644 --- a/appc-adapters/appc-rest-adapter/appc-rest-adapter-bundle/pom.xml +++ b/appc-adapters/appc-rest-adapter/appc-rest-adapter-bundle/pom.xml @@ -164,13 +164,10 @@ jcl-over-slf4j - - mysql - mysql-connector-java - 5.1.31 - jar - compile - + + org.mariadb.jdbc + mariadb-java-client + com.vmware @@ -200,7 +197,7 @@ org.openecomp.appc.adapter.rest.RestActivator org.openecomp.appc.adapter.rest org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,org.slf4j.*,com.vmware.*,org.apache.xerces.*,javax.net.*,javax.net.ssl.*,org.xml.sax.*,javax.xml.bind.*,javax.naming.* - *;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|jaxp-api + *;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|jaxp-api true diff --git a/appc-adapters/appc-rest-healthcheck-adapter/appc-rest-healthcheck-adapter-bundle/pom.xml b/appc-adapters/appc-rest-healthcheck-adapter/appc-rest-healthcheck-adapter-bundle/pom.xml index f45945d5b..a6bfbe6c8 100644 --- a/appc-adapters/appc-rest-healthcheck-adapter/appc-rest-healthcheck-adapter-bundle/pom.xml +++ b/appc-adapters/appc-rest-healthcheck-adapter/appc-rest-healthcheck-adapter-bundle/pom.xml @@ -160,11 +160,8 @@ - mysql - mysql-connector-java - 5.1.31 - jar - compile + org.mariadb.jdbc + mariadb-java-client diff --git a/appc-config/appc-encryption-tool/pom.xml b/appc-config/appc-encryption-tool/pom.xml index 2e8e24419..4fdeacf88 100644 --- a/appc-config/appc-encryption-tool/pom.xml +++ b/appc-config/appc-encryption-tool/pom.xml @@ -17,7 +17,6 @@ ${sdnctl.sli.version} UTF-8 - 5.1.39 diff --git a/appc-dg-util/appc-dg-util-bundle/pom.xml b/appc-dg-util/appc-dg-util-bundle/pom.xml index ec2a6dcc2..17e0b5dab 100644 --- a/appc-dg-util/appc-dg-util-bundle/pom.xml +++ b/appc-dg-util/appc-dg-util-bundle/pom.xml @@ -132,11 +132,8 @@ - mysql - mysql-connector-java - 5.1.31 - jar - compile + org.mariadb.jdbc + mariadb-java-client diff --git a/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/pom.xml b/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/pom.xml index a074f9bcf..c0c77d980 100644 --- a/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/pom.xml +++ b/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/pom.xml @@ -36,6 +36,10 @@ appc-common ${project.version} + + org.mariadb.jdbc + mariadb-java-client + @@ -48,7 +52,7 @@ ${project.artifactId} org.openecomp.appc.dao.util org.openecomp.appc.configuration,*;resolution:=optional - mysql-connector-java + mariadb-java-client true diff --git a/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/main/java/org/openecomp/appc/dao/util/DBUtils.java b/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/main/java/org/openecomp/appc/dao/util/DBUtils.java index 49e424188..c4b788057 100644 --- a/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/main/java/org/openecomp/appc/dao/util/DBUtils.java +++ b/appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/main/java/org/openecomp/appc/dao/util/DBUtils.java @@ -31,7 +31,7 @@ import org.openecomp.appc.configuration.ConfigurationFactory; @Deprecated public class DBUtils { - private static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; + private static final String JDBC_DRIVER = "org.mariadb.jdbc.Driver"; private static final Configuration configuration = ConfigurationFactory.getConfiguration(); static { try { @@ -43,7 +43,7 @@ public class DBUtils { } public static Connection getConnection(String schema) throws SQLException { - DriverManager.registerDriver(new com.mysql.jdbc.Driver()); + DriverManager.registerDriver(new org.mariadb.jdbc.Driver()); String dbURL = configuration.getProperty(String.format("org.openecomp.appc.db.url.%s", schema), ""); String userName = configuration.getProperty(String.format("org.openecomp.appc.db.user.%s", schema), ""); String password = configuration.getProperty(String.format("org.openecomp.appc.db.pass.%s", schema), ""); diff --git a/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/pom.xml b/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/pom.xml index 3c1c483ad..de33fa90a 100644 --- a/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/pom.xml +++ b/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/pom.xml @@ -18,11 +18,8 @@ provided - mysql - mysql-connector-java - ${mysql.connector.version} - jar - provided + org.mariadb.jdbc + mariadb-java-client org.openecomp.appc diff --git a/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/src/main/java/org/openecomp/appc/lockmanager/impl/sql/MySqlConnectionFactory.java b/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/src/main/java/org/openecomp/appc/lockmanager/impl/sql/MySqlConnectionFactory.java index e97a54ba8..c9af310e7 100644 --- a/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/src/main/java/org/openecomp/appc/lockmanager/impl/sql/MySqlConnectionFactory.java +++ b/appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/src/main/java/org/openecomp/appc/lockmanager/impl/sql/MySqlConnectionFactory.java @@ -32,6 +32,6 @@ import org.openecomp.appc.dao.util.DefaultJdbcConnectionFactory; public class MySqlConnectionFactory extends DefaultJdbcConnectionFactory { protected void registedDriver() throws SQLException { - DriverManager.registerDriver(new com.mysql.jdbc.Driver()); + DriverManager.registerDriver(new org.mariadb.jdbc.Driver()); } } diff --git a/pom.xml b/pom.xml index 6729c99bc..4cb12721b 100644 --- a/pom.xml +++ b/pom.xml @@ -64,7 +64,6 @@ ECOMP is a trademark and service mark of AT&T Intellectual Property. 4.4 3.4 4.5.1 - 5.1.39 1.1.1 1.1.0 1.1.13-SNAPSHOT @@ -397,6 +396,12 @@ ECOMP is a trademark and service mark of AT&T Intellectual Property. eelf-core ${eelf.version} + + + org.mariadb.jdbc + mariadb-java-client + 1.2.3 + -- 2.16.6