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.
-Abe 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://192.168.10.118/metastore > 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://192.168.10.118/metastore > > >
