Menu

Can list-tables,. databases or import using JTDS driver in Sqoop

Help
Des
2018-08-07
2018-08-09
  • Des

    Des - 2018-08-07

    I keep getting this error on any command i execute with jtds.
    downloaded the driver jtds-1.3.1.jar
    Using Java 1.7
    SQL Server version is 13.0.4411.0

    Tried with -P and entering the password as well. Can someone please guide me where am i going wrong

    najedf@xxxxx:~#> sqoop list-tables --connect "jdbc:jtds:sqlserver:/abc.xxx.xxx.com:1433;domain=ABC.DEF.COM;integratedSecurity=true;authenticationScheme=JavaKerberos;databaseName=taleo" --username 'ABC\NAJEDF'
    Warning: /xxx/xxx/xxx/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
    Please set $ACCUMULO_HOME to the root of your Accumulo installation.
    18/08/07 08:03:52 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.14.0
    18/08/07 08:03:53 INFO manager.SqlManager: Using default fetchSize of 1000
    18/08/07 08:03:54 ERROR manager.CatalogQueryManager: Failed to list tables
    java.sql.SQLException: I/O Error: DB server closed connection.
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2481)
    at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)
    at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)
    at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
    at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
    at org.apache.sqoop.manager.CatalogQueryManager.listTables(CatalogQueryManager.java:102)
    at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
    at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
    at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
    at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
    at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
    at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
    Caused by: java.io.IOException: DB server closed connection.
    at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:852)
    at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:731)
    at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477)
    at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114)
    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2368)
    ... 15 more</init>

     
  • Des

    Des - 2018-08-09

    Does the JTDS driver support connection to SQL server with SSL encryption enabled ?

    Can someone help with this answer ?

     

    Last edit: Des 2018-08-09

Log in to post a comment.