Review Board 1.7.22


SQOOP-908 Sqoop2 integration: Create MySQL and PostgreSQL database providers

Review Request #9579 - Created Feb. 25, 2013 and submitted

Jarek Cecho
SQOOP-908
Reviewers
Sqoop
sqoop-sqoop2
I've provided MySQL and PostgreSQL Database providers that can be used in the POC test case.
To use PostgreSQL provider run:

mvn clean integration-test -Dsqoop.provider.postgresql.jdbc=jdbc:postgresql://postgresql/sqoop -Dsqoop.provider.class=org.apache.sqoop.test.db.PostgreSQLProvider -Dsqoop.provider.postgresql.username=sqoop -Dsqoop.provider.postgresql.password=sqoop

To run MySQL provider run:

mvn clean integration-test -Dsqoop.provider.mysql.jdbc=jdbc:mysql://mysql/sqoop -Dsqoop.provider.class=org.apache.sqoop.test.db.MySQLProvider -Dsqoop.provider.mysql.username=sqoop -Dsqoop.provider.mysql.password=sqoop
pom.xml
Revision b5694730c4a8bd90a692ca3d44fbb6870abbf99e New Change
[20] 103 lines
[+20]
104
    <servlet.version>2.5</servlet.version>
104
    <servlet.version>2.5</servlet.version>
105
    <cargo.version>1.3.2</cargo.version>
105
    <cargo.version>1.3.2</cargo.version>
106
    <tomcat.major.version>6</tomcat.major.version>
106
    <tomcat.major.version>6</tomcat.major.version>
107
    <tomcat.minor.version>0.36</tomcat.minor.version>
107
    <tomcat.minor.version>0.36</tomcat.minor.version>
108
    <tomcat.version>${tomcat.major.version}.${tomcat.minor.version}</tomcat.version>
108
    <tomcat.version>${tomcat.major.version}.${tomcat.minor.version}</tomcat.version>

    
   
109
    <jdbc.mysql.version>5.1.23</jdbc.mysql.version>

    
   
110
    <jdbc.postgresql.version>9.1-901.jdbc4</jdbc.postgresql.version>
109
  </properties>
111
  </properties>
110

    
   
112

   
111
  <dependencies>
113
  <dependencies>
112
    <dependency>
114
    <dependency>
113
      <groupId>log4j</groupId>
115
      <groupId>log4j</groupId>
[+20] [20] 234 lines
[+20]
348
      <dependency>
350
      <dependency>
349
        <groupId>org.codehaus.cargo</groupId>
351
        <groupId>org.codehaus.cargo</groupId>
350
        <artifactId>cargo-core-container-tomcat</artifactId>
352
        <artifactId>cargo-core-container-tomcat</artifactId>
351
        <version>${cargo.version}</version>
353
        <version>${cargo.version}</version>
352
      </dependency>
354
      </dependency>

    
   
355
      <dependency>

    
   
356
        <groupId>mysql</groupId>

    
   
357
        <artifactId>mysql-connector-java</artifactId>

    
   
358
        <version>${jdbc.mysql.version}</version>

    
   
359
      </dependency>

    
   
360
      <dependency>

    
   
361
        <groupId>postgresql</groupId>

    
   
362
        <artifactId>postgresql</artifactId>

    
   
363
        <version>${jdbc.postgresql.version}</version>

    
   
364
      </dependency>
353
   </dependencies>
365
   </dependencies>
354
  </dependencyManagement>
366
  </dependencyManagement>
355

    
   
367

   
356
  <modules>
368
  <modules>
357
    <module>common</module>
369
    <module>common</module>
[+20] [20] 250 lines
test/pom.xml
Revision fe47ff755f0943a9408dbdb85a358880550fd7d8 New Change
 
test/src/main/java/org/apache/sqoop/test/db/DatabaseProvider.java
Revision 364ff61017d0d6a561cbb9d7adfb8c6a287fd03e New Change
 
test/src/main/java/org/apache/sqoop/test/db/DatabaseProviderFactory.java
New File
 
test/src/main/java/org/apache/sqoop/test/db/DerbyProvider.java
Revision 402fab977ce56ce2636c43dba00d81787fcc001a New Change
 
test/src/main/java/org/apache/sqoop/test/db/MySQLProvider.java
New File
 
test/src/main/java/org/apache/sqoop/test/db/PostgreSQLProvider.java
New File
 
test/src/main/java/org/apache/sqoop/test/minicluster/TomcatSqoopMiniCluster.java
Revision ed6c59663d62603983e270feeb602e5a6128d610 New Change
 
test/src/test/java/org/apache/sqoop/integration/TomcatTestCase.java
Revision 7c8a9781097e73e34555f79428362fcc0cc529c1 New Change
 
test/src/test/java/org/apache/sqoop/integration/connector/ConnectorTestCase.java
Revision 595810fde5db50f45740080b9e4df244ec525e4f New Change
 
test/src/test/java/org/apache/sqoop/integration/connector/jdbc/generic/TableImportTest.java
Revision 3a8b1b5593b6a233cc2d04f3733385133b280768 New Change
 
  1. pom.xml: Loading...
  2. test/pom.xml: Loading...
  3. test/src/main/java/org/apache/sqoop/test/db/DatabaseProvider.java: Loading...
  4. test/src/main/java/org/apache/sqoop/test/db/DatabaseProviderFactory.java: Loading...
  5. test/src/main/java/org/apache/sqoop/test/db/DerbyProvider.java: Loading...
  6. test/src/main/java/org/apache/sqoop/test/db/MySQLProvider.java: Loading...
  7. test/src/main/java/org/apache/sqoop/test/db/PostgreSQLProvider.java: Loading...
  8. test/src/main/java/org/apache/sqoop/test/minicluster/TomcatSqoopMiniCluster.java: Loading...
  9. test/src/test/java/org/apache/sqoop/integration/TomcatTestCase.java: Loading...
  10. test/src/test/java/org/apache/sqoop/integration/connector/ConnectorTestCase.java: Loading...
  11. test/src/test/java/org/apache/sqoop/integration/connector/jdbc/generic/TableImportTest.java: Loading...