Member since
05-10-2016
2
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1398 | 02-13-2017 09:59 PM |
02-13-2017
09:59 PM
solution offered by HW: use https://sourceforge.net/projects/jtds/?source=typ_redirect drivers.
... View more
02-09-2017
08:00 PM
1 Kudo
Cannot connect to SQL Server after database is upgraded from SSL to TLS 1.2. Same without HADOOP_OPTS was working fine with no issues earlier with SSL Environmnent: Sqoop version: 1.4.6.2.3.4.23-3
java 1.7 > export SQOOP_USER_CLASSPATH=/data1/jar/sqljdbc4.jar
> export HADOOP_OPTS="-Ddeployment.security.SSLv2Hello=false -Ddeployment.security.SSLv3=false -Ddeployment.security.TLSv1=false -Ddeployment.security.TLSv1.1=true -Ddeployment.security.TLSv1.2=true -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2"
>sqoop import --libjars /data1/jar --connect jdbc:sqlserver://<hostname>:<portname> --username <user_id> --password ***** --query "SELECT <columns> FROM <table> \$CONDITIONS" --split-by <column1> --target-dir /data/external/survey --fields-terminated-by '|' --verbose
Error Message: ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secr: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:cbed7e62-1f12-42cf-956d-1a3548b44aa8".
... View more
Labels:
- Labels:
-
Apache Sqoop