thanks for reply ,my sqoop2 version is 1.99.1,and i have mysql-connector-java in lib path,and i can not find addtowar.sh script
# find /usr/lib/sqoop2/lib/ -name '*connect*' /usr/lib/sqoop2/lib/mysql-connector-java.jar # rpm -qa|grep sqoop2 sqoop2-server-1.99.1+115-1.cdh4.3.0.p0.11.el6.noarch sqoop2-client-1.99.1+115-1.cdh4.3.0.p0.11.el6.noarch sqoop2-1.99.1+115-1.cdh4.3.0.p0.11.el6.noarch # find / -name 'addtowar*' no output!! On Wed, Jul 17, 2013 at 2:12 PM, Abraham Elmahrek <[email protected]> wrote: > 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 >> >> >> > >
