From 1c56dd72fed3dc3acc104563668b9b314e0925bb Mon Sep 17 00:00:00 2001
From: =?utf8?q?Andreas=20M=C3=BCller?= <a.mueller@bgbm.org>
Date: Thu, 28 Jul 2016 15:50:20 +0200
Subject: [PATCH] #5751 Remove explicit dependencies to DB drivers by cdmlib-db
 in poms

---
 eu.etaxonomy.taxeditor.test/pom.xml   | 48 +++++++++++++++------------
 eu.etaxonomy.taxeditor.webapp/pom.xml | 21 ++----------
 pom.xml                               | 11 ------
 3 files changed, 30 insertions(+), 50 deletions(-)

diff --git a/eu.etaxonomy.taxeditor.test/pom.xml b/eu.etaxonomy.taxeditor.test/pom.xml
index f67047a0c..200e91bce 100644
--- a/eu.etaxonomy.taxeditor.test/pom.xml
+++ b/eu.etaxonomy.taxeditor.test/pom.xml
@@ -121,27 +121,33 @@
           <daemon>true</daemon>
         </configuration>
         <dependencies>
-            <dependency>
-            <groupId>com.mchange</groupId>
-            <artifactId>c3p0</artifactId>
-            <!-- 
-              IMPORTANT!!!
-              this must exactly match the version as set in 
-              cdmlib-parent pom.xml
-            -->
-            <version>${c3p0.version}</version>
-          </dependency>
-          <!-- DATABASE DRIVER -->
-          <dependency>
-            <groupId>com.h2database</groupId>
-            <artifactId>h2</artifactId>
-            <version>${h2.version}</version>
-          </dependency>
-          <dependency>
-            <groupId>mysql</groupId>
-            <artifactId>mysql-connector-java</artifactId>
-            <version>${mysql.version}</version>
-          </dependency>
+        	<dependency>
+        	<groupId>eu.etaxonomy</groupId>
+      		<artifactId>cdmlib-db</artifactId>
+      		<version>${cdmlib.version}</version>
+      	</dependency>
+<!--             <dependency> -->
+<!--             <groupId>com.mchange</groupId> -->
+<!--             <artifactId>c3p0</artifactId> -->
+<!--             
+<!--               IMPORTANT!!! -->
+<!--               this must exactly match the version as set in  -->
+<!--               cdmlib-parent pom.xml -->
+<!--             --> -->
+<!--             <version>${c3p0.version}</version> -->
+<!--           </dependency> -->
+<!--           DATABASE DRIVER -->
+<!--           <dependency> -->
+<!--             <groupId>com.h2database</groupId> -->
+<!--             <artifactId>h2</artifactId> -->
+<!--             <version>${h2.version}</version> -->
+<!--           </dependency> -->
+<!--           <dependency> -->
+<!--             <groupId>mysql</groupId> -->
+<!--             <artifactId>mysql-connector-java</artifactId> -->
+<!--             <version>${mysql.version}</version> -->
+<!--           </dependency> -->
+		  <!-- Do we still need this? If yes, should we move it to cdmlib-db? -->
           <dependency>
               <groupId>commons-dbcp</groupId>
               <artifactId>commons-dbcp</artifactId>
diff --git a/eu.etaxonomy.taxeditor.webapp/pom.xml b/eu.etaxonomy.taxeditor.webapp/pom.xml
index 7167552cb..dc67cc892 100644
--- a/eu.etaxonomy.taxeditor.webapp/pom.xml
+++ b/eu.etaxonomy.taxeditor.webapp/pom.xml
@@ -123,25 +123,10 @@
       <type>war</type>
     </dependency>
     <dependency>
-      <groupId>com.h2database</groupId>
-      <artifactId>h2</artifactId>
-      <version>${h2.version}</version>
-    </dependency>
-    <dependency>
-        <groupId>mysql</groupId>
-        <artifactId>mysql-connector-java</artifactId>
-        <version>5.1.24</version>
+      <groupId>eu.etaxonomy</groupId>
+      <artifactId>cdmlib-db</artifactId>
+      <version>${cdmlib.version}</version>
     </dependency>
-     <dependency>
-      <groupId>com.mchange</groupId>
-      <artifactId>c3p0</artifactId>
-      <version>${c3p0.version}</version>
-     </dependency>
-     <dependency>
-        <groupId>com.mchange</groupId>
-        <artifactId>mchange-commons-java</artifactId>
-        <version>${mchange-commons-java.version}</version>
-     </dependency>
      <dependency>
         <groupId>log4j</groupId>
         <artifactId>log4j</artifactId>
diff --git a/pom.xml b/pom.xml
index ff8151e55..b57c6c628 100644
--- a/pom.xml
+++ b/pom.xml
@@ -25,17 +25,6 @@
     <update.dir>snapshot</update.dir>
     <unitils.version>3.4.2</unitils.version>
     <log4j.version>1.2.17</log4j.version>
-    <!-- data base driver related properties -->
-    <mysql.version>5.1.38</mysql.version>
-    <h2.version>1.4.190</h2.version>
-    <!-- 
-      IMPORTANT!!!
-      c3p0.version must exactly match the version as 
-      set in cdmlib-parent pom.xml
-    -->
-    <c3p0.version>0.9.5.2</c3p0.version>
-    <!-- mchange-commons-java needs to match the version as defined in the c3p0/pom.xml -->
-    <mchange-commons-java.version>0.2.11</mchange-commons-java.version>
   </properties>
   <modules>
     <module>eu.etaxonomy.taxeditor.cdmlib</module>
-- 
2.30.2