[jira] [Commented] (SQOOP-3216) Expanded Metastore support for MySql, Oracle, Postgresql, MSSql, and DB2

["Sandish Kumar HN (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SQOOP-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16189699#comment-16189699 ] 

Sandish Kumar HN commented on SQOOP-3216:
-----------------------------------------

Hi [~BoglarkaEgyed] & [~zach.berkowitz]
did we remove this option?:
<property>
    <name>sqoop.metastore.client.enable.autoconnect</name>
    <value>false</value>
    <description>If true, Sqoop will connect to a local metastore
      for job management when no other metastore arguments are
      provided.
    </description>
  </property>

now it's not reading anything from sqoop-site.xml by default it takes default hsql DB. Irrespective of what you have specified in sqoop-site.xml


> Expanded Metastore support for MySql, Oracle, Postgresql, MSSql, and DB2
> ------------------------------------------------------------------------
>
>                 Key: SQOOP-3216
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3216
>             Project: Sqoop
>          Issue Type: New Feature
>          Components: metastore
>            Reporter: Zach Berkowitz
>            Assignee: Zach Berkowitz
>            Priority: Minor
>             Fix For: 1.5.0
>
>         Attachments: SQOOP-3216-2.patch, SQOOP-3216-3.patch, SQOOP-3216-4.patch, SQOOP-3216.patch
>
>
> Reconfigured HsqldbJobStorage class to support MySql, Oracle, Postgresql, MSSql, and DB2 databases in addition to Hsqldb, renamed HsqldbJobStorage GenericJobStorage. This new class also serves the function of AutoHsqldbStorage, which has been removed.
> Two new commands, --meta-username and --meta-password have been added to connect to metastore databases that require a username and password. 
> Added an enum class JdbcDrivers that holds Jdbc connection information.
> Added two testClasses, MetaConnectIncrementalImportTest and JobToolTest, and modified TestSavedJobs (now SavedJobsTest) to test with all supported database services.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)