[
https://issues.apache.org/jira/browse/SQOOP-382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13502131#comment-13502131
]
Jarek Jarcec Cecho commented on SQOOP-382:
------------------------------------------
1) I see, I've actually missed that it's in username and not password. However
from Sqoop perspective it shouldn't matter. Would you mind trying to put your
username, password and currentSchema into the JDBC URL instead of external
file? Something like
{code}
jdbc:sqlserver://ns74c5q6t9.database.windows.net;user=us@ns74c5q6t9;password=...;
{code}
2) You seems to have configuration file for Microsoft SQL Connector in
following path:
{code}
/usr/lib/sqoop/bin/../conf/managers.d/mssqoop-sqlserver
{code}
Based on the provided error message, I'm guess that it's content is:
{code}
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory
{code}
However this content is not valid as it should be in form of key=value pair.
You should change it to something like:
{code}
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory=/usr/lib/sqoop/lib/sqoop-sqlserver-1.0.jar
{code}
Please note that I've guessed the path based on information provided in this
JIRA. It might not be accurate and you should check that the
sqoop-sqlserver-1.0.jar is indeed stored in this location.
> Connection parameters should be used on the mapper
> --------------------------------------------------
>
> Key: SQOOP-382
> URL: https://issues.apache.org/jira/browse/SQOOP-382
> Project: Sqoop
> Issue Type: Bug
> Reporter: David Robson
>
> Currently you can specify connection parameters using --connection-param-file
> <properties-file>.
> This applies the connection parameters to the connection when generating the
> Sqoop code - but the parameters are not passed down to the mapper.
> Instead of specifying a parameters file couldn't we have a comma seperated
> list that could be specified on the command line or in sqoop-site.xml - that
> way it would be easier to override the settings per job, and they would be
> passed down to the mappers. It would then be simple to modify
> DBConfiguration.getConnection to read these.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
