Changing to mariadb java client 09/12109/4
authorPatrick Brady <pb071s@att.com>
Wed, 13 Sep 2017 07:11:21 +0000 (00:11 -0700)
committerPatrick Brady <pb071s@att.com>
Fri, 15 Sep 2017 06:32:10 +0000 (06:32 +0000)
Changing from the mysql java connector to the
mariadb java client.

Change-Id: I2f9b1f5da37424d529e196f9b6b8d0bf4f1f9d2f
Signed-off-by: Patrick Brady <pb071s@att.com>
Issue-id: APPC-198

16 files changed:
appc-adapters/appc-ansible-adapter/appc-ansible-adapter-bundle/pom.xml
appc-adapters/appc-chef-adapter/appc-chef-adapter-bundle/pom.xml
appc-adapters/appc-dmaap-adapter/appc-dmaap-adapter-bundle/pom.xml
appc-adapters/appc-dmaap-adapter/appc-message-adapter-api/pom.xml
appc-adapters/appc-dmaap-adapter/appc-message-adapter-factory/pom.xml
appc-adapters/appc-iaas-adapter/appc-iaas-adapter-bundle/pom.xml
appc-adapters/appc-netconf-adapter/appc-netconf-adapter-bundle/pom.xml
appc-adapters/appc-rest-adapter/appc-rest-adapter-bundle/pom.xml
appc-adapters/appc-rest-healthcheck-adapter/appc-rest-healthcheck-adapter-bundle/pom.xml
appc-config/appc-encryption-tool/pom.xml
appc-dg-util/appc-dg-util-bundle/pom.xml
appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/pom.xml
appc-dispatcher/appc-dispatcher-common/appc-data-access-lib/src/main/java/org/openecomp/appc/dao/util/DBUtils.java
appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/pom.xml
appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/src/main/java/org/openecomp/appc/lockmanager/impl/sql/MySqlConnectionFactory.java
pom.xml

index 70f76d6..cb37c2b 100644 (file)
                </dependency>
 
                <dependency>
-                       <groupId>mysql</groupId>
-                       <artifactId>mysql-connector-java</artifactId>
-                       <version>5.1.31</version>
-                       <type>jar</type>
-                       <scope>compile</scope>
+                       <groupId>org.mariadb.jdbc</groupId>
+                       <artifactId>mariadb-java-client</artifactId>
                </dependency>
 
                 <dependency>
                                                <Bundle-Activator>org.openecomp.appc.adapter.ansible.AnsibleActivator</Bundle-Activator>
                                                <Export-Package>org.openecomp.appc.adapter.ansible</Export-Package>
                                                <Import-Package>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.*</Import-Package>
-                                               <Embed-Dependency>*;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis</Embed-Dependency>
+                                               <Embed-Dependency>*;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis</Embed-Dependency>
                                                <Embed-Transitive>true</Embed-Transitive>
                                        </instructions>
                                </configuration>
index 4ebbb8d..28930ba 100644 (file)
         </dependency>
 
         <dependency>
-            <groupId>mysql</groupId>
-            <artifactId>mysql-connector-java</artifactId>
-            <version>5.1.31</version>
-            <type>jar</type>
-            <scope>compile</scope>
+            <groupId>org.mariadb.jdbc</groupId>
+            <artifactId>mariadb-java-client</artifactId>
         </dependency>
 
         <dependency>
                             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.*
                         </Import-Package>
                         <Embed-Dependency>
-                            *;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
                         </Embed-Dependency>
                         <Embed-Transitive>true</Embed-Transitive>
                     </instructions>
index 7824ad5..1a7643b 100644 (file)
                                                <Bundle-Activator>org.openecomp.appc.adapter.messaging.dmaap.AppcDmaapAdapterActivator</Bundle-Activator>
                                                <Export-Package>org.openecomp.appc.adapter.messaging.*</Export-Package>
                                                <Import-Package>!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</Import-Package>
-                                               <Embed-Dependency>*;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-*</Embed-Dependency>
+                                               <Embed-Dependency>*;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-*</Embed-Dependency>
                                                <Embed-Transitive>true</Embed-Transitive>
                                                <Bundle-Blueprint>OSGI-INF/blueprint/blueprint.xml</Bundle-Blueprint>
                                        </instructions>
index 459f395..7932ebe 100644 (file)
                                                <!--<Export-Serice>org.openecomp.appc.adapter.message.EventSender</Export-Serice>-->
                                                <Import-Package>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</Import-Package>
                                                <!--<Embed-Dependency>appc-common</Embed-Dependency>-->
-                                               <Embed-Dependency>*;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-*</Embed-Dependency>
+                                               <Embed-Dependency>*;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-*</Embed-Dependency>
                                                <Embed-Transitive>true</Embed-Transitive>
                                                <Bundle-Blueprint>OSGI-INF/blueprint/blueprint.xml</Bundle-Blueprint>
                                        </instructions>
index 75640b7..cd4c50a 100644 (file)
                                                <Bundle-Activator>org.openecomp.appc.adapter.factory.DmaapMessageAdapterFactoryActivator</Bundle-Activator>
                                                <Export-Service>org.openecomp.appc.adapter.message.MessageAdapterFactory</Export-Service>
                                                <Import-Package>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</Import-Package>
-                                               <Embed-Dependency>*;scope=compile|runtime;artifactId=!appc-metric-bundle|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|pax-*</Embed-Dependency>
+                                               <Embed-Dependency>*;scope=compile|runtime;artifactId=!appc-metric-bundle|sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|pax-*</Embed-Dependency>
                                                <Embed-Transitive>true</Embed-Transitive>
                                                <Bundle-Blueprint>OSGI-INF/blueprint/blueprint.xml</Bundle-Blueprint>
                                        </instructions>
index 27a5e5c..8b5132a 100644 (file)
 <!--                   <artifactId>jcl-over-slf4j</artifactId> -->
 <!--                   </dependency> -->
 
-<!--           <dependency> -->
-<!--                   <groupId>mysql</groupId> -->
-<!--                   <artifactId>mysql-connector-java</artifactId> -->
-<!--                   <version>5.1.31</version> -->
-<!--                   <type>jar</type> -->
-<!--                   <scope>compile</scope> -->
-<!--           </dependency> -->
-
-<!--           <dependency> -->
-<!--                   <groupId>com.vmware</groupId> -->
-<!--                   <artifactId>vijava</artifactId> -->
-<!--                   <version>5.1</version> -->
-<!--                   <scope>compile</scope> -->
-<!--           </dependency> -->
-
 <!--           <dependency> -->
 <!--                   <groupId>xerces</groupId> -->
 <!--                   <artifactId>xerces</artifactId> -->
 <!--                         <Import-Package>org.onap.ccsdk.sli.core.sli.*,org.osgi.framework.*,org.slf4j.*,javax.ws.rs.*,javax.net.*,javax.xml.*,org.xml.*</Import-Package> -->
 <!--                                           <Import-Package>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.*,javax.xml.*</Import-Package> -->
                         <Embed-Dependency>*;scope=compile|runtime;artifactId=!org.eclipse.osgi|slf4j-api|jcl-over-slf4j|</Embed-Dependency>
-<!--                                           <Embed-Dependency>*;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis</Embed-Dependency> -->
+<!--                                           <Embed-Dependency>*;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis</Embed-Dependency> -->
                                                <Embed-Transitive>true</Embed-Transitive>
                                        </instructions>
                                </configuration>
index 41af30a..4e04166 100644 (file)
                         <Bundle-Activator>org.openecomp.appc.adapter.netconf.AppcNetconfAdapterActivator</Bundle-Activator>
                         <Export-Package>org.openecomp.appc.adapter.netconf,org.openecomp.appc.adapter.netconf.dao,org.openecomp.appc.adapter.netconf.util,org.openecomp.appc.adapter.netconf.exception</Export-Package>
                         <Import-Package>
-                            !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.*
                         </Import-Package>
-                        <Embed-Dependency>*;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</Embed-Dependency>
+                        <Embed-Dependency>*;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</Embed-Dependency>
                         <Embed-Transitive>true</Embed-Transitive>
                     </instructions>
 
index 8e26f5f..8cce088 100644 (file)
                        <artifactId>jcl-over-slf4j</artifactId>
                        </dependency>
 
-               <dependency>
-                       <groupId>mysql</groupId>
-                       <artifactId>mysql-connector-java</artifactId>
-                       <version>5.1.31</version>
-                       <type>jar</type>
-                       <scope>compile</scope>
-               </dependency>
+                       <dependency>
+                               <groupId>org.mariadb.jdbc</groupId>
+                               <artifactId>mariadb-java-client</artifactId>
+                       </dependency>
 
                <dependency>
                        <groupId>com.vmware</groupId>
                                                <Bundle-Activator>org.openecomp.appc.adapter.rest.RestActivator</Bundle-Activator>
                                                <Export-Package>org.openecomp.appc.adapter.rest</Export-Package>
                                                <Import-Package>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.*</Import-Package>
-                                               <Embed-Dependency>*;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mysql-connector-java|xml-apis|jaxp-api</Embed-Dependency>
+                                               <Embed-Dependency>*;scope=compile|runtime;artifactId=!sli-common|org.eclipse.osgi|slf4j-api|jcl-over-slf4j|mariadb-java-client|xml-apis|jaxp-api</Embed-Dependency>
                                                <Embed-Transitive>true</Embed-Transitive>
                                        </instructions>
                                </configuration>
index f45945d..a6bfbe6 100644 (file)
                </dependency>
 
                <dependency>
-                       <groupId>mysql</groupId>
-                       <artifactId>mysql-connector-java</artifactId>
-                       <version>5.1.31</version>
-                       <type>jar</type>
-                       <scope>compile</scope>
+            <groupId>org.mariadb.jdbc</groupId>
+                       <artifactId>mariadb-java-client</artifactId>
                </dependency>
 
                <dependency>
index 2e8e244..4fdeacf 100644 (file)
@@ -17,7 +17,6 @@
     <properties>
         <sdnctl.sql.resource.version>${sdnctl.sli.version}</sdnctl.sql.resource.version>
         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
-        <mysql.connector.version>5.1.39</mysql.connector.version>
     </properties>
 
     <dependencyManagement>
index ec2a6dc..17e0b5d 100644 (file)
                </dependency>
 
                <dependency>
-                       <groupId>mysql</groupId>
-                       <artifactId>mysql-connector-java</artifactId>
-                       <version>5.1.31</version>
-                       <type>jar</type>
-                       <scope>compile</scope>
+                       <groupId>org.mariadb.jdbc</groupId>
+                       <artifactId>mariadb-java-client</artifactId>
                </dependency>
 
                <dependency>
index a074f9b..c0c77d9 100644 (file)
           <artifactId>appc-common</artifactId>
           <version>${project.version}</version>
       </dependency>
+      <dependency>
+          <groupId>org.mariadb.jdbc</groupId>
+          <artifactId>mariadb-java-client</artifactId>
+      </dependency>
   </dependencies>
   <build>
     <plugins>
@@ -48,7 +52,7 @@
                     <Bundle-SymbolicName>${project.artifactId}</Bundle-SymbolicName>
                     <Export-Package>org.openecomp.appc.dao.util</Export-Package>
                     <Import-Package>org.openecomp.appc.configuration,*;resolution:=optional</Import-Package>
-                    <Embed-Dependency>mysql-connector-java</Embed-Dependency>
+                    <Embed-Dependency>mariadb-java-client</Embed-Dependency>
                     <Embed-Transitive>true</Embed-Transitive>
                 </instructions>
             </configuration>
index 49e4241..c4b7880 100644 (file)
@@ -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), "");
index 3c1c483..de33fa9 100644 (file)
             <scope>provided</scope>
         </dependency>
         <dependency>
-            <groupId>mysql</groupId>
-            <artifactId>mysql-connector-java</artifactId>
-            <version>${mysql.connector.version}</version>
-            <type>jar</type>
-            <scope>provided</scope>
+            <groupId>org.mariadb.jdbc</groupId>
+            <artifactId>mariadb-java-client</artifactId>
         </dependency>
         <dependency>
             <groupId>org.openecomp.appc</groupId>
index e97a54b..c9af310 100644 (file)
@@ -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 6729c99..4cb1272 100644 (file)
--- a/pom.xml
+++ b/pom.xml
@@ -64,7 +64,6 @@ ECOMP is a trademark and service mark of AT&T Intellectual Property.
         <apache.httpcomponents.version>4.4</apache.httpcomponents.version>
         <commons.lang3.version>3.4</commons.lang3.version>
         <antlr.version>4.5.1</antlr.version>
-        <mysql.connector.version>5.1.39</mysql.connector.version>
         <logback.version>1.1.1</logback.version>
         <toscalib.version>1.1.0</toscalib.version>
         <sdc-client.version>1.1.13-SNAPSHOT</sdc-client.version>
@@ -397,6 +396,12 @@ ECOMP is a trademark and service mark of AT&T Intellectual Property.
                 <artifactId>eelf-core</artifactId>
                 <version>${eelf.version}</version>
             </dependency>
+            <!-- Maria DB -->
+            <dependency>
+                <groupId>org.mariadb.jdbc</groupId>
+                <artifactId>mariadb-java-client</artifactId>
+                <version>1.2.3</version>
+            </dependency>
         </dependencies>
     </dependencyManagement>