Databases
StackOverflow2013
Postsdbo
PONo suitable driver found for jdbc for SQL Server Express 2008 R2 when executing list-tables with Sqoop
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONo suitable driver found for jdbc for SQL Server Express 2008 R2 when executing list-tables with Sqoop
    primarykey
    data
    text
    <p>Can any one guide? I'm using sqljdbc4.jar from microsoft?</p> <blockquote> <p>hduser@ubuntu:/usr/local/sqoop/lib$ sqoop list-tables --connect jdbc:sqlserver/Northwind --username sa --password xxxxxxx --driver com.microsoft.sqlserver.jdbc.SQLServerDriver</p> </blockquote> <p>Result I'm getting is as follows</p> <pre><code>Warning: /usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. 13/07/08 14:45:32 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 13/07/08 14:45:32 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time. 13/07/08 14:45:32 INFO manager.SqlManager: Using default fetchSize of 1000 13/07/08 14:45:33 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLException: No suitable driver found for jdbc:sqlserver/Northwind Could not retrieve tables list from server 13/07/08 14:45:33 ERROR tool.ListTablesTool: manager.listTables() returned null </code></pre> <p>I also tried to add -libjars to the command</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSiva Karthikeyan
    1. USSiva Karthikeyan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI had refered to this URL http://danieladeniji.wordpress.com/2013/05/03/technical-hadoop-sqoop-on-cloudera-cdh/
      singulars
      1. PONo suitable driver found for jdbc for SQL Server Express 2008 R2 when executing list-tables with Sqoop
      1. USSiva Karthikeyan
    2. COAlso checked whether the port is open at the sql server using sudo nmap -sS -p 1433 sqlserver
      singulars
      1. PONo suitable driver found for jdbc for SQL Server Express 2008 R2 when executing list-tables with Sqoop
      1. USSiva Karthikeyan
    3. COI have installed sqoop under /usr/lib/sqoop and added the sqljdbc4.jar to /usr/lib/sqoop/lib
      singulars
      1. PONo suitable driver found for jdbc for SQL Server Express 2008 R2 when executing list-tables with Sqoop
      1. USSiva Karthikeyan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload