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>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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>
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