Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - can not create connect in sqoop2

Copy link to this message
Re: can not create connect in sqoop2
Abraham Elmahrek 2013-07-17, 06:12
It looks like the mysql jdbc driver is missing. You should be able to
download it from http://dev.mysql.com/downloads/connector/j/. The
installation procedure will vary depending on the version of sqoop2 you are
using. If you are using latest sqoop2, you'll need to add this jar to
/usr/lib/sqoop2/lib. Otherwise, you'll have to use the addtowar.sh command
as per http://sqoop.apache.org/docs/1.99.2/Installation.html.

On Tue, Jul 16, 2013 at 8:11 PM, ch huang <[EMAIL PROTECTED]> wrote:

> hi ,all:
>    i have problem in create connection in sqoop2,anyone can help?
> sqoop:000> create connection --cid 1
> Creating connection for connector with id 1
> Please fill following values to create new connection object
> Name: first-connection
> Connection configuration
> JDBC Driver Class: com.mysql.jdbc.Driver
> JDBC Connection String: jdbc:mysql://
> Username: sqoop2
> Password: ******
> JDBC Connection Properties:
> There are currently 0 values in the map:
> entry#
> Security related configuration options
> Max connections: 123
> There are issues with entered data, please revise your input:
> Name: first-connection
> Connection configuration
> Warning message: Can't connect to the database with given credentials: No
> suitable driver found for jdbc:mysql://